SQL Master

Professional SQL
Reference Pack

A practical SQL reference for practice, interviews, and everyday analytics work.

  • 21-page PDF
  • 20 pages of SQL content
  • 19 focused guides
  • PostgreSQL, SQL Server & MySQL
Get SQL Master Pro

The Professional SQL Reference Pack is included with SQL Master Pro.

Cover of the SQL Master Professional SQL Reference Pack
Ranking Functions preview page from the SQL Master reference pack

19 focused guides

What's inside

A focused path from core filtering and aggregation to window functions and interview distinctions.

SQL Fundamentals

  • Logical Query Processing Order
  • SELECT, DISTINCT, TOP & LIMIT
  • WHERE & Filtering

Aggregation

  • Aggregate Functions
  • GROUP BY & HAVING

Joining Data

  • JOIN Types
  • LEFT JOIN Pitfalls
  • UNION vs UNION ALL

Advanced Querying

  • Subqueries
  • EXISTS vs IN
  • Common Table Expressions
  • CASE WHEN
  • NULL Handling

Functions

  • String Functions
  • Date & Time Functions

Window Functions

  • Window Functions Basics
  • ROW_NUMBER vs RANK vs DENSE_RANK
  • LAG, LEAD & Running Totals

Interview

  • SQL Interview Quick Reference

Real product pages

Preview the pack

These previews are generated directly from the finished reference pack.

Built for understanding

More than a syntax sheet.

Real queries

Learn from practical SQL examples.

Exact outputs

See what each query actually returns.

Common mistakes

Avoid JOIN, NULL, ranking, and filtering traps.

Dialect-aware

PostgreSQL, SQL Server, and MySQL differences noted where relevant.

Actual SQL Interview Quick Reference page

Final guide

SQL Interview Quick Reference

Review WHERE vs HAVING, COUNT(*) vs COUNT(column), INNER vs LEFT JOIN, UNION vs UNION ALL, IN vs EXISTS, ranking behavior, and common NULL traps on one scannable page.

getsqlmaster.com

Keep SQL close when you need it.

19 focused guides covering the SQL concepts you use in practice, interviews, and analytics work.

Get SQL Master Pro

The Professional SQL Reference Pack is included with SQL Master Pro.