SQL TL;DR Cheatsheet
Learn SQL 10× faster with the cleanest, zero fluff content
SQL Fundamentals & DDL
What is SQL & DDL?
CREATE • ALTER • DROP • Schemas • Constraints • Data Types
SELECT & Filtering
WHERE • LIKE • IN/BETWEEN • NULL Handling • DISTINCT
Joins Deep Dive
INNER • LEFT • RIGHT • FULL • CROSS • Self Joins
INSERT • UPDATE • DELETE
INSERT INTO • UPDATE SET • DELETE FROM • TRUNCATE • MERGE
Aggregation & Analytic SQL
GROUP BY & Aggregates
COUNT • SUM • AVG • MIN/MAX • HAVING vs WHERE
Window Functions
ROW_NUMBER • RANK • LEAD/LAG • Running Totals • NTILE
Subqueries & CTEs
WITH Clause • Correlated • Recursive CTEs • UNION
CASE • Dates • Logic
CASE WHEN • COALESCE • NULLIF • Date Functions • CAST
Performance & Query Tuning
Indexing Strategy
Clustered vs Non-Clustered • B-Tree • Composite • Covering
Execution Plans
EXPLAIN • Cost Analysis • Statistics • Query Hints
Normalization & Design
1NF • 2NF • 3NF • BCNF • Keys • Denormalization Trade-offs
Transactions & Security
Transactions & ACID
BEGIN • COMMIT • ROLLBACK • Isolation Levels • Deadlocks
Stored Procs & Functions
CREATE PROCEDURE • Triggers • Views • Dynamic SQL
Security & Permissions
GRANT • REVOKE • Roles • Row-Level Security • Auditing