CMU Database Group Courses

Relational Model and Algebra - Lecture 1

Explore relational models and algebra in database systems. Learn fundamental concepts and operations for efficient data management and querying.

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

Course Overview and Logistics for Intro to Database Systems - Lecture 00

Explore database systems fundamentals with Carnegie Mellon's comprehensive introduction, covering key concepts and practical applications in modern data management.

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

Yellowbrick Data Warehouse System - Lecture 21

Explore Yellowbrick's innovative data warehouse system, its architecture, and performance optimizations for analytical workloads in this advanced database systems lecture.

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

DuckDB Embedded Database System - Lecture 20

Explore DuckDB's embedded database system architecture, features, and performance optimizations for analytical workloads in this advanced database systems lecture.

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

Snowflake Data Warehouse Internals - Lecture 19

Explore Snowflake's data warehouse architecture, design principles, and internal workings. Gain insights into its innovative approach to cloud-based data management and analytics.

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

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

Explore Databricks Photon and Spark SQL architectures, optimizations, and performance improvements in modern data processing systems.

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

Google BigQuery and Dremel - Advanced Database Systems - Lecture 17

Explore Google BigQuery's architecture, query processing, and optimization techniques in this advanced database systems lecture from Carnegie Mellon University.

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

Query Optimizer Implementation 3 - Advanced Database Systems

Explore advanced query optimization techniques, focusing on implementation strategies for complex database systems.

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

Query Optimizer Implementation 2 - Advanced Database Systems - Lecture 14

Explore advanced query optimizer implementation techniques, focusing on cost models, plan enumeration, and optimization algorithms for complex database systems.

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

Query Optimizer Implementation 1 - Advanced Database Systems

Explore advanced query optimizer implementation techniques, focusing on cost-based optimization and plan enumeration strategies for efficient database query processing.

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

Database Networking Protocols - Lecture 12

Explore advanced database networking protocols, focusing on communication efficiency and performance optimization in distributed database systems.

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

User-Defined Function Optimizations in Advanced Database Systems - Lecture 11

Explore advanced optimization techniques for user-defined functions in database systems, enhancing query performance and system efficiency.

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

Multi-Way Join Algorithms and Worst-Case Optimal Joins - Lecture 10

Explore advanced multi-way join algorithms and worst-case optimal joins for database systems, enhancing query performance and efficiency.

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

Parallel Hash Join Algorithms - Lecture 9

Explore parallel hash join algorithms for advanced database systems, focusing on efficiency and performance optimization techniques.

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

Query Scheduling and Coordination in Advanced Database Systems - Lecture 8

Explore advanced query scheduling and coordination techniques in database systems, focusing on optimizing performance and resource utilization.

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