CMU 15-799: Special Topics in Databases: Query Optimization (Spring 2025)

Schedule (with readings & lectures): https://15799.courses.cs.cmu.edu/spring2025/schedule.html

Lectures YouTube Playlist: https://www.youtube.com/playlist?list=PLSE8ODhjZXjYCZfIbmEWH...

Announcement: https://discuss.systems/@andy_pavlo/113839208543526204

"New @CMUDB Course: Database Query Optimization

This is a special topics course on how to build a SQL optimizer from scratch covering foundational and state-of-the-art implementations. All lectures available on Youtube: https://15799.courses.cs.cmu.edu/spring2025/

One topic we will discuss is the Cascades optimizer architecture. There has never been a good description of how to implement it but the Microsoft Research Database Group just published a book that describes SQL Server's implementation. Microsoft has made the entire book available for free: https://www.microsoft.com/en-us/research/publication/extensi...

Query optimization is the hardest topic in databases and this is the first time I am offering this course. I am going to make mistakes and say incorrect things in my lectures. Send corrections to db-mistakes@cs.cmu.edu"