Intro to Database Systems - Fall 2019

Overview

Dive into a comprehensive database systems course from Carnegie Mellon University spanning 32 hours. Begin with an introduction to relational models and advanced SQL before exploring database storage, buffer pools, and memory management. Progress through hash tables, tree indexes, and multi-threaded index concurrency control. Learn about sorting, aggregations, and join algorithms before delving into query execution, planning, and optimization. Study various concurrency control theories and implementations, including two-phase locking, timestamp ordering, and multi-version approaches. Explore database logging schemes, recovery methods like ARIES, and distributed database concepts for both OLTP and OLAP systems. Conclude with special topics including Oracle In-Memory Databases, Facebook Scuba, MongoDB, and CockroachDB, providing a well-rounded understanding of modern database systems and their applications.

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).