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
Subqueries & Common Table Expressions
Subqueries in WHERE, FROM and SELECT
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