3 & 5 March: SQL queries

What we are up to

This week we look at the query operators of SQL.

Lecturing

• CSCI 343 SQL notes

Reading

• SQL technique section of Database design with UML and SQL by Tom Jewett
• SQL Tutorial at w3schools.com

Software

• SQLite
• Sqliteman
• movie ratings sql
• SQLiteSpy

Video

• Jennifer Widon for Stanford CS 145
  • SQL — Introduction
  • SQL — Basic SELECT statement
  • SQL — Table Variables and Set Operators
  • SQL — Subqueries in FROM and SELECT clauses
  • SQL — Aggregation
  • SQL — NULL values
• Bill Weinman in SQL Essential Training at lynda.com
  • Episode 3: SQL Essentials
• Simon Allardice in Foundations of Programming: Databases at lynda.com
  • Episode 6: Database Modeling: Querying