| 35% | |
| 17.5% | |
| 17.5% | |
| 30% |
| Date | Lecture Topic | Notes | Supplemental | Due | |
| Sep 26 | introduction | ||||
| Sep 28 | database concepts | relations | terms | ||
| Sep 30 | data modeling | requirements analysis | |||
| Oct 3 | ER Models | ER Basics | |||
| Oct 5 | Relational Keys | key exercise | |||
| Oct 7 | More ER Modeling | More ER Basics | ER example 2 | Assignment 1 | |
| Oct 10 | Modeling with ER Studio | relationship types, relationship examples | |||
| Oct 12 | Modeling with ER Studio | relational key terminology | |||
| Oct 14 | More ER Studio Modeling | ER Modeling Difficulties | |||
| Oct 17 | More ER Studio modeling | Data Types | Assignment 2 | ||
| Oct 19 | Normalization | Normalization | wikiNormalization | ||
| Oct 21 | Starting SQL | SQL intro | sql | ||
| Oct 24 | Simple Joins in SQL | SQL joins | Assignment 3 | ||
| Oct 26 | Joins Again | join, union | |||
| Oct 28 | History of SQL, MySQL | relational algebra | |||
| Oct 31 | test review | Assignment 4 | |||
| Nov 2 | Test 1 | ||||
| Nov 4 | PHP Review | PHP Arrays and Loops | php's foreach, more php | ||
| Nov 7 | More PHP | ||||
| Nov 9 | SQL Outer Joins and Functions | common SQL functions | |||
| Nov 11 | SQL Functions and Views | Assignment 5 | |||
| Nov 14 | SQL Set Operations | DML and subqueries | select at wikibooks | ||
| Nov 16 | SQL Aggregates | execution order | part 1 final project due | ||
| Nov 18 | SQL Group By | hard sql | |||
| Nov 21 | SQL Transactions and Concurrency | transactions | |||
| Nov 23 | tbd | Assignment 6 | |||
| Nov 24 | no class: Thanksgiving | ||||
| Nov 28 | test review | ||||
| Nov 30 | test 2 | ||||
| Dec 2 | open class to discuss project | ||||
| Dec 6 | final project due | Final project |