Command Categories

• DDL (Data Definition): CREATE, ALTER, DROP
• DML (Data Manipulation): SELECT, INSERT, UPDATE, DELETE
• JOIN types: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
• Aggregation: GROUP BY, HAVING

Comments

Single line: --

Multiple lines: /* */

Common Data Types

• INTEGER / REAL
• TEXT/VARCHAR(n)
• DATE / TIMESTAMP
• BOOLEAN
• NULL

Common Clauses & Order

Writing Order

1. SELECT
2. FROM
3. WHERE
4. GROUP BY