I’ve written two technical books on database design, operations, and modeling.
MySQL Cookbook, 4th Edition
O’Reilly Media · 2022 · Co-authored with Paul DuBois
The definitive recipe book for MySQL — over 200 practical recipes covering queries, data manipulation, stored procedures, triggers, JSON, full-text search, replication, and performance tuning. Fully updated for MySQL 8.x. Two and a half years in the making.
Database Design and Modeling with PostgreSQL and MySQL
Packt Publishing · 2024
A practical guide to database design principles, schema modeling, normalization, indexing strategy, and cross-database considerations for teams working with both PostgreSQL and MySQL. Covers ER modeling, partitioning, replication topology, and how design decisions compound at scale.
👉 Buy on Amazon · Packt