Intro to Database Systems - Fall 2017

Intro to Database Systems - Fall 2017

Dive into the world of database systems with this comprehensive lecture series from Carnegie Mellon University's Fall 2017 course. Learn about relational data models, SQL, database storage, query processing, concurrency control, and distributed systems. Explore topics ranging from basic concepts to advanced techniques, including functional dependencies, normal forms, buffer pools, hash tables, query optimization, and recovery schemes. Gain insights into both online transaction processing (OLTP) and online analytical processing (OLAP) systems. The series concludes with a guest lecture by Barry Morris from NuoDB, offering real-world perspectives on database technologies.