Database Systems Courses and Certifications

CMU Database Group

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

Big Data Demystified

High Performance, Low Latency Database Architecture - Modern Distributed Systems

Dive into modern distributed database architecture, exploring high performance, consistency, replication, and scaling concepts through practical examples from ScyllaDB and Cassandra implementations.

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

OSACon

Analytics and Real-time Database Workloads: Combining OLTP and OLAP Systems

Explore strategies for optimizing concurrent OLAP and OLTP workloads, focusing on ScyllaDB's workload prioritization features to achieve harmonious performance in distributed systems.

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

CMU Database Group

Query Execution Part 1 - CMU Intro to Database Systems - 13

Dive into query execution fundamentals, exploring how database systems process and optimize SQL queries for efficient data retrieval and manipulation.

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

CMU Database Group

Query Optimization Part 1 - CMU Intro to Database Systems - 15

Discover query optimization fundamentals including cost estimation, plan enumeration, and optimization techniques to improve database performance and efficiency.

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

CMU Database Group

Query Optimization Part 2 - CMU Intro to Database Systems - 16

Dive into advanced query optimization techniques including cost-based optimization, join algorithms, and performance tuning strategies for database systems.

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

CMU Database Group

Join Algorithms - CMU Intro to Database Systems - Lecture 12

Master join algorithms in database systems including nested loop, sort-merge, and hash joins with performance optimization techniques from CMU's expert instruction.

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

CMU Database Group

Query Execution Part 2 - SpiralDB Database Talk - CMU Intro to Database Systems - 14

Explore advanced query execution techniques including parallel processing, vectorization, and code generation, plus discover SpiralDB's innovative approach to database optimization.

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

CMU Database Group

Concurrency Control Theory - CMU Intro to Database Systems - Lecture 17

Explore concurrency control theory in database systems, covering transaction isolation, locking protocols, and conflict resolution mechanisms for multi-user environments.

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

ACM SIGPLAN

Checking Observational Correctness of Database Systems

Discover a client-centric technique for verifying database system correctness through observational analysis, covering semantic correctness and isolation guarantees using symbolic encodings.

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

CMU Database Group

Timestamp Ordering Concurrency Control - CMU Intro to Database Systems - 19

Explore timestamp ordering concurrency control mechanisms in database systems to manage concurrent transactions and ensure data consistency.

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

CMU Database Group

Two-Phase Locking - CMU Intro to Database Systems #18

Explore two-phase locking protocols in database systems and discover Firebolt's approach to high-performance analytics through expert insights from CMU's database systems curriculum.

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

CMU Database Group

Column Stores and Database Compression - CMU Intro to Database Systems - 06

Explore column-oriented storage architectures and compression techniques to optimize database performance and reduce storage overhead in modern systems.

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

CMU Database Group

Write-Ahead Logging and Shadow Paging - CMU Intro to Database Systems - 21

Explore write-ahead logging and shadow paging techniques for database recovery and transaction durability in this comprehensive database systems lecture.

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

CMU Database Group

Multi-Version Concurrency Control - CMU Intro to Database Systems - 20

Explore multi-version concurrency control techniques in database systems to handle concurrent transactions efficiently and maintain data consistency.

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