| Date | Lecture Topics | Readings | Notes |
| Jan 3 | course overview | Chapter 1, Chapter 3.1-3.4 | |
| Jan 8 | relational model, relational algebra | Chapter 4 | |
| Jan 10 | relational calculus, SQL intro | Chapter 3.6-3.7, Chapter 5.1-5.6 | |
| Jan 15 | SQL | ||
| Jan 17 | SQL | ||
| Jan 22 | SQL | ||
| Jan 24 | SQL APIs | Chapter 5.7-5.10 | |
| Jan 29 | SQL APIs, ER models | Chapter 2, 3.5 | |
| Jan 31 | ER models | A1 due | |
| Feb 5 | ER models | ||
| Feb 7 | no class - Exam 1 | ||
| Feb 12 | FDs and Normalization | Chapter 15.1-15.7.1 | |
| Feb 14 | FDs and Normalization | ||
| Feb 19 | FDs and Normalization | ||
| Feb 26 | transactions, serializability | Chapter 18, 19, 20 | last day for A1 remark requests |
| Feb 28 | isolation levels, concurrency control | A2 due, last day for Exam 1 remark requests | |
| Mar 5 | transactional recovery | ||
| Mar 7 | file structures, physical design | Chapter 7, 8, 9, 16.1-16.6 | |
| Mar 12 | no class - Exam 2 | ||
| Mar 14 | file structures, query processing | Chapter 11.1-11.2, 12, 13.1 | |
| Mar 19 | query processing | ||
| Mar 21 | query processing | ||
| Mar 26 | query optimization | Chapter 13.2-13.4, Chapter 14 | |
| Mar 28 | query optimization | A3 due, last day for Exam 2 and Asst 2 remark requests |
Maintained by K. Salem