Intro to Database Systems
Inside modern relational and analytical DBMS internals: relational algebra, slotted-page storage, log-structured merge trees, columnar compression, buffer pool management, and hash/B+Tree indexes.
Andy Pavlo
Associate Professor of Databaseology
Courses by Andy Pavlo
Complete university lecture series taught by Andy Pavlo.
Advanced Database Systems
Graduate systems seminar on modern OLAP execution engines: columnar compression, Parquet/Arrow formats, vectorized SIMD execution, JIT query compilation, worst-case optimal joins, and cloud lakehouses.
Query Optimization in Modern Database Systems
Advanced systems course on relational query optimization, analyzing System R bottom-up dynamic programming, Volcano/Cascades top-down rule engines, cardinality estimation, and join ordering.
Standalone talks by Andy Pavlo
2Self-contained public lectures, keynote addresses, and research seminars.
Distributed OLAP Databases (CMU Databases Systems / Fall 2019)
A detailed lecture from CMU's Database Systems course, exploring the architectural and operational intricacies of distributed OLAP databases.
01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)
This introductory lecture establishes the architecture of modern database management systems and formally introduces the relational data model, covering its foundational concepts, integrity constraints, and algebraic operations.
Study paths featuring Andy Pavlo
3
5 steps · 6h2 universities
Deep Representation Learning & Approximation Theory
Neural approximation theorems, optimization dynamics, and relational query engines
MIT · Carnegie Mellon University
5 curated lecturesOpen path →
7 steps · 10h4 universities
Silicon Gates to High-Performance Analytical Engines
Digital architecture, compiler vectorization, C++ zero-overhead design, and columnar OLAP
ETH Zürich · MIT · University of Edinburgh +1
7 curated lecturesOpen path →
7 steps · 6h3 universities
Distributed Consensus, Clocks & Storage Engines
From unreliable networks and physical time to Raft and page-level durability
MIT · University of Cambridge · Carnegie Mellon University
7 curated lecturesOpen path →
All lectures by Andy Pavlo
49Search or browse every recorded session across courses and talks.
Showing 20 of 49 lectures
Lecturej/k navigate · c chapters · s save · x watched
Scholar · University
Chapters · Duration
15-721 · Lec 6 · Andy Pavlo · Carnegie Mellon University
1:24:55
15-445 · Lec 2 · Andy Pavlo · Carnegie Mellon University
1:16:43
15-445 · Lec 4 · Andy Pavlo · Carnegie Mellon University
1:19:10
15-445 · Lec 5 · Andy Pavlo · Carnegie Mellon University
1:17:25
15-445 · Lec 6 · Andy Pavlo · Carnegie Mellon University
1:23:25
15-445 · Lec 7 · Andy Pavlo · Carnegie Mellon University
1:22:44
1:25:15
15-721 · Lec 15 · Andy Pavlo · Carnegie Mellon University
1:20:31
15-445 · Lec 8 · Andy Pavlo · Carnegie Mellon University
1:18:45
15-721 · Lec 16 · Andy Pavlo · Carnegie Mellon University
43:13
1:06:44
15-721 · Lec 2 · Andy Pavlo · Carnegie Mellon University
1:09:05
15-721 · Lec 3 · Andy Pavlo · Carnegie Mellon University
1:23:08
15-721 · Lec 5 · Andy Pavlo · Carnegie Mellon University
1:23:43
15-721 · Lec 4 · Andy Pavlo · Carnegie Mellon University
1:21:48
15-721 · Lec 7 · Andy Pavlo · Carnegie Mellon University
1:18:40
15-445 · Lec 3 · Andy Pavlo · Carnegie Mellon University
1:15:50
15-799 · Lec 13 · Andy Pavlo · Carnegie Mellon University
1:11:38
15-799 · Lec 4 · Andy Pavlo · Carnegie Mellon University
1:23:28
15-799 · Lec 5 · Andy Pavlo · Carnegie Mellon University
1:27:28