Talks to Watch

01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)

248K views · Aug 28, 2019 · 1:06:44 · 6 HN recommenders · 7 mentions · discussed 2020–2023

The first lecture of Andy Pavlo's CMU 15-445 Intro to Database Systems (Fall 2019), covering course introduction and the relational model.

Why Hacker News points people here: Frequently recommended as the best free university course on database internals, praised for depth and Pavlo's presentation.

“Highly recommended both for the depth and how Andy Pavlo presents the topic.”HN comment, 2020

What Hacker News said 7

Strongly recommendsptrJan 2020

“Highly recommended both for the depth and how Andy Pavlo presents the topic.”

CMU intro to database systems lectures with depth and great presentation

Full comment

I'd start with CMU's "Intro to Database Systems", their lectures are on youtube. Highly recommended both for the depth and how Andy Pavlo presents the topic. this video

in “Ask HN: What Technologies to Learn in 2020?” · view on HN
Strongly recommendsalistairwApr 2021

“it's significantly helped me in using and making choices about databases.”

Helped database choices and inspired building own database

Full comment

Agreed. I finished watching them at the start of this year and it's significantly helped me in using and making choices about databases. I've also since started implementing my own database for learning off the back of them. Couldn't be more grateful for those courses being public. link if anyone is interested: this video

in “Foundations of Databases (1995)” · view on HN
Strongly recommendsmaxmcdMar 2022

“Obligatory recommendation for the CMU Databases Systems lecture series by Andy Pavlo.”

CMU database lecture series by Andy Pavlo

Full comment

Obligatory recommendation for the CMU Databases Systems lecture series by Andy Pavlo. this video Here's the lecture on tree indexes: link

in “How does database indexing work? (2008)” · view on HN
Strongly recommendsrunlaszlorunApr 2023

“Highly recommend.”

Intro class diving into database internals, with advanced courses and guest lectures

Full comment

this video There are multiple years available for his first DB class but that’s the one I watched. I almost called it his ‘basic’ class but there’s literally only like one or two classes on SQL before he dives into all the various layers of the internals. There’s also a few of his advanced courses. And then you’ll see guest lectures from industry on about every one of the new DB platforms you can think of. They’re all under “CMU Database Group” on Youtube. Highly recommend.

in “The Part of PostgreSQL We Hate the Most (Multi-Version Concurrency Control)” · view on HN
RecommendsavinasshApr 2023

“these break down really complex topics and make the concepts approachable.”

Breaks down complex topics approachably for newcomers

Full comment

Intro to Database Systems by Andy Pavlo - this video MIT 6.824 Distributed Systems by Robert Morris - link Designing Data-Intensive Applications (DDIA) - link Crafting Interpreters - link > What made it so special these break down really complex topics and make the concepts approachable. As a noob, I learned a lot from these.

in “Ask HN: What's the best textbook or video lectures on a topic you've come seen?” · view on HN
Recommendsjoelrwilliams1May 2023

“this guy gets really deep into the technologies behind a database.”

CMU course going deep into database technologies

Full comment

I stumbled across this Carnegie Mellon University database course a year or two ago and this guy gets really deep into the technologies behind a database. Here's the list of YouTube videos of lectures that the professor has posted online: this video

in “Ask HN: What are some good resources for learning about low level disk/file IO?” · view on HN
RecommendsavinasshAug 2023

“Intro to Database Systems by Andy Pavlo -”

Listed among resources that improved programming skills

Full comment

Intro to Database Systems by Andy Pavlo - this video MIT 6.824 Distributed Systems by Robert Morris - link Designing Data-Intensive Applications (DDIA) - link Crafting Interpreters - link

in “Which books, courses, projects have improved your programming skills immensely?” · view on HN