This course on Intro to Database Systems covers a wide range of topics including the relational model, SQL, database storage, buffer pools, hash tables, tree indexes, index concurrency control, sorting, join algorithms, query execution, query planning and optimization, concurrency control theory, distributed databases, and more. The course aims to teach students the fundamentals of database systems and various advanced concepts related to database management. The teaching method includes lectures, hands-on exercises, and possibly assignments or projects. This course is intended for students or professionals interested in gaining a comprehensive understanding of database systems and enhancing their skills in this area.
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
