| Week | Topic | Text Readings | Lecture Notes |
| Jan 4 | Introduction | Ch 1 | CourseInfo.pdf Intro.pdf |
| Jan 9 | The Relational Model Basic SQL |
Ch 3 (except 3.5) | RelModel.pdf |
| Jan 16 | Relational Algebra Relational Calculus |
Ch 4, Ch 15 (15.3 only) | RelAlgebra.pdf RelCalculus.pdf |
| Jan 23 | SQL | Ch 5 | SQL.pdf |
| Jan 30 | SQL | ||
| Feb 6 | SQL APIs | Ch 6 |
SQLAPI_ESQL.pdf Code samples |
| Feb 13 |
SQL APIs |
SQLAPI_JDBC.pdf Code samples |
|
| Entity-Relationship Modeling | Ch 2, Ch 3 (3.5 only) |
ER.pdf AlternateERNotation.pdf |
|
| Feb 20 | Reading Week | ||
| Feb 27 | Entity-Relationship Modeling | ||
| Mar 6 | Functional Dependencies and Normalization | Ch 19 (up to 19.7) | FDs.pdf |
| Mar 13 | Functional Dependencies and Normalization | ||
| Mar 20 | Security and Authorization | Ch 21 (up to 21.4) | Security.pdf |
| Transactions | Ch 16, Ch17 (17.1 only) | Transactions.pdf | |
| Mar 27 | Transactions | ||
| Apr 3 | Transactions |