This course on Intro to Database Systems covers topics such as the relational data model, advanced SQL, database storage, buffer pools, index concurrency control, query processing, sorting algorithms, concurrency control theory, and distributed databases. The course aims to teach students the fundamentals of database systems, including various storage techniques, indexing methods, query optimization, and concurrency control. The teaching method involves lectures, discussions, and hands-on assignments. The course is intended for students interested in gaining a comprehensive understanding of database systems and those pursuing a career in database management or related fields.
Overview
Syllabus
CMU Database Systems - 01 Course introduction & Relational Data Model (Fall 2018).
CMU Database Systems - 02 Advanced SQL (Fall 2018).
CMU Database Systems - 03 Database Storage I (Fall 2018).
CMU Database Systems - 04 Database Storage II (Fall 2018).
CMU Database Systems - 05 Buffer Pools (Fall 2018).
CMU Database Systems - 06 Hash Tables (Fall 2018).
CMU Database Systems - 07 Tree Indexes Part I (Fall 2018).
CMU Database Systems - 08 Tree Indexes Part II (Fall 2018).
CMU Database Systems - 09 Index Concurrency Control (Fall 2018).
CMU Database Systems - 10 Query Processing (Fall 2018).
CMU Database Systems - 11 Sorting & Aggregation Algorithms (Fall 2018).
CMU Database Systems - 12 Join Algorithms (Fall 2018).
CMU Database Systems - 13 Query Optimization (Fall 2018).
CMU Database Systems - 14 Parallel Execution (Fall 2018).
CMU Database Systems - 15 Embedded Logic (Fall 2018).
CMU Database Systems - 16 Concurrency Control Theory (Fall 2018).
CMU Database Systems - 17 Two-Phase Locking Concurrency Control (Fall 2018).
CMU Database Systems - 18 Timestamp Ordering Concurrency Control (Fall 2018).
CMU Database Systems - 19 Multi-Version Concurrency Control (Fall 2018).
CMU Database Systems - 20 Logging Schemes (Fall 2018).
CMU Database Systems - 21 Database Recovery (Fall 2018).
CMU Database Systems - 22 Distributed OLTP Databases Part I (Fall 2018).
CMU Database Systems - 23 Distributed OLTP Databases Part II (Fall 2018).
CMU Database Systems - 24 Distributed OLAP Databases (Fall 2018).
CMU Database Systems - 25 Ethan Zhang [VoltDB] (Fall 2018).
CMU Database Systems - 26 Systems Potpourri [CockroachDB, Spanner, MongoDB] (Fall 2018).
Taught by
CMU Database group
