CMU Database Group Courses

Less is More with PostgresML - ML and DB Seminar Series

Explore PostgresML's approach to efficient machine learning, covering web applications, scaling, pre-trained models, and memory management in databases.

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

B+Tree Indexes - Lecture 8

Explore B+Tree indexes in database systems, covering structure, operations, and optimizations for efficient data retrieval and management.

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

Hash Tables in Database Systems - Lecture 7

Explore hash table implementations, collision resolution strategies, and dynamic resizing techniques for efficient data storage and retrieval in database systems.

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

OtterTune: AI-Powered Database Optimization as a Service

Explore AI-powered database optimization with OtterTune, revolutionizing performance tuning through machine learning and automation.

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

Database Memory and Disk I/O Management - Lecture 6

Explore database memory and disk I/O management techniques, including buffer pools, page tables, and optimization strategies for efficient data access and performance.

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

Qdrant: Open Source Vector Search Engine and Vector Database

Explore Qdrant, an open-source vector search engine and database. Learn its architecture, capabilities, and applications in machine learning and information retrieval.

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

Storage Models and Database Compression - Lecture 5

Explore storage models and database compression techniques for efficient data management and improved system performance.

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

Database Storage Part 2 - Lecture 4

Explore advanced database storage concepts, including page layouts, tuple storage, and system catalogs in this comprehensive lecture on DBMS internals.

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

Database Storage Part 1 - Lecture 3

Explore database storage fundamentals, including file organization, page layouts, and tuple structures in DBMS architecture.

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

Modern SQL - Lecture 2

Explore modern SQL concepts, including aggregates, group by clauses, string operations, and date/time functions. Learn advanced techniques for efficient database querying and manipulation.

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

Relational Model and Algebra - Introduction to Database Systems - Lecture 1

Explore relational models and algebra in database systems, covering key concepts like data models, primary keys, and algebraic operations for effective database design and querying.

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

Amazon Redshift Internals - Lecture 24

Explore Amazon Redshift's architecture, design principles, and performance optimizations with insights from a guest lecturer and former CMU PhD graduate.

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

Meta Velox - Advanced Database Systems - Lecture 23

Explore Meta's Velox query execution engine, its architecture, and its role in modern data processing systems. Learn about its features and performance optimizations.

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

DuckDB Internals - Advanced Database Systems - Lecture 22

Explore DuckDB's architecture, design principles, and internal workings with guest lecturer Mark Raasveldt. Gain insights into advanced database systems and their implementation.

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

Snowflake Data Warehouse Internals - Lecture 21

Explore Snowflake's data warehouse architecture, design principles, and internal mechanisms for efficient cloud-based data management and analytics.

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