01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)
Why Hacker News recommends it
Frequently recommended as the best free university course on database internals, praised for depth and Pavlo's presentation.
What it is
The first lecture of Andy Pavlo's CMU 15-445 Intro to Database Systems (Fall 2019), covering course introduction and the relational model.
Recommended by 6 HN commenters across 6 different months, 2020 to 2023.
What Hacker News said
Strong rec ptr · 2020-01 · on “Ask HN: What Technologies to Learn in 2020?”
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]
Strong rec alistairw · 2021-04 · on “Foundations of Databases (1995)”
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]
Strong rec maxmcd · 2022-03 · on “How does database indexing work? (2008)”
Obligatory recommendation for the CMU Databases Systems lecture series by Andy Pavlo. [this video] Here's the lecture on tree indexes: [LINK]
Strong rec runlaszlorun · 2023-04 · on “The Part of PostgreSQL We Hate the Most (Multi-Version Concurrency Control)”
[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.
Recommends avinassh · 2023-04 · on “Ask HN: What's the best textbook or video lectures on a topic you've come seen?”
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.
Recommends joelrwilliams1 · 2023-05 · on “Ask HN: What are some good resources for learning about low level disk/file IO?”
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]
Recommends avinassh · 2023-08 · on “Which books, courses, projects have improved your programming skills immensely?”
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]