CMU Database Group Courses

Query Execution and ClickHouse Database Systems - Part 2

Dive into advanced query execution concepts and ClickHouse database architecture, covering optimization techniques, processing strategies, and real-world database system implementations.

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

Rebuilding GlareDB from the Ground Up

Dive into the comprehensive rebuilding process of GlareDB, exploring architectural decisions, technical challenges, and innovative solutions in database system development.

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

Distributed Transactional Databases - Lecture 23

Dive into distributed database systems, exploring transaction management, concurrency control, and data consistency across multiple nodes in a comprehensive examination of distributed OLTP architectures.

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

Distributed Database Architectures - Lecture 22

Explore distributed database architectures, from fundamental concepts to real-world implementations, featuring insights from DataStax's Jonathan Ellis on modern distributed systems.

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

Concurrency Control Theory in Database Systems - Lecture 16

Dive into database concurrency control theory and explore Firebolt's innovative approach to managing simultaneous transactions in modern database systems, featuring insights from industry experts.

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

History of Query Optimizers Featuring IBM System R - Lecture 2

Dive into the historical evolution of database query optimizers, focusing on IBM System R's groundbreaking contributions and their lasting impact on modern database systems.

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

IBM Starburst Query Rewriter and Optimizer - Lecture 3

Dive into query optimization techniques with IBM Starburst, exploring rewriting strategies and optimization methods for enhanced database performance and efficient query processing.

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

Join Ordering: Bottom-up Dynamic Programming for Query Optimization - Lecture 7

Dive into advanced database query optimization techniques, focusing on bottom-up join ordering strategies and their implementation in modern database systems.

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

Unnesting Queries in Database Query Optimization - Lecture 11

Dive into advanced database query optimization techniques, focusing on unnesting strategies and their implementation for improved query performance in database management systems.

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

Towards Sanity in Query Languages

Explore the evolution and complexities of database query languages with leading experts Viktor Leis and Thomas Neumann as they discuss modern approaches and solutions for efficient data management.

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

Search Parallelization: Top-Down in Database Query Optimization - Lecture 10

Dive into advanced query optimization techniques focusing on top-down search parallelization methods for database systems, exploring strategies to enhance query processing performance.

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

TypeScript Stored Procedures for the Modern Age

Explore modern database development through TypeScript stored procedures, examining their evolution, benefits, and practical applications in contemporary software architecture.

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

Search Parallelization: Bottom-up Approach in Query Optimization - Lecture 9

Dive into advanced database query optimization techniques, focusing on bottom-up search parallelization methods for enhanced system performance and efficiency.

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

Query Plan Transformations in Database Query Optimization - Lecture 6

Dive into advanced query plan transformation techniques and optimization strategies for database systems, exploring methods to enhance query performance and execution efficiency.

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

Databricks Photon and Spark SQL in Advanced Database Systems - Lecture 20

Explore Databricks Photon and Spark SQL's advanced features for efficient data processing and analysis in modern database systems.

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