Carnegie Mellon University

Yes, this is the premier course at Carnegie Mellon University on the design and implementation of database management systems. Topics include data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexes + filters (order preserving trees, hash tables, vector indexes), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed). The course is appropriate for students that are prepared to sweat their systems programming skills.

See Schedule for Lecture Recordings https://15445.courses.cs.cmu.edu/fall2024/

Youtube Playlist Course Overview & Logistics (CMU Intro to Database Systems)