Note: This lecture schedule is tentative and may change.
| Date | Topic | Slides | Assignments |
|---|---|---|---|
| 8/24 | Course Introduction | PPTX | Homework 0 (due 9/1 at noon) |
| 8/29 | SQL 1 | PPTX | Homework 1 (due 9/7) |
| 8/31 | SQL II | PPTX | |
| 9/5 | NO LECTURE - LABOR DAY | ||
| 9/7 | Disks & Files | PPTX v2 | |
| 9/12 | Files & Indexes | PPTX v2 | Homework 2 (due 9/22) |
| 9/14 | B+ Trees | PPTX | |
| 9/19 | Files & Buffers | PPTX | |
| 9/21 | Sorting & Hashing | PPTX | Project 1 (due 10/13) |
| 9/26 | Relational Algebra | PPTX | Homework 3 (due 10/3) |
| 9/28 | Iterators | PPTX | |
| 10/3 | Join Algorithms | PPTX | |
| 10/5 | Midterm 1 (covers up to 9/26 lecture) | ||
| 10/10 | Query Optimization I | PPTX | Homework 4 (due 10/17) |
| 10/12 | Query Optimization II | ||
| 10/17 | Transactions & Concurrency Control I | PPTX | |
| 10/19 | Transactions & Concurrency Control II | ||
| 10/24 | Recovery I | PPTX | Homework 5 (due 11/7) |
| 10/26 | Recovery II | Project 2 (due 11/16) | |
| 10/31 | ER Modeling | PPTX | |
| 11/2 | Functional Dependencies & Normalization | PPTX | Homework 6 (due 11/18) |
| 11/7 | Midterm II (covers up to 10/31 lecture) | ||
| 11/9 | Parallel Databases | PPTX(1) PPTX(2) | |
| 11/14 | Data Warehousing & Decision Support | PPTX (1) PPTX (2) | |
| 11/16 | NoSQL | PPTX | |
| 11/18 | Project 3 (due 12/6) | ||
| 11/21 | Hadoop & Spark | PPTX | |
| 11/23 | NO LECTURE - THANKSGIVING | ||
| 11/28 | Streaming Computation | PPTX | |
| 11/30 | Final Lecture | PPTX | |
| 12/16 | Final Exam |