SQL & Database Quick Reference | DDL, DML, Joins, Indexes, PostgreSQL, MySQL | Instant Download

Stop Googling the same SQL syntax every day — JOINs, window functions, indexes, and performance tuning for PostgreSQL and MySQL in one searchable PDF.

Every command in here I've actually typed on a customer's terminal.

WHO THIS IS FOR:

- Senior developers crossing into infrastructure work
- Cloud architects designing multi-cloud environments
- Teams standardizing their deployment workflows
- Engineers learning the operational side of their own services
- Anyone responsible for keeping production systems awake

WHAT'S INSIDE:

- SQL Fundamentals & Setup
- Data Definition (DDL)
- Data Manipulation (DML)
- Joins & Subqueries
- Aggregation & Window Functions
- Indexes & Performance
- PostgreSQL Specifics
- MySQL Specifics
- Appendix: SQL Quick Reference Card
- Bonus: Database Design Checklist

HOW YOU'LL USE IT:

- Chapter 1 gives you the fundamentals and setup — read this if you are new to SQL
- Chapters 2-3 (DDL & DML) are the daily-use commands — create, alter, insert, update, delete
- Chapter 4 (Joins & Subqueries) is where most developers get stuck — the examples here cover 90 percent of real-world cases
- Chapter 6 (Indexes & Performance) is mandatory reading before you run anything on a large table
- Chapter 10 (Bonus Database Design Checklist) is your schema review gate for new tables

WHY THIS GUIDE:

- Built from runbooks used in real on-call rotations, not classroom labs
- Sequenced the way you actually work through a problem — not alphabetically, not by topic, but by what you check next
- No vendor lock-in — principles and commands work across major cloud providers and Kubernetes distributions

ABOUT THE AUTHOR:

Senior Linux and cloud engineer based in Auckland, New Zealand, with deep enterprise IT experience across multinational tech companies. Certified RHCE, CCNP, and PMP. Day job spans Linux fleets, multi-cloud platforms, and the kind of automation work that earns you the occasional weekend page. Writes from notes kept open on the second monitor — not from a content calendar.

PDF · A4 · searchable · hyperlinked · instant download after purchase.

Questions? Message me on Etsy — I reply within a day.
Enjoying it? Please leave a 5-star review.

Digital product. No physical item. AI-assisted drafts, reviewed by Bo. © Bo Prompt Studio.