CMU Database Group Courses

Join Algorithms - Lecture 11

Explore join algorithms in database systems, covering nested loop joins, sort-merge joins, and hash joins. Learn optimization techniques for efficient query execution.

• YouTube
• 1 hour 15 minutes
• On-Demand
• Free Video

Sorting and Aggregation Algorithms in Database Systems - Lecture 10

Explore sorting and aggregation algorithms in database systems, covering key concepts and techniques for efficient data processing and analysis.

• YouTube
• 1 hour 5 minutes
• On-Demand
• Free Video

Index Concurrency Control - Lecture 9

Explore index concurrency control techniques in database systems, covering locking protocols and optimizations for efficient multi-threaded access to B+ tree indexes.

• YouTube
• 1 hour 20 minutes
• On-Demand
• Free Video

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video