Skip to content
Hallway
0:00 / 0:00

#cmu15-445#relationalmodel#andypavlo

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

CMU Database Group

92K subscribers • 29 videos on Hallway • University channel

YouTube
  • Recommended by 6 people: 6 on Hacker News.
  • A classic. People kept recommending it from 2020 to 2023.
  • Presented by Andy Pavlo, Professor, CMU
  • Linked in the descriptionSlides on 15445.courses.cs.cmu.edu

Beginner. No background in the topic needed.

247K views7 years ago6 recommendations

Databases and dataComputer scienceDatabase internalsSQL

Andy Pavlo introduces the CMU 15-445/645 course and explains the fundamentals of the relational model for database systems.

Prof. Andy Pavlo (cs.cmu.edu/~pavlo/) Slides: 15445.courses.cs.cmu.edu/fall2019/slides/01-introduction.pdf Notes 15445.courses.cs.cmu.edu/fall2019/notes/01-introduction.pdf 15-445/645 Intro to Database Systems (Fall 2019) Carnegie Mellon University 15445.courses.cs.cmu.edu/fall2019/

Why it's here

6 people recommend this

What people say. Recommended as an exceptionally clear and engaging introduction to database systems and their underlying internals.

ptron Hacker News • Recommends

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. link to this video
View on Hacker News

alistairwon Hacker News • Recommends

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: link to this video
View on Hacker News

maxmcdon Hacker News • Recommends

On “How does database indexing work? (2008)”

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

runlaszlorunon Hacker News • Recommends

On “The Part of PostgreSQL We Hate the Most (Multi-Version Concurrency Control)”

link to 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.
View on Hacker News

avinasshon Hacker News • Recommends

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 - link to 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.
View on Hacker News

joelrwilliams1on Hacker News • Recommends

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: link to this video
View on Hacker News

avinasshon Hacker News • Recommends

On “Which books, courses, projects have improved your programming skills immensely?”

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