Dive into a comprehensive course on database systems offered by Carnegie Mellon University. Explore fundamental concepts starting with the relational model and SQL, then delve into advanced topics such as database storage, buffer pools, indexing, and query execution. Learn about various join algorithms, query planning, and optimization techniques. Gain insights into concurrency control methods, including two-phase locking, timestamp ordering, and multi-version concurrency control. Understand database logging, recovery processes, and distributed database systems for both OLTP and OLAP environments. Through 25 in-depth lectures spanning over 30 hours, acquire a solid foundation in database management systems, preparing you for both academic and real-world applications in the field of data management.
Overview
Syllabus
01 - Course Introduction & Relational Model (CMU Intro to Database Systems / Fall 2021).
02 - Intermediate SQL (CMU Intro to Database Systems / Fall 2021).
03 - Database Storage I (CMU Intro to Database Systems / Fall 2021).
04 - Database Storage II (CMU Intro to Database Systems / Fall 2021).
05 - Buffer Pools (CMU Intro to Database Systems / Fall 2021).
06 - Hash Tables (CMU Intro to Database Systems / Fall 2021).
07 - Tree Indexes (CMU Intro to Database Systems / Fall 2021).
08 - Index Concurrency Control (CMU Intro to Database Systems / Fall 2021).
09 - Sorting & Aggregations (CMU Intro to Database Systems / Fall 2021).
10 - Join Algorithms (CMU Intro to Database Systems / Fall 2021).
11 - Query Execution I (CMU Intro to Database Systems / Fall 2021).
12 - Query Execution II (CMU Intro to Database Systems / Fall 2021).
13 - Query Planning & Optimization I (CMU Intro to Database Systems / Fall 2021).
14 - Query Planning & Optimization II (CMU Intro to Database Systems / Fall 2021).
15 - Concurrency Control Theory (CMU Intro to Database Systems / Fall 2021).
16 - Two-Phase Locking Concurrency Control (CMU Intro to Database Systems / Fall 2021).
17 - Timestamp Ordering Concurrency Control (CMU Intro to Database Systems / Fall 2021).
18 - Multi-Version Concurrency Control (CMU Intro to Database Systems / Fall 2021).
19 - Database Logging (CMU Intro to Database Systems / Fall 2021).
20 - Database Recovery (CMU Intro to Database Systems / Fall 2021).
21 - Introduction to Distributed Databases (CMU Intro to Database Systems / Fall 2021).
22 - Distributed OLTP Databases (CMU Intro to Database Systems / Fall 2021).
23 - Distributed OLAP Databases (CMU Intro to Database Systems / Fall 2021).
25 - Final Review (CMU Intro to Database Systems / Fall 2021).
Taught by
CMU Database group
