| Week Number | Date | Topics and due dates | Reading |
| Week 1 | Jan. 25 | Course outline and Questionnaire | |
| Jan. 27 | Introduction | Ch.1 | |
| Week 2 | Feb. 1 | ER-model design (1) | Ch.2 |
| Feb. 3 | ER-model design (2) | Ch.2 | |
| Week 3 | Feb. 8 | Relational Model (1) | Ch.3 |
| Feb. 10 | Relational Model (2) | Ch.3 | |
| Feb. 11 | Milestone 1 due | ||
| Week 4 | Feb. 15 | SQL (1) | Ch.5 |
| Feb. 17 | SQL (2) | Ch.5 | |
| Feb. 18 | Homework 1 due | ||
| Week 5 | Feb. 22 | SQL (3) | Ch.5 |
| Feb. 24 | Storing and Indexing | Ch.8 | |
| Feb. 25 | Milestone 2 due | ||
| Week 6 | Mar. 1 | Data Storage | Ch.9 |
| Mar. 3 | Tree indexes | Ch.10 | |
| Mar. 4 | Homework 2 due | ||
| Week 7 | Mar. 8 | Hash indexes | Ch.11 |
| Mar. 10 | Midterm | ||
| Week 8 | Mar. 15-17 | Spring break | |
| Week 9 | Mar. 22 | Normalization (1) | Ch. 19 |
| Mar. 24 | Midterm review, Normalization (2) | Ch. 19 | |
| Week 10 | Mar. 29 | Normalization (3) | Ch. 19 |
| Mar. 31 | Physical DB Design, Tuning | Ch.20 | |
| Week 11 | Apr. 4 | Milestone 3 due | |
| Apr. 5 | Query Optimization | Ch.12 | |
| Apr. 7 | External sorting | Ch.13 | |
| Week 12 | Apr. 11 | Indexing project due | Apr. 12 | Evaluating of Relational Operators | Ch.14 |
| Apr. 14 | A Typical Relational Optimizer | Ch.15 | |
| Week 13 | Apr. 18 | Homework 3 due | |
| Apr. 19 | Transaction Management | Ch.16 | |
| Apr. 21 | Concurrency Control class ends at 4pm due to Easter Holiday | Ch.17 | |
| Week 14 | Apr. 25 | Milestone 4 due | |
| Apr. 26 | Database-Backed Internet Applications Database Application Development | Ch.6-7 | |
| Apr. 28 | Crash Recovery | Ch.18 | |
| Week 15 | May 2 | Homework 4 due | |
| May 3 | Security and Authorization | Ch.21 | |
| May 5 | BigTable Slides by Jeff Dean (one of the authors) | ||
| Week 16 | May 10 | Project presentation | |
| May 12 | Final exam review | ||
| May 17 | Final exam at 3pm | ||
| May 20 | Database project demo due | ||
| May 21 | Milestone 5 due Index Project Extra Credit Part II due |