Databases
- Introduction to SQL
- ByteScout SQL Trainer
- 50 Years of Queries
- Intro to Database Systems (CMU 15-445/645)
- Readings in Database Systems ("Red Book")
- Petrov, Database Internals
- Petrov, What Every Programmer has to know about Database Storage
- Comparing Database Types
- Use the Index, Luke! A Guide to Database Performance for Developers
- Consistency Models
- The Querynomicon
- Things You Should Know About Databases
- Things I Wished More Developers Knew About Databases
- Database design basics
PostgreSQL
- Learning PostgreSQL Internals
- How Postgres Stores Data on Disk
- Understanding Postgres Performance
- The Part of PostgreSQL We Hate the Most
- Yes, PostgreSQL Has Problems. But We’re Sticking With It!
- Nine ways to shoot yourself in the foot with PostgreSQL
- Understanding the Postgres Hackers Mailing List Language
- What I Wish Someone Told Me About Postgres
- pgdoc ⚡ link
- psql tips
- Postgres Tips & Tricks
- Postgres for Everything