2:14:05CS50x 2024 - Lecture 7 - SQL
CS50Intro620K views
CS50x 2024 lecture 7: SQL — relational databases, queries, joins and SQL injection.
267,244 videos · Algorithms, systems, security, machine learning and building software.
2:14:05Intro620K views
CS50x 2024 lecture 7: SQL — relational databases, queries, joins and SQL injection.
1:23:44Intro15.3K views
CMU 15-445, lecture 7: Hash tables inside a DBMS: static schemes, linear probing, cuckoo and extendible hashing.
1:19:21Intro6.01K views
CMU 15-445, lecture 20: Write-ahead logging, buffer pool policies and checkpoints.
1:22:55Intro4.94K views
CMU 15-445, lecture 24: Distributed analytical databases and query execution across nodes.
1:23:38Intro89.1K views
CMU 15-445, lecture 1: The relational model and relational algebra, the theory under every SQL database.
1:18:45Intro40.7K views
CMU 15-445, lecture 2: Modern SQL: aggregates, window functions, CTEs and other features beyond the basics.
1:22:28Intro49.6K views
CMU 15-445, lecture 3: How a DBMS lays out data in files and slotted pages on disk.
1:12:55Intro5.53K views
CMU 15-445, lecture 21: Crash recovery with the ARIES algorithm.
1:21:18Intro9.37K views
CMU 15-445, lecture 15: Query planning and cost-based optimization.
1:27:09Intro9.21K views
CMU 15-445, lecture 16: Transaction theory: ACID and conflict serializability.
1:25:57Intro9.6K views
CMU 15-445, lecture 25: How today's cloud data warehouses such as BigQuery, Snowflake, Redshift, Databricks and DuckDB are built.
1:24:54Intro6.02K views
CMU 15-445, lecture 23: Distributed transactions, atomic commit protocols and consensus.
1:23:02Intro6.1K views
CMU 15-445, lecture 22: Distributed database architectures, partitioning and replication.
1:05:22Intro6.78K views
CMU 15-445, lecture 17: Two-phase locking, deadlock detection and prevention.
1:17:57Intro10K views
CMU 15-445, lecture 11: External sorting and hash- and sort-based aggregation.
1:22:15Intro18.9K views
CMU 15-445, lecture 8: B+Tree indexes: structure, splits and merges, and design choices.
1:21:11Intro13.1K views
CMU 15-445, lecture 9: Vector indexes, inverted indexes, filters and tries for search beyond B+Trees.
1:02:50Intro9.95K views
CMU 15-445, lecture 14: Parallel query execution and intra-query parallelism.
1:16:42Intro9.96K views
CMU 15-445, lecture 10: Latching and concurrency control inside index data structures.
1:28:00Intro22.6K views
CMU 15-445, lecture 5: Row versus column storage and how analytic databases compress columnar data.
1:23:19Intro11K views
CMU 15-445, lecture 13: Query execution: processing models and access methods.
1:27:07Intro9.07K views
CMU 15-445, lecture 19: Multi-version concurrency control as used by most modern systems.
1:14:23Intro10.7K views
CMU 15-445, lecture 12: Join algorithms: nested-loop, sort-merge and hash joins with cost analysis.
1:20:53Intro7.58K views
CMU 15-445, lecture 18: Optimistic and timestamp-ordering concurrency control.
1:23:57Intro19.8K views
CMU 15-445, lecture 6: Buffer pool management, replacement policies and disk I/O scheduling.

Advanced205K views
Martin Kleppmann argues for structuring databases around an immutable log of events, showing how stream processing (Samza/Kafka) turns the database 'inside out'.
1:15:51Intro35.5K views
CMU 15-445 (Fall 2023) lecture 2: modern SQL — aggregates, window functions, CTEs and more.
1:16:14Advanced59.7K views
CMU Advanced Databases (Spring 2023) lecture 1: the history of databases and recurring ideas.

Advanced177K views
Nathaniel Smith and Stéfan van der Walt explain colour perception and perceptual uniformity, and how they designed viridis, Matplotlib's new default colormap.

Intro247K views
The first lecture of Andy Pavlo's CMU Database Systems course: course outline, the relational model and relational algebra.
1:19:11Intro37.7K views
CMU 15-445 (Fall 2023) lecture 3: database storage — files, pages and tuple layout.
1:22:41Intro34.4K views
CMU 15-445 lecture 4: log-structured merge trees and tuple storage.

81.9K views
Richard Hipp explains SQLite's design goals, file format and testing, and why it is used everywhere.
23:01Intro1.77M views
Getting started with pandas: loading real survey data into DataFrames and exploring it.
12:391.22M views
How B-trees organise data for fast search, insertion and deletion, and why modern databases are built on them.

Advanced28.5K views
Mark Raasveldt explains DuckDB's design as an embedded analytical database: vectorised execution, columnar storage and in-process deployment.