Overview
Syllabus
01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019).
02 - Advanced SQL (CMU Databases Systems / Fall 2019).
03 - Database Storage I (CMU Databases Systems / Fall 2019).
04 - Database Storage II (CMU Databases Systems / Fall 2019).
05 - Buffer Pools + Memory Management (CMU Databases Systems / Fall 2019).
06 - Hash Tables (CMU Databases Systems / Fall 2019).
07 - Tree Indexes I (CMU Databases Systems / Fall 2019).
08 - Tree Indexes II (CMU Databases Systems / Fall 2019).
09 - Multi-Threaded Index Concurrency Control (CMU Databases Systems / Fall 2019).
10 - Sorting & Aggregations (CMU Databases Systems / Fall 2019).
11 - Join Algorithms (CMU Databases Systems / Fall 2019).
12 - Query Execution I (CMU Databases Systems / Fall 2019).
13 - Query Execution II (CMU Databases Systems / Fall 2019).
14 - Query Planning & Optimization I (CMU Databases Systems / Fall 2019).
15 - Query Planning & Optimization II (CMU Databases Systems / Fall 2019).
16 - Concurrency Control Theory (CMU Databases Systems / Fall 2019).
17 - Two-Phase Locking Concurrency Control (CMU Databases Systems / Fall 2019).
18 - Timestamp Ordering Concurrency Control (CMU Databases Systems / Fall 2019).
19 - Multi-Version Concurrency Control (CMU Databases Systems / Fall 2019).
20 - Database Logging Schemes (CMU Databases Systems / Fall 2019).
21 - ARIES Database Recovery (CMU Databases Systems / Fall 2019).
22 - Introduction to Distributed Databases (CMU Databases Systems / Fall 2019).
23 - Distributed OLTP Databases (CMU Databases Systems / Fall 2019).
24 - Distributed OLAP Databases (CMU Databases Systems / Fall 2019).
25 - Shasank Chavan (Oracle In-Memory Databases) (CMU Databases Systems / Fall 2019).
26 - Systems Potpourri (Facebook Scuba, MongoDB, CockroachDB) (CMU Databases Systems / Fall 2019).
Taught by
CMU Database group