CMU Database Group Courses

Advanced Database Systems - Spring 2023

Dive into advanced database system internals, query optimization, and modern analytical architectures through CMU's comprehensive graduate-level curriculum.

• YouTube
• 1 day 3 hours 8 minutes
• Self-Paced
• Free Video

Introduction to Database Systems - Fall 2022

Master database fundamentals through CMU's comprehensive curriculum covering SQL, storage, indexing, concurrency, recovery, and distributed systems with hands-on implementation.

• YouTube
• 1 day 11 hours 1 minute
• 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

Chronon - Mixed-Workload Data Processing Framework

Discover Chronon, a mixed-workload data processing framework designed to handle diverse computational tasks efficiently across different data processing scenarios.

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

HorizonDB - Co-Designing PostgreSQL and Azure for Cloud-Native OLTP

Discover how HorizonDB co-designs PostgreSQL and Azure for cloud-native OLTP workloads, exploring innovative database architecture and cloud integration strategies.

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

Introduction to Apache Airflow

Discover Apache Airflow fundamentals for workflow orchestration and data pipeline automation in this comprehensive database group presentation.

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

Where We're Going, We Don't Need Rows - Columnar Data Connectivity with Apache Arrow ADBC

Explore Apache Arrow ADBC for efficient columnar data connectivity, moving beyond traditional row-based approaches to modern database systems.

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

Query Execution Part 1 - CMU Intro to Database Systems - 13

Dive into query execution fundamentals, exploring how database systems process and optimize SQL queries for efficient data retrieval and manipulation.

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

Query Optimization Part 2 - CMU Intro to Database Systems - 16

Dive into advanced query optimization techniques including cost-based optimization, join algorithms, and performance tuning strategies for database systems.

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

Vortex - LLVM for File Formats

Discover how Vortex leverages LLVM principles to revolutionize file format processing and optimization in modern data systems through practical implementation strategies.

• YouTube
• 1 hour 2 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

Sorting and Aggregation Algorithms - 11

Explore sorting and aggregation algorithms in database systems through expert instruction and a MotherDuck industry flash talk from CMU's comprehensive database systems program.

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

DuckLake - Learning from Cloud Data Warehouses to Build a Robust Lakehouse

Discover how to build a robust lakehouse architecture by learning from cloud data warehouse design patterns and implementation strategies.

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