Data and AI

SQL for Data Analysis

Query, join, and aggregate real data confidently — the single most-required skill in data analyst job postings

18h4 lessonsTier 2 hireabilityTier 2 certificate

What you'll be able to do

You can write SQL queries to filter, join, aggregate, and transform data across multiple tables to answer genuine business questions, and can read an unfamiliar schema well enough to write correct queries against it.

Job titles this qualifies you for

Data AnalystBusiness Intelligence AnalystReporting Analyst
Market intelligence
Demand
High
Remote
78% remote roles
Nigeria salary
Not a primary local hiring category
Remote (USD)
$45,000–$65,000/year for entry-level remote roles; $62,500–$97,000/year broader remote market range; top earners (90th percentile) around $120,500/year

Lessons

Stage 1 — Foundation
1
SELECT, Filter, and Sort Fundamentals
40 min
2
Joins Across Multiple Tables
45 min
Stage 2 — Applied
1
Aggregation, GROUP BY, and HAVING
40 min
2
Subqueries, CTEs, and Window Functions
45 min
Tier 2 Proof Submission

SQL for Data Analysis Portfolio

Demonstrate genuine SQL competence across filtering, joining, aggregating, and advanced querying against a real or realistic multi-table dataset.

1.A filtered, sorted query against a realistic orders dataset
2.A LEFT JOIN query answering a 'never happened' business question
3.A joined, grouped, HAVING-filtered revenue-by-region query
4.A window-function ranking query with an explanation of why GROUP BY alone couldn't answer it
Create a free account to join this programJoin free →