Intro to Database Systems - Fall 2017

Overview

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.

Syllabus

CMU Database Systems - 01 Course introduction & Relational Data Model (Fall 2017).
CMU Database Systems - 02 Relational Algebra (Fall 2017).
CMU Database Systems - 03 Advanced SQL (Fall 2017).
CMU Database Systems - 04 Functional Dependencies (Fall 2017).
CMU Database Systems - 05 Normal Forms (Fall 2017).
CMU Database Systems - 06 Database Storage (Fall 2017).
CMU Database Systems - 07 Buffer Pools (Fall 2017).
CMU Database Systems - 08 Hash Tables (Fall 2017).
CMU Database Systems - 09 Order-Preserving Trees (Fall 2017).
CMU Database Systems - 10 Query Processing (Fall 2017).
CMU Database Systems - 11 Sorting & Joins (Fall 2017).
CMU Database Systems - 12 Hash Joins & Aggregations (Fall 2017).
CMU Database Systems - 13 Query Optimization (Fall 2017).
CMU Database Systems - 14 Parallel Execution (Fall 2017).
CMU Database Systems - 15 Embedded Database Logic (Fall 2017).
CMU Database Systems - 16 Concurrency Control Theory (Fall 2017).
CMU Database Systems - 17 Two-Phase Locking (Fall 2017).
CMU Database Systems - 18 Index Concurrency Control (Fall 2017).
CMU Database Systems - 19 Timestamp Ordering Concurrency Control (Fall 2017).
CMU Database Systems - 20 Multi-Version Concurrency Control (Fall 2017).
CMU Database Systems - 21 Logging Schemes (Fall 2017).
CMU Database Systems - 22 Database Recovery (Fall 2017).
CMU Database Systems - 23 Distributed OLTP Systems (Fall 2017).
CMU Database Systems - 24 Distributed OLAP Systems (Fall 2017).
CMU Database Systems - 25 Barry Morris [NuoDB] (Fall 2017).