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

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

RapperWhoMadeIt 3 years ago |

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!