Intro to Database Systems - Fall 2019
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.