In class SQL demos
To open the sql files directly in SQL Server, click "save as" and remove the .txt extension.

SQL script to create the Northwind database (sql) and Pubs database (sql )

Installation walkthrough for SQL Server 2005 Exp Ed (doc)

Subqueries:
SELECT (sql )
FROM (sql )
WHERE (sql)
GROUP BY (sql)
HAVING (sql)
OUTER JOINS (sql)
UNION (sql)
DIVISION ANY ALL (sql)

Old ppt slides illustrating SQL (ppt )

Homework

Course project

SQLexerciseSystem
Login

Link to last semester's materials