SQL Guides
Learn SQL by reading it, not by memorising it — then try each idea in the playground.
- How to Read Any SQL Query, Clause by Clause
A clause-by-clause method for reading SQL.
- Indexes: What They Speed Up and What They Cost
How a database index works, which queries it accelerates, why it can slow writes, and how to tell whether your query actually used one..
- PostgreSQL vs MariaDB: the Differences That Actually Bite
Practical PostgreSQL and MariaDB differences.
- A SQL Good-Practice Checklist Before You Ship a Query
Eight checks before a SQL query goes to production.
- SQL Engine Releases — Verified Notes
Dated release notes for PostgreSQL, MariaDB and MySQL, each linked to the publisher. Updated by hand; every figure carries its source..