SQL for Data Analysts
0 of 18 lessons complete (0%)
Exit Course
SELECT, WHERE & Filtering Essentials
How a SELECT query is read and run
Preview
Filtering with WHERE, AND, OR, IN and BETWEEN
Practice: NULLs, DISTINCT and sorting
3 lessons
Aggregations, GROUP BY & HAVING
Aggregate functions: COUNT, SUM, AVG, MIN, MAX
GROUP BY and HAVING with a worked example
Practice: conditional aggregation
3 lessons
JOINs — INNER, LEFT, RIGHT, FULL
How joins match rows
Worked example: customers with and without orders
Practice: reconciling two tables
3 lessons
Subqueries & Common Table Expressions
Subqueries in WHERE, FROM and SELECT
CTEs: writing queries in readable steps
Practice: building a cohort table with CTEs
3 lessons
Window Functions — ROW_NUMBER, RANK, LAG
What window functions do
Worked example: top N per group and month-over-month change
Practice: running totals and moving averages
3 lessons
Real Analytics Project: Sales Dashboard Query
Project brief: defining the dashboard metrics
Building the dashboard query step by step
Practice: validating and presenting your results
3 lessons
JOINs — INNER, LEFT, RIGHT, FULL
Worked example: customers with and without orders
You don’t have access to this lesson
Please register or sign in to access the course content.
Take course
Sign in
Previous
Next
Editorial & AI Disclosure