SQL example file

This file is used to create the examples described in the lectures. It should be used by "sqlite3 < student-3.sql"

Older SQL lectures

Show grouping operations.

More SQL

outer joins union queries

Example sql file

Creates a simple SQLite database. Note how referential integrity is enforced.

INFO2009 - Team 'DROP TABLE groups;

Edshare for INFO2009 coursework 2 - Team 'DROP TABLE groups;

Database lectures Part 3

More on SQL