SQL
SQL as a language, from your first SELECT to reading a query plan — the language, the analytical toolkit, how the database runs your query, and SQL in production, all run-verified against PostgreSQL 18.
-
SQL from the Ground Up
The relational model and your first SELECT through joins, aggregation, subqueries, set operations, writing data, and constraints — every query run against PostgreSQL 18, NULL and three-valued logic given a chapter of its own.
14 posts
-
Querying Like You Mean It
The analytical half of SQL — CTEs and recursion, the full window-function arc, GROUPING SETS, pivoting, dates, strings and regex, JSON/JSONB, arrays and LATERAL — run against PostgreSQL 18 over the bookshop.
13 posts
-
How Databases Run Your Query
Reading EXPLAIN ANALYZE, indexes (B-tree, partial, covering, GIN/GiST), join algorithms and the planner, MVCC and isolation with real anomaly demos, locking and deadlocks, VACUUM, and partitioning — measured against PostgreSQL 18.
13 posts
-
SQL in the Real World
Normalization and keys, views and generated columns, triggers and functions, migrations, and SQL from application code — parameterized queries, injection, pooling, and transactions across a request — against PostgreSQL 18.
11 posts