Intro to Database Systems - Fall 2018
Dive into the world of database systems with this comprehensive lecture series from Carnegie Mellon University's Fall 2018 course. Explore fundamental concepts starting with the relational data model and advanced SQL, then progress through database storage, buffer pools, and various indexing techniques. Learn about query processing, optimization, and execution, including sorting, aggregation, and join algorithms. Delve into concurrency control theories and implementations, covering two-phase locking, timestamp ordering, and multi-version approaches. Understand logging schemes, database recovery, and distributed database architectures for both OLTP and OLAP systems. Gain insights from industry perspectives on modern database systems like VoltDB, CockroachDB, Spanner, and MongoDB. Master the intricacies of database systems through 26 in-depth lectures, providing a solid foundation for both academic understanding and practical application in the field of database management.