Foundational program
SQL for Analysts
From zero to reliable queries: SQL patterns used daily in banking, insurance and super.
The program
What you or your team learns
What you walk away with.
- Core SELECT patterns: WHERE, ORDER BY, GROUP BY, HAVING and LIMIT
- Joins (inner, left, right, full) and set operations (union, intersect, except)
- INSERT, UPDATE and DELETE with guardrails and transaction thinking
- Schema navigation and data governance basics
- CTEs, subqueries and performance fundamentals
1 to 2 days
Course outline
- 1Relational concepts, tables and keys
- 2Querying confidently: filters, aggregations and joins
- 3Transforming data safely
- 4CTEs, window functions and optimising reads
- 5Working across environments (SQLite to enterprise databases)