SQL

Master SQL with guides on queries, joins, indexing, and execution plans. Write efficient database code and understand why a query is actually slow.

A thick trussed base slab supporting four progressively lighter translucent panels, connected by thin vertical lines

Server-Side Development, Web Development, Backend, Database, Performance, SQL 7 min read

Database Management: The Schema Outlives Everything

Most database advice stays abstract because the concrete parts require reading a query plan. This goes into the specifics: schema decisions you can't reverse, index strategy, and how to find what's actually slow.