| Week | Topic | Textbook Chapters, Additional References | Slides |
| | | |
| 1-2 | Introduction; Recap of Relational Algebra and SQL | Ch 1, 4, 5.1-5.6 | PPTX PDF |
| 2-3 | Data Storage; Buffer Management; File Organization | Ch 8, except 8.5.4, Ch 9, except 9.2 | PPTX PDF |
| 2 | Talk by the TA on Project 1 on Apr 14 | – | |
| 3-4 | Indexing (B+ Tree; Hash Index) | Ch 10, Ch 11, sections 11.1-11.2 only | PPTX PDF |
| 4 | External Sorting | Ch 13 | PPTX PDF |
| 4 | Talk by the TA on Project 2 on Apr 28 | – | |
| 5 | Quiz 1 on Mon, May 1 | - | |
| 5 | Industry guest lecture by on Fri, May 5
by Justin Levandoski (Google) | – | |
| 5-7 | Relational Operator Implementations; Query Processing | Ch 12, sections 12.1-12.3, Ch 14 | PPTX PDF |
| 6 | Review discussion on Thu, May 11 | – | |
| 7 | Midterm Exam on Mon, May 15 | – | – |
| 7-8 | Query Optimization | Ch 12, sections 12.4 - 12.6 | PPTX PDF |
| 8 | Quiz 2 on Fri, May 26 | - | |
| 9 | Memorial Day Holiday on Mon, May 29 | - | |
| 9 | Industry guest lecture by on Wed, May 31
by Yannis Papkonstantinou (Databricks) | – | |
| 9-10 | Parallel RDBMSs and Dataflow Systems | Ch 22, till 22.5 | PPTX PDF |
| 10 | ML for RDBMSs (Optional; Not in syllabus) | - | PPTX PDF |
| 10 | Review discussion on Fri, Jun 9 | – | |
| 11 | Final Exam on Thu, Jun 15 | – | –
|