| Date | Lecture Topic | Homework |
| 1/21 | Intro Lecture (Chap1) | Pass out HW0. |
| 1/23 | Relational Model (Chap3) | |
| 1/28 | Disks,Buffers,Files (Chap9). | HW0 due. Pass out HW1. |
| 1/30 | File Organizations and Indexing (Chap8). | |
| 2/04 | Tree-Structured Indexes (Chap10). | |
| 2/06 | Sorting (Chap13). | |
| 2/11 | Unary Hashing. | HW 1 due. Pass out HW2. |
| 2/13 | ER Models (Chap2) | |
| 2/18 | Relational Algebra (Chap4) | |
| 2/20 | Relational Calculus (Chap4) | |
| 2/25 | SQL: The Query Language (Chap5) | |
| 2/27 | SQL: The Query Language, cont (Chap 5). | |
| 3/04 | SQL: Constraints and APIs (Chap5) | HW 2 due. Pass out HW 3. |
| 3/06 | Relational Operators (Chap14) | |
| 3/11 | Relational Operators, cont. | HW 3 due. |
| 3/13 | Query Optimization (Chap15) | |
| 3/18 | Query Optimization, cont. | Pass out HW4. |
| 3/20 | Boolean Search | |
| 3/21 | | HW 4 due. |
| 4/01 | Physical Design & Tuning (Chap20). | Pass out HW 5. |
| 4/03 | Physical Design & Tuning, cont. | |
| 4/08 | Schema Refinement & Normalization, (Chap19) | |
| 4/10 | Schema Refinement & Normalization, cont. | |
| 4/17 | Concurrency Control (Chap17). | HW 5 due. |
| 4/15 | Transaction Management Overview (Chap16) | |
| 4/22 | Concurrency Control, cont. | |
| 4/24 | Logging and Recovery (Chap18) | |
| 4/29 | Logging and Recovery, cont. | |
| 5/01 | Ranked information retrieval (tentative) | |
| 5/13 | Wrapup | |
