Syllabus
New
Download SQL Server 2005 at MSDNAA
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)
SELECT I (sql)
SELECT II (sql)
SELECT III (sql)
Aggregate functions (sql)
Dates (sql)
GROUP BY Intro (sql)
GROUP BY I (sql)
LIKE (sql)
JOIN I (sql) Northwind customer order 10250 (xls)
JOIN II (sql)
Outer Joins (sql)
ppt slides illustrating SQL (ppt)
Power
Point slides
Chapter
2
Chapter 3,
Many-to-Many
Chapter 5 - Normalization
Chapter 4 - Entity Relationship Modeling (ERD)
Itemized List
Template Workbook (doc)
Transaction management (sql)
Triggers and Stored
procedures (sql)
Views (sql)
Course Project
specifications (doc)
Create an account on the SQL Exercise System.
[home]