SQL Cheat Sheet

Learning SQL becomes far easier when the core concepts are consolidated in one place. Whether you're starting out or preparing for technical interviews, this SQL cheat sheet serves as a quick reference to strengthen your database fundamentals.

What's covered:

→ Data Types — numeric, character, date/time, and boolean

→ SQL Command Categories — DDL, DML, DQL, DCL, and TCL

→ Clauses — SELECT, WHERE, GROUP BY, HAVING, ORDER BY

→ Joins — INNER, LEFT/RIGHT OUTER, FULL OUTER, CROSS, and SELF

→ Functions — aggregate, scalar, numeric, and string

→ Operators & Logical Query Processing Order

→ Keys & Constraints — primary, foreign, unique, composite, NOT NULL, CHECK, DEFAULT