CMU Database Group Courses

Query Execution Part 2 - SpiralDB Database Talk - CMU Intro to Database Systems - 14

Explore advanced query execution techniques including parallel processing, vectorization, and code generation, plus discover SpiralDB's innovative approach to database optimization.

• YouTube
• 1 hour 19 minutes
• Self-Paced
• Free Video

Storage Metadata for Modern Cloud Databases

Explore storage metadata management techniques and architectures essential for optimizing modern cloud database systems and their performance challenges.

• YouTube
• 59 minutes
• Self-Paced
• Free Video

Query Optimization Part 1 - CMU Intro to Database Systems - 15

Discover query optimization fundamentals including cost estimation, plan enumeration, and optimization techniques to improve database performance and efficiency.

• YouTube
• 1 hour 20 minutes
• Self-Paced
• Free Video

Multi-statement Transactions in the Databricks Lakehouse

Discover how to implement multi-statement transactions in Databricks Lakehouse architecture for enhanced data consistency and reliability across complex operations.

• YouTube
• 56 minutes
• Self-Paced
• Free Video

Concurrency Control Theory - CMU Intro to Database Systems - Lecture 17

Explore concurrency control theory in database systems, covering transaction isolation, locking protocols, and conflict resolution mechanisms for multi-user environments.

• YouTube
• 1 hour 21 minutes
• Self-Paced
• Free Video

Two-Phase Locking - CMU Intro to Database Systems #18

Explore two-phase locking protocols in database systems and discover Firebolt's approach to high-performance analytics through expert insights from CMU's database systems curriculum.

• YouTube
• 1 hour 23 minutes
• Self-Paced
• Free Video

Amazon DSQL - Aurora DSQL Global Serverless Relational Database System

Discover Aurora DSQL's serverless architecture, transaction handling, and coordination-minimizing design from AWS VP Mark Brooker in this technical deep dive.

• YouTube
• 1 hour 9 minutes
• Self-Paced
• Free Video

Reconstructing History with XTDB

Explore XTDB's innovative approach to temporal data management and historical reconstruction in this database seminar by industry experts.

• YouTube
• 1 hour 6 minutes
• Self-Paced
• Free Video

Distributed Databases Part 1 - Lecture 23

Explore distributed database fundamentals including system architecture, data partitioning, and replication strategies in this comprehensive CMU lecture.

• YouTube
• 1 hour 25 minutes
• Self-Paced
• Free Video

Apache Fluss - A Streaming Storage for Real-Time Lakehouse

Discover Apache Fluss, a streaming storage solution designed for real-time lakehouse architectures, exploring its capabilities and implementation strategies.

• YouTube
• 1 hour 1 minute
• Self-Paced
• Free Video

Mooncake - Real-Time Apache Iceberg Without Compromise

Discover Mooncake's approach to achieving real-time performance with Apache Iceberg data lakes without sacrificing functionality or reliability in this technical seminar.

• YouTube
• 1 hour 3 minutes
• Self-Paced
• Free Video

Timestamp Ordering Concurrency Control - CMU Intro to Database Systems - 19

Explore timestamp ordering concurrency control mechanisms in database systems to manage concurrent transactions and ensure data consistency.

• YouTube
• 1 hour 25 minutes
• Self-Paced
• Free Video

MotherDuck - Building a Cloud Data Warehouse with an In-Process OLAP DBMS

Discover how MotherDuck builds a cloud data warehouse using an in-process OLAP database management system with insights from industry expert Boaz Leskes.

• YouTube
• 12 minutes
• Self-Paced
• Free Video

Firebolt - Why Powering User Facing Applications on Iceberg is Hard

Explore the challenges of using Apache Iceberg for user-facing applications and discover Firebolt's solutions to overcome performance bottlenecks.

• YouTube
• 1 hour 8 minutes
• Self-Paced
• Free Video

Write-Ahead Logging and Shadow Paging - CMU Intro to Database Systems - 21

Explore write-ahead logging and shadow paging techniques for database recovery and transaction durability in this comprehensive database systems lecture.

• YouTube
• 1 hour 22 minutes
• Self-Paced
• Free Video