Schedule

Date Topic Slides Notes Video
Jan 17 Lecture #00: Course Overview & Logistics (No In-Class Lecture)
Slides:
Video:
Jan 22 Lecture #01: Modern Analytical Database Systems
Slides:
Video:
Jan 24 Lecture #02: Data Formats & Encoding I
Slides:
Notes:
Video:
Jan 29 Lecture #03: Data Formats & Encoding II
Slides:
Notes:
Video:
Jan 31 Student Project Proposals
Feb 05 Lecture #04: Query Execution & Processing I
Slides:
Notes:
Video:
Feb 07 Lecture #05: Query Execution & Processing II
Slides:
Notes:
Video:
Feb 12 Lecture #06: Vectorized Query Execution
Slides:
Notes:
Video:
Feb 14 Lecture #07: Code Generation & Compilation
Slides:
Video:
Feb 19 Lecture #08: Scheduling & Coordination
Slides:
Video:
Feb 21 Lecture #09: Hash Join Algorithms
Slides:
Video:
Feb 26 Lecture #10: Multi-Way Join Algorithms
Slides:
Video:
Feb 28 Student Project Updates
Mar 04 Spring Break — No Class
Mar 06 Spring Break — No Class
Mar 11 Lecture #11: Server-side Logic Execution
Mar 13 Lecture #12: Networking Protocols
Mar 18 Lecture #13: Optimizer Implementation I
Mar 20 Lecture #14: Optimizer Implementation II
Mar 25 Lecture #15: Optimizer Implementation III
Mar 27 Lecture #16: Cost Models
Apr 01 Student Project Updates
Apr 03 Lecture #17: System Analysis (Google Dremel / BigQuery)
Apr 08 Lecture #18: System Analysis (Databricks / Spark)
Apr 10 Lecture #19: System Analysis (Snowflake)
Apr 15 Lecture #20: System Analysis (DuckDB)
Apr 17 Lecture #21: System Analysis (Yellowbrick)
Apr 22 Lecture #22: System Analysis (Amazon Redshift)
Apr 24 Lecture #23: System Analysis (Microsoft Azure Synapse)