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

Sql Server 2008 step-by-step installation instructions (doc)

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

Offline version of Race database (zip) with instructions (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 )

Chapter 3: (sql) and Tokenized tables Kroenke (ppt)
Chapter 4: Kroenke (ppt)

ERD Modeling
  Itemized List Template (doc)
  Kroenke
     chapter 5 part 1(ppt) part 2 (ppt) part 3 (ppt)
     chapter 6 part 1(ppt) part 2 (ppt ) M:N relationships (ppt)

AMCIS example
  CREATE TABLE (sql)
  Enforce constraints (sql)
  Sample data  (sql)
  Max and Min Cardinality constraints  (sql)

Triggers and Row Level Audit tables  (sql) Audit tables: (link)

Managing Multiuser databases (sql) (ppt)
Indexes (sql)
VIEWS (sql)
Cursors and Temporary tables (sql)

Homework
Sql performance analysis (doc)

Course project
Project document (doc) due December 2, 2008

SQLexerciseSystem
Login

Link to last semester's materials