CMU Database Group Courses

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

JIT Query Compilation and Code Generation - Lecture 7

Explore JIT query compilation and code generation techniques for advanced database systems, focusing on performance optimization and efficient query execution.

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

Vectorized Query Execution Using SIMD - Lecture 6

Explore vectorized query execution using SIMD in advanced database systems, focusing on performance optimization techniques and modern hardware utilization.

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

Query Execution and Processing Part 2 - Lecture 5

Explore advanced query execution techniques, including vectorized processing and SIMD operations, for optimizing database system performance.

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