| Week | Lecture | Topic | Speaker | Materials |
|---|---|---|---|---|
| 1 (Sep 10) | 1 | Course introduction; Structured Data Management: Introduction to Database Systems | Yuhan Liu & Mahdi Esmailoghli | 01 Lecture Notes 02 Course Info 03 Introduction |
| 2 (Sep 15) | 1 | Introduction to Database Systems | Yuhan Liu | |
| 2 | Relational model of data, relational calculus & algebra | Yuhan Liu | Relational Model | |
| 3 (Sep 22) | 1 | Relational algebra, SQL | Yuhan Liu | |
| 2 | Database Workloads (OLTP, OLAP & HTAP systems) | Anil Goel | ||
| 4 (Sep 29) | 1 | Big data: Dealing with volume | Yuhan Liu | |
| 2 | Big data: Dealing with volume | Yuhan Liu | ||
| 5 (Oct 6) | 1 | Big data: Dealing with variety | Yuhan Liu | |
| 2 | Big data: Dealing with variety + velocity | Yuhan Liu | ||
| 6 (Oct 10–18) | Reading week - no classes | - | ||
| 7 (Oct 20) | 1 | Big data: Dealing with velocity | Yuhan Liu | |
| 2 | Cloud computing & cloud-native data management | Yuhan Liu | ||
| 8 (Oct 27) | 1 | Data integration: Data warehouses | Prof. Tamer Özsu | |
| 2 | Data integration: Data lakes | Mahdi Esmailoghli | ||
| 9 (Nov 3) | 1 | Data preparation pipeline | Mahdi Esmailoghli | |
| 2 | Data integration: Model lakes | Prof. Renée J. Miller | ||
| 10 (Nov 10) | 1 | Data version management | Prof. Roee Shraga | |
| 2 | LLMs and data management | Mahdi Esmailoghli | ||
| 11 (Nov 17) | 1 | Data quality & data cleaning | Mahdi Esmailoghli | |
| 2 | Data provenance | Prof. Boris Glavic | ||
| 12 (Nov 24) | 1 | Data quality & data cleaning | Prof. Lukasz Golab | |
| 2 | Data profiling (virtual lecture over Zoom) | Prof. Hazar Harmouch | ||
| 13 (Dec 1) | 1 | Vector databases | Prof. Karima Echihabi | |
| 2 | Review and general discussion | Yuhan Liu & Mahdi Esmailoghli | ||
| 14 (Dec 8) | Reserved (buffer day in case a class needs to be rescheduled) | |||
| TBD | Final Exam (Time TBD) Location TBD |