CMU Database Group Courses

Amazon Redshift Data Warehouse System - Lecture 22

1 rating

Explore Amazon Redshift's architecture, design principles, and performance optimizations for large-scale data warehousing in this advanced database systems lecture.

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

Accelerating Data and AI with Spice.ai Open-Source Software

Discover how Spice.ai's open-source software accelerates data and AI development, exploring innovative approaches to streamline machine learning workflows and enhance database integration.

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

Query Execution Part 1 - Introduction to Database Systems - Lecture 13

Dive into database query execution fundamentals, covering processing models, access methods, and optimization techniques for efficient data retrieval and manipulation.

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

ParadeDB - Postgres for Search and Analytics

Explore ParadeDB's integration of search and analytics capabilities into PostgreSQL, enhancing database functionality for modern applications.

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

Join Algorithms: Hash, Sort-Merge, Nested Loop Joins - Lecture 12

Learn efficient join algorithms including hash, sort-merge, and nested loop joins for database systems. Explore implementation techniques and performance considerations.

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

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

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

Exon - A Built for Purpose Bioinformatics Database

Discover how purpose-built bioinformatics databases work through Exon's architecture, design principles, and practical applications in genomic data management and analysis.

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

Query Planning and Optimization in Database Systems - Lecture 15

Dive into advanced database concepts focusing on query planning strategies, optimization techniques, and execution methods for improved database system performance.

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

MariaDB's Query Optimizer: A Multi-tool That Does Some Things Differently

Discover how MariaDB's query optimizer functions as a multi-tool with unique approaches, presented by database pioneer Monty Widenius in this technical seminar from the CMU Database Group.

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

Firebolt Transactions - WAL Indexing Mechanism

Discover how Firebolt implements transaction processing with a focus on their WAL indexing mechanism in this concise technical talk by CTO Mosha Pasumansky.

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

Leveraging Data Streaming Platform (DSP) for Analytics and GenAI

Discover how shifting data transformation to streaming infrastructure can unlock the power of modern applications, including GenAI, with Confluent's Data Streaming Platform.

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

PRQL: Pipelined Relational Query Language

Discover PRQL, a pipelined relational query language, as Tobias Brandt explores its features and advantages over traditional SQL in this CMU Database Group seminar.

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

Aerospike Database System

Explore Aerospike, a high-performance NoSQL database system designed for real-time applications requiring low latency and high throughput.

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

Gel: Replacing SQL and Improving on the Relational Database Model

Discover how Gel aims to replace SQL and enhance the relational database model in this insightful talk by Michael Sullivan from the CMU Database Group.

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