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 lecture series from Carnegie Mellon University's Fall 2023 semester. Begin with foundational topics including the relational model, algebra, and modern SQL before diving deep into database storage mechanisms, memory management, and disk I/O operations. Master essential data structures like hash tables and B+Tree indexes, then advance to complex algorithms for sorting, aggregation, and joins. Learn query execution strategies and optimization techniques that power modern database engines. Understand critical concurrency control theories including two-phase locking, timestamp ordering, and multi-version concurrency control to handle simultaneous database operations. Examine database logging and recovery mechanisms that ensure data integrity and system reliability. Progress to distributed database architectures, exploring transaction processing across multiple nodes and data warehouse OLAP systems for analytical workloads. Gain practical insights through real-world database system examples including SingleStore, Redis, CockroachDB, Snowflake, MongoDB, and TabDB, understanding how theoretical concepts apply in production environments.
