3 ms·

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

• oxff 4y ago
  Courses: CMU 15-445: Intro to Database Systems - https://15445.courses.cs.cmu.edu/fall2022/ https://15445.courses.cs.cmu.edu/fall2022/ CMU 15-721: Advanced Database Systems - https://15721.courses.cs.cmu.edu/spring2020/ https://15721.courses.cs.cmu.edu/spring2020/ CMU 15-799: Self-Driving DBMS - https://15799.courses.cs.cmu.edu/spring2022/ https://15799.courses.cs.cmu.edu/spring2022/ DBMS specific: PostgreSQL 14 Internals - https://postgrespro.com/community/books/internals https://postgrespro.com/community/books/internals Others: A handy list of distributed system links - https://pierrezemb.fr/posts/distsys-resources/ https://pierrezemb.fr/posts/distsys-resources/
  • RapperWhoMadeIt 4y ago
    This is amazing! Thank you so much!
    • oxff 4y ago
      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 https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf
• RapperWhoMadeIt 4y 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!