Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
presentation notes on sql presented to nashville software school
Branch: master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
README.md
cart.sqlite
example.sql
pres.key
pres.pdf
students.sqlite
students_postgres_dump.sql

README.md

Entry to SQL presentation Discusses Tables, Indexes, Queries, Joins

the pres.key or pres.pdf are the starting point

if you want to play along you can install Install the Sqlite Manager plugin for firefox https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

also there is a sql file that can be loaded into postgres if you have that installed

Here are some sql fiddler links to help you help you follow along

Example of cart queries

http://sqlfiddle.com/#!12/1cd4d/8

Types of selects

http://sqlfiddle.com/#!12/1cd4d/13

Querying for courses

http://sqlfiddle.com/#!12/151a4/18

OUTER JOIN Differences

http://sqlfiddle.com/#!12/151a4/23

Something went wrong with that request. Please try again.