about/home code research teaching CV/resume stuff links blogs 100in1001

Syllabus

SQL Environment Downloads

• MySQL Community Server and Workbench
• MS SQL Server Express 2008 - Runtime with Advanced Services edition

Slides

• Topic 1: Introduction
• Topic 2: Data Models and Design
• Topic 3: Relational Model
• Topic 4: Entity Relationships
• Topic 5: Advanced Data Modeling
• Topic 6: Normalization
• Topic 7: SQL
  • Creation and Modification Examples
  • Sale Co Database
  • Review questions Database
  • Some Light Reading
• Topic 8: More SQL
  • Aviation DB creation script for homework
• Topic 9: Advanced SQL
  • Joins Database
  • Joins SQL Script
  • Script to create the Join database
• Topic 10: Finishing Up

Projects

• Project 1 due March 18
• Project 1 ERD
• Project 2 due April 8
• Project 2 ERD
• Project 2 SQL Script
• Project 3 due April 29
• Project 4 due May 6

SQL Links

• SQL Reference
• Microsoft MSDN for SQL
• Data Types Reference