Relational Databases Explained: Fundamentals Every Engineer Should MasterA practical, engineering-first tour of the relational model, ACID guarantees, normalization, indexing, and the trade-offs that shape real-world systems
A practical guide to relational database fundamentals: the relational model, ACID, normalization, indexing, and trade-offs, with real code for engineers.
SQL Fundamentals: A Hands-On Guide to the Basics Every Developer NeedsFrom SELECT statements to joins and transactions - a practical, no-fluff introduction to relational databases for engineers who want to actually understand what's happening under the hood
Learn SQL fundamentals through practical examples: queries, joins, indexes, transactions, and normalization - a hands-on guide built for developers who want real understanding.
SQL Patterns, Anti-Patterns, and Pitfalls: A Practical Guide for EngineersHow to write SQL that scales, stays correct, and doesn't quietly rot your database
A practical guide to SQL design patterns, common anti-patterns, and performance pitfalls, with concrete examples for engineers who work with relational databases daily.
From JSON Documents to SQL Tables: Patterns, Practices, and Pitfalls of Relational MigrationA practical guide to moving schema-less JSON stores into normalized relational databases without losing data integrity, performance, or your team's sanity
A practical engineering guide to migrating JSON document databases into relational SQL schemas - covering normalization patterns, anti-patterns, migration tooling, and hard-won lessons.
Using PostgreSQL to Replace DynamoDB: A Practical Migration GuideHow to model DynamoDB-style access patterns in PostgreSQL without losing the flexibility that made NoSQL appealing in the first place
A practical, engineering-focused guide to replacing DynamoDB with PostgreSQL: schema design, indexing, transactions, and where the tradeoffs really bite.