Skip to content

Archive

Home Browse Courses Talks Study Paths

Directory

Institutions Speakers

Library

Playlists

The public archive for recorded scholarship—unabridged university courses, departmental colloquia, and structured study syllabi.

Archive

All Lectures
University Courses
Standalone Talks
Guided Study Paths
Institutions
Scholars & Speakers

Disciplines

Systems & CS
Engineering & Control
Theory & Algorithms
Biology & Neuro
AI & Machine Learning
Economics & Finance
Mathematics
Philosophy & Ethics
Physics & Cosmology
History & Humanities

Workspace

Saved Library
Study Notebook
About & Mission
Support & Errata
RSS Feed
Sitemap

© 2026 Lectern·Independent Academic Archive·Made in NYC

Press ⌘K to search · ? for shortcuts

Academic Discipline

Systems & CS

Distributed systems, databases, operating systems, compilers, programming languages, networking, and computer architecture.

15courses·223standalone talks·432total lectures

Subfields

All Systems & CS432 Programming Languages109 Database Systems85 Operating Systems75 Distributed Systems73 Software Design & HCI72 Computer Architecture53 Algorithms & Data Structures44 Systems Security44 Malleable Computing & Dynamic Media18 Computer Networks & Cloud14 Probability & Information Theory6 Computer Vision & Graphics3

Database Systems— Storage engines, B+ and LSM trees, query optimization, MVCC concurrency control, and ACID recovery.

12 topics

All Database Systems Query Optimization & Execution36 Relational Algebra & SQL14 Concurrency Control & MVCC9 Storage Engines & Indexing9 Transactions & Crash Recovery9 Academic Planning2 Cloud Databases2 Columnar Storage2 Course Logistics2 Data Encoding2 Data Processing2 Data Storage2

jknavigate↵watchcchaptersssavexwatched

Save

Modern SQL — Window Functions, CTEs & Bag Semantics

Modern SQL — Window Functions, CTEs & Bag Semantics

15-445 · Intro to Database Systems · Lec 3·Linguistics, Philology & Historical Decipherment · Andy Pavlo · Carnegie Mellon University

Carnegie Mellon University

1:15:50

More categories

Mathematics (428)Physics & Cosmology (404)AI & Machine Learning (213)History & Humanities (376)Philosophy & Ethics (264)Biology & Neuroscience (281)Economics & Finance (336)Algorithms & Theory (339)Engineering & Robotics (209)

Linguistics, Philology & Historical Decipherment · Database Systems

1