A university-level introduction to database systems taught by Andy Pavlo at Carnegie Mellon, covering how databases store, index, and execute queries. It is delivered as a free YouTube lecture series.

Commenters describe it as a free CMU-quality course that explains the inner workings of databases, with one saying it helped them explain PostgreSQL internals to their boss.

What commenters said (4)

1. Strongly recommendsstickyricky2022in “How PostgreSQL stores rows”

   if this post interests you at all I highly recommend watching "Intro to Database Systems" https://www.youtube.com/playlist?list=PLSE8ODhjZXjbohkNBWQs_...

   I recently (as in 6 hours ago) had to relay to my boss some information about the inner workings of postgres. studying this course helped me do that.

2. Recommendshackermailman2018in “Ask HN: Most effective path to become a solid systems practitioner?”

   Click on 'old video' to see the lectures, this covers x86 arch from a programmer's perspective, such as writing cache friendly code http://www.cs.cmu.edu/~./213/schedule.html Database lectures here including a really good advanced playlist on building your own dbms https://www.youtube.com/channel/UCHnBsf2rH-K7pn09rb3qvkA/pla... From there the book Programming Rust is a great book about systems programming. There's also an OS class https://www.rust-class.org/pages/classes.html or you can try taking some CS theory classes https://www.youtube.com/channel/UCWnu2XymDtORV--qG2uG5eQ/pla...

   Andrew S Tanenbaum has a Distributed Systems and OS book too that most universities still use.

3. Mentionsgolergka2021in “I’m 22 and I’ve failed”

   Your mistake was thinking you could go into, say, a CS degree and have nothing to learn.

   Thousand times this. I'm 33, programming since 8, working in the industry since 18, and can confidently call myself at least a senior, with a lot of leadership experience. And yet, I routinely go through CS courses from Stanford, MIT and CMU on YouTube (intro to databases by Andy Pavlo right now), and really envy people who have got to go learn at those institutions.

   There's a lot of knowledge to be gained by doing projects and tutorials and working. But there's so much "hard CS" stuff that is just not that easy to learn on your own.

4. Mentionshackermailman2017in “Ask HN: How do you keep your brain in the tonus?”

   I do courses when I can, try some CS theory, some free resources here https://functionalcs.github.io/curriculum/ such as these undergraduate complexity theory lectures https://www.youtube.com/playlist?list=PLm3J0oaFux3YL5vLXpzOy... or this intro to dbms course https://www.youtube.com/playlist?list=PLSE8ODhjZXjYutVzTeAds... then try using a SQL automated prover http://cosette.cs.washington.edu/

   Some more VIM resources, Vim as an IDE https://blog.jez.io/vim-as-an-ide/

   Lecture notes, entire course on vim and horrors that is vimscript http://www.contrib.andrew.cmu.edu/~haoxuany/vim/

   Great stackoverflow post on grokking vi to understand vim https://stackoverflow.com/questions/1218390/what-is-your-mos...

Related courses

• 15-213 Introduction to Computer SystemsCarnegie Mellon University · 12 recommenders
• 15-445/645 Intro to Database SystemsCarnegie Mellon University · 17 recommenders
• Introduction to DatabasesStanford University · 16 recommenders
• 15-721 Advanced Database SystemsCarnegie Mellon University · 12 recommenders
• Databases: 5 SQL (Stanford)edX · 2 recommenders
• Introduction to DatabasesCoursera · 2 recommenders
• Introduction to Big Data with Apache SparkedX · 2 recommenders
• CS165 Data SystemsHarvard University · 1 recommender