Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore comprehensive database systems fundamentals through this university-level course from Carnegie Mellon University's Fall 2022 semester. Master the relational model and relational algebra as foundational concepts, then advance through modern SQL techniques and database storage architectures including columnar databases and compression methods. Dive deep into memory management systems, buffer caches, and essential data structures like hash tables and B+Tree indexes, progressing to concurrent indexing strategies. Learn critical algorithms for sorting, aggregation, and joins, while understanding query execution models and parallel processing techniques. Develop expertise in query planning and optimization strategies, then tackle advanced concurrency control theory including two-phase locking, timestamp-ordering, and multi-version concurrency control (MVCC). Study database reliability through logging, shadow paging, and recovery mechanisms using the ARIES algorithm. Expand your knowledge to distributed database systems, covering both transactional and analytical architectures, and explore embedded database logic implementation. Gain insights into modern cloud database architectures through real-world examples like Snowflake, and participate in interactive Q&A sessions to reinforce learning concepts across all 26 comprehensive lectures.
