This course on Intro to Database Systems aims to teach students the fundamentals of database management. By the end of the course, learners will be able to understand the relational model, advanced SQL, database storage, indexing techniques, query optimization, concurrency control, and distributed databases. The course covers a wide range of topics including buffer pools, hash tables, join algorithms, database recovery, and various database systems like Oracle, MongoDB, and CockroachDB. The teaching method involves lectures, hands-on exercises, and real-world examples. This course is intended for students and professionals interested in gaining a comprehensive understanding of database systems.
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
