Data AnalysisBeginner
SQL for Data Analysts
A practical, analyst-focused SQL course. You'll write real queries from day one using business datasets. Covers everything from basic SELECT statements to complex window functions and CTEs.
Tools & Technologies
PostgreSQLBigQueryDBeaver
Course Curriculum
1
SQL Foundations
- SELECT, FROM, WHERE
- Sorting & filtering
- NULL handling
2
Aggregation
- GROUP BY & HAVING
- COUNT, SUM, AVG, MIN, MAX
- Subqueries
3
Joins
- INNER, LEFT, RIGHT joins
- Multiple table queries
- Self-joins
4
Advanced SQL
- Window functions (ROW_NUMBER, RANK)
- CTEs
- Query optimisation
What's Included
Live instructor-led online session
Small cohort (max 12 delegates)
Course materials & code samples
CPD accredited certificate
Post-session recording (30 days)
Q&A with your instructor
£395+ VATEnrol Now Book for a team
per person, excluding local tax.
7 hours (1 day)
Next: Fri, 13 Mar 2026
10 seats remaining
Beginner level
2/12 seats filled
CPD accredited · Full refund 14 days before