Tech Skills · Self-paced course
SQL for Data Analysts
A focused SQL course that teaches only the queries analysts use on the job, with practice on every module.
$27
One-time payment · Self-paced course · 6 modules · 18 lessons
Enroll now — $27Read a free preview lesson
What this is
No 40-hour bloat. A focused sprint teaching only what you need on the job. Real exercises, real datasets, real techniques. The course covers: SELECT, WHERE & Filtering Essentials; Aggregations, GROUP BY & HAVING; JOINs — INNER, LEFT, RIGHT, FULL; Subqueries & Common Table Expressions; Window Functions — ROW_NUMBER, RANK, LAG; Real Analytics Project: Sales Dashboard Query.
It is a self-paced course of written lessons and exercises. It does not include live instruction, one-to-one coaching or individual feedback on your work, and it cannot promise any particular job, income, ranking, certification or business result — what you get out of it depends on your own situation and the practice you put in.
What you will be able to do
- Write complex queries with JOINs & CTEs
- Use window functions for analytics
- Analyze real business datasets
- Prepare for SQL questions in analyst interviews
- Apply each module to your own work through practical exercises
The curriculum
Module 1
SELECT, WHERE & Filtering Essentials
- How a SELECT query is read and run
- Filtering with WHERE, AND, OR, IN and BETWEEN
- Practice: NULLs, DISTINCT and sorting
Module 2
Aggregations, GROUP BY & HAVING
- Aggregate functions: COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING with a worked example
- Practice: conditional aggregation
Module 3
JOINs — INNER, LEFT, RIGHT, FULL
- How joins match rows
- Worked example: customers with and without orders
- Practice: reconciling two tables
Module 4
Subqueries & Common Table Expressions
- Subqueries in WHERE, FROM and SELECT
- CTEs: writing queries in readable steps
- Practice: building a cohort table with CTEs
Module 5
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
Module 6
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

This is for you if…
- You prefer to learn at your own pace from written lessons and exercises
- You want a structured path through SQL for Data Analysts rather than scattered articles
- You are willing to practise on your own work as you go
- You want a one-time purchase rather than a subscription
What you get
- 18 written lessons across 6 modules, each with worked examples
- Practice exercises, most with a model answer to check your work against
- Lesson 1 free to read before you buy
- Self-paced access to the course in your Skill Stack Suite account
- One-time payment, no subscription
Questions
Is a certificate, licence or credential awarded?
No. This course does not award any certification, licence, accreditation or professional credential. It is educational content for your own learning.
Is this live or self-paced?
Fully self-paced. You work through the lessons on your own schedule; there are no live sessions.
Can I read a lesson before buying?
Yes. The free preview lesson linked at the top of this page is a complete lesson from the course.
How do I get access after paying?
Checkout is a one-time payment. After purchase, course access details are sent to the email address you use at checkout.
What if it is not right for me?
Email us within 30 days of purchase for a full refund.
SQL for Data Analysts
$27
One-time payment · Self-paced course · 6 modules · 18 lessons
Enroll now — $27Educational content only. This course does not promise any income, earnings, revenue, job or business results; outcomes depend on your own situation and effort. No certification, licence or professional credential is awarded.