SQL for Analysts
From zero to reliable queries: learn SQL patterns used daily in banking, insurance and super.
Outcomes
- Core SELECT patterns: WHERE, ORDER BY, GROUP BY, HAVING, LIMIT
- Joins (INNER/LEFT/RIGHT/FULL) and set ops (UNION/INTERSECT/EXCEPT)
- INSERT/UPDATE/DELETE with guardrails and transaction thinking
- Schema navigation and data governance basics
- CTEs, subqueries and performance fundamentals
Outline (1–2 days)
- Relational concepts, tables and keys
- Querying confidently: filters, aggregations and joins
- Transforming data safely
- CTEs, window functions and optimising reads
- Working across environments (SQLite → enterprise DBs)
Investment
$670 + GST per single‑day module.
Course materials
Aligned to common enterprise DBMSs; examples shown with SQLite and adapted to your stack.