Schedule (with readings & lectures): <a href="https://15799.courses.cs.cmu.edu/spring2025/schedule.html" rel="nofollow">https://15799.courses.cs.cmu.edu/spring2025/schedule.html</a><p>Lectures YouTube Playlist: <a href="https://www.youtube.com/playlist?list=PLSE8ODhjZXjYCZfIbmEWH7f6MnYqyPwCE" rel="nofollow">https://www.youtube.com/playlist?list=PLSE8ODhjZXjYCZfIbmEWH...</a><p>Announcement: <a href="https://discuss.systems/@andy_pavlo/113839208543526204" rel="nofollow">https://discuss.systems/@andy_pavlo/113839208543526204</a><p>"New @CMUDB Course: Database Query Optimization<p>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: <a href="https://15799.courses.cs.cmu.edu/spring2025/" rel="nofollow">https://15799.courses.cs.cmu.edu/spring2025/</a><p>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: <a href="https://www.microsoft.com/en-us/research/publication/extensible-query-optimizers-in-practice/" rel="nofollow">https://www.microsoft.com/en-us/research/publication/extensi...</a><p>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"