SQL Quick Reference Guide | PostgreSQL, MySQL, DBA (44-Page PDF)

• Digital download
• Digital file type(s): 1 PDF

🐍 Stop Googling the same SQL syntax every day. This 44-page reference covers SELECT, JOINs, window functions, indexes, and performance tuning for PostgreSQL, MySQL, and standard SQL — all in one clean, searchable PDF you actually want to keep open.

Whether you write queries daily or manage production databases, this guide gives you copy-paste-ready syntax with real-world examples. No fluff, no theory lectures — just the commands you need, organized the way you think.

✅ WHAT'S INSIDE (8 Chapters + Bonus):

📄 Chapter 1: SQL Fundamentals & Setup — Connecting, basic syntax, data types across PostgreSQL/MySQL/SQLite
📄 Chapter 2: Data Definition (DDL) — CREATE, ALTER, DROP tables, constraints, foreign keys, schemas
📄 Chapter 3: Data Manipulation (DML) — SELECT, INSERT, UPDATE, DELETE, UPSERT, MERGE, RETURNING
📄 Chapter 4: Joins & Subqueries — INNER, LEFT, RIGHT, FULL, CROSS, self-joins, CTEs, correlated subqueries
📄 Chapter 5: Aggregation & Window Functions — GROUP BY, HAVING, ROW_NUMBER, RANK, LAG, LEAD, NTILE, running totals
📄 Chapter 6: Indexes & Performance — B-tree, GIN, GiST, EXPLAIN ANALYZE, query plans, slow query diagnosis
📄 Chapter 7: PostgreSQL Specifics — JSONB, arrays, COPY, pg_dump, extensions, psql tips
📄 Chapter 8: MySQL Specifics — SHOW commands, mysqldump, InnoDB tuning, mysql CLI, user management

🎁 PREMIUM BONUS:
⚡ SQL Quick Reference Card — one-page cheat sheet with the 50 most-used queries
⚡ Database Design Checklist — normalization, naming conventions, index strategy, migration planning
⚡ Index Strategy Decision Tree — when to use B-tree vs GIN vs GiST vs partial indexes

🎯 WHO THIS IS FOR:
✅ Backend developers who write SQL daily and need a fast reference
✅ Junior developers learning SQL and wanting real-world examples
✅ Database administrators managing PostgreSQL or MySQL in production
✅ Data analysts writing complex queries with joins and window functions
✅ DevOps engineers who set up and maintain database infrastructure
✅ Students preparing for technical interviews with SQL questions

⚡ KEY FEATURES:
💡 150+ real SQL queries — tested on PostgreSQL 16 and MySQL 8
💡 Side-by-side PostgreSQL vs MySQL syntax differences
💡 EXPLAIN ANALYZE walkthrough — read query plans like a pro
💡 Window functions with practical examples (not just theory)
💡 Copy-paste ready — every example runs as-is on a sample dataset
💡 Print-friendly A4 layout with clear code formatting

🔧 WORKS WITH:
✅ PostgreSQL (all versions, focus on 14-16)
✅ MySQL 8.x / MariaDB 10.x+
✅ SQLite 3.x
✅ SQL Server (core ANSI SQL)
✅ Any SQL client (pgAdmin, DBeaver, DataGrip, mysql CLI)

👨‍💻 ABOUT THE AUTHOR:
Created by Bo Wang, Senior Linux & Cloud Engineer based in New Zealand with 17 years of enterprise IT experience at multinational tech companies. Certified RHCE, CCNP, PMP. Bo has managed production PostgreSQL and MySQL databases across high-availability environments and distilled years of daily SQL usage into this practical reference.

📄 FORMAT:
🎁 Premium A4 PDF (40+ pages, print-friendly)
📥 Instant digital download — no waiting, no shipping
🖨️ Print-friendly layout with clear headings and generous spacing

⬇️ INSTANT DOWNLOAD:
After purchase, download your PDF immediately from Etsy. Go to You → Purchases and reviews → Download files. You can download on any device — computer, tablet, or phone.

⭐ Love this guide? Please leave a 5-star review — it helps other developers find this resource and supports a small, independent shop. Thank you!

—
This is a digital product. No physical item will be shipped. Due to the nature of digital downloads, all sales are final.
© Bo Prompt Studio. For personal use only. Do not redistribute or resell.