Data AnalyticsBeginner
SQL for Data Analysts
SQL is the single most consistently in-demand data skill across every sector. This focused one-day session takes you from your first SELECT statement through to window functions and CTEs — with every exercise using realistic business datasets. No prior database experience needed.
Tools & Technologies
PostgreSQLBigQueryDBeaver
Course Curriculum
1
SQL Foundations
- SELECT, FROM, WHERE, ORDER BY
- Filtering data and handling NULLs
- String, date, and numeric functions
2
Aggregation & Grouping
- GROUP BY and HAVING
- COUNT, SUM, AVG, MIN, MAX
- Subqueries and derived tables
3
Joins
- INNER, LEFT, RIGHT, and FULL joins
- Multi-table queries with real schemas
- Self-joins and when to use them
4
Advanced SQL
- Window functions: ROW_NUMBER, RANK, LAG, LEAD
- Common Table Expressions (CTEs)
- Query optimisation basics
What's Included
Live instructor-led session
Small cohort
Course materials pack (slides, code, datasets)
Certificate of completion
14-day email support
£740Early bird
£495Save £245
per person
7 hours (1 day)
Next: Fri, 13 Mar 2026
10 seats remaining
Beginner level
2/12 seats filled
Completion certificate included