Skip to content
Academy by Akazispace
Data · Beginner

SQL for Analysts

Query, join and summarise real data confidently, from a single table to a full report.

4.9 (3,082 students)Created by Patrick NkurunzizaUpdated September 2026

What you'll learn

  • Write SELECT, WHERE and ORDER BY queries confidently
  • Join tables without guessing
  • Group and summarise data with aggregates
  • Spot and fix common data-cleaning problems
  • Turn a query into a report someone else can read

About this course

Hands-on SQL, taught against a realistic sales and jobs dataset. No prior database experience needed.

  • SQL
  • Data cleaning
  • Reporting

Course content

3 modules · 9 lessons · 10 hours

  • 5 video
  • 1 resources
  • 1 reading
  • 1 quiz
  • 1 assignment
Module 1. The basics3 lessons · 25 min
  • SELECT, WHERE, ORDER BY12 min
  • Filtering and sorting well10 min
  • Course dataset3 min
Module 2. Combining data3 lessons · 38 min
  • Joins, explained with diagrams20 min
  • Common join mistakes12 min
  • Check: joins6 min
Module 3. Summarising3 lessons · 64 min
  • GROUP BY and aggregates16 min
  • Window functions, gently18 min
  • Revenue by region report30 min
PN

Instructor

Patrick Nkurunziza

Data Lead, Kivu Labs

Builds the analytics that hiring and product decisions at Kivu Labs run on.

Student ratings

4.9

3,082 students

5
86%
4
11%
3
2%
2
1%
1
0%