Ask HN: Best resources to learn the intricacies of relational databases

I am trying to get a more than superficial level of knowledge on deploying services on relational databases with a lot of traffic. I don't know if it makes sense to grab any manual of a relational database, like PostgreSQL or MySQL, or if that is too specific and it makes more sense to start with a more general book. [Please do not suggest Designing Data Intensive Applications, I am already reading it :) ] Moreover, what are the best resources you know of that you used to learn SQL queries and their syntax properly? Thank you very much!

Re: Ask HN: Best resources to learn the intricacies of relational databases

#4

Post by RapperWhoMadeIt » Tue, Sep 20, 2022, 5:14 PM UTC

oxff wrote: post #2

Courses: CMU 15-445: Intro to Database Systems - https://15445.courses.cs.cmu.edu/fall2022/ CMU 15-721: Advanced Database Systems - https://15721.courses.cs.cmu.edu/spring2020/ CMU 15-799: Self-Driving DBMS - https://15799.courses.cs.cmu.edu/spring2022/ DBMS specific: PostgreSQL 14 Internals - https://postgrespro.com/community/books/internals Others: A handy list of distributed system links - https://pierrezemb.fr/po…

This is amazing! Thank you so much!

Re: Ask HN: Best resources to learn the intricacies of relational databases

#5

Post by oxff » Tue, Sep 20, 2022, 5:21 PM UTC

RapperWhoMadeIt wrote: post #4

oxff wrote: post #2

Courses: CMU 15-445: Intro to Database Systems - https://15445.courses.cs.cmu.edu/fall2022/ CMU 15-721: Advanced Database Systems - https://15721.courses.cs.cmu.edu/spring2020/ CMU 15-799: Self-Driving DBMS - https://15799.courses.cs.cmu.edu/spring2022/ DBMS specific: PostgreSQL 14 Internals - https://postgrespro.com/community/books/internals Others: A handy list of distributed system links - https://pierrezemb.fr/po…

This is amazing! Thank you so much!

The first two CMU courses are goated. I recommend reading at least some of the papers Pavlo says to, but if I'd have to recommend a particular one it'd be "Architecture of a Database System": https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf