Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore the fundamental concepts and advanced techniques of database systems through this comprehensive university course from Carnegie Mellon University's Database Group. Master the relational model and algebra, modern SQL techniques, and database storage mechanisms including files, pages, and tuples. Dive deep into memory management, buffer pools, and log-structured storage systems while examining column-store databases and various indexing strategies. Learn essential data structures including hash tables, B+Trees, vector indexes, inverted indexes, skip lists, and bloom filters, along with latching mechanisms for concurrent access. Study sorting and aggregation algorithms, join algorithms (hash joins, sort-merge joins, nested loop joins), and query execution strategies. Understand parallel query engine architectures and query optimization techniques across two detailed sessions. Examine concurrency control theory, two-phase locking, timestamp ordering, and multi-version concurrency control (MVCC) systems. Explore database recovery mechanisms including write-ahead logging and shadow paging, then advance to distributed database concepts and architectures. The course features guest database talks from industry leaders including dbt, SingleStore, YugabyteDB, MotherDuck, SpiralDB, Firebolt, ClickHouse, and RelationalAI, providing real-world perspectives on database implementation and optimization. Access hands-on projects and homework assignments through the official course website to reinforce theoretical concepts with practical application.
