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

CMU Database Group6 HN recommenders · 2020–2023
248K views · lecture · evergreen · Uploaded 2019-08-28

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

Frequently recommended as the best free university course on database internals, praised for depth and Pavlo's presentation.

Watch on YouTube

7 comments from Hacker News

@ptr2020 · in “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. [VIDEO]

Strongly recommendsView on HN
@alistairw2021 · in “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: [VIDEO]

Strongly recommendsView on HN
@maxmcd2022 · in “How does database indexing work? (2008)”

Obligatory recommendation for the CMU Databases Systems lecture series by Andy Pavlo. [VIDEO] Here's the lecture on tree indexes: [LINK]

Strongly recommendsView on HN
@avinassh2023 · in “Ask HN: What's the best textbook or video lectures on a topic you've come seen?”

Intro to Database Systems by Andy Pavlo - [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.

RecommendsView on HN
@runlaszlorun2023 · in “The Part of PostgreSQL We Hate the Most (Multi-Version Concurrency Control)”

[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.

Strongly recommendsView on HN
@joelrwilliams12023 · in “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: [VIDEO]

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

Intro to Database Systems by Andy Pavlo - [VIDEO] MIT 6.824 Distributed Systems by Robert Morris - [LINK] Designing Data-Intensive Applications (DDIA) - [LINK] Crafting Interpreters - [LINK]

RecommendsView on HN