TODAY'S LESSON
25 min
SQL foundations · Chapter 1 of 4
Filter data with confidence
Learn how WHERE turns a large table into the exact answers an analyst needs.
CCareerGuide
Welcome back.
You have one focused step today. Finish it in about 25 minutes.
Your learning path
Built around the skills employers ask for in your target market.
FOUNDATION 01
Complete
Understand the analyst role
5 lessons · Completed
CORE SKILL 02
Query data with SQL
2 of 8 lessons complete
CORE SKILL 03
⌁
Build reports in Power BI
7 lessons · Next up
JOB READY 04
⌁
Prove your skills with a portfolio
4 guided projects
YOUR 12-WEEK PLAN
Learning path
A practical route from foundation skills to a job-ready portfolio.
25%
Overall progress
8
Lessons completed
9h
Time invested
02
CURRENT CHAPTER
Query data with SQL
Build the skills to retrieve, filter, group, and combine business data.
- How databases organise information
- Select columns from a table
- Filter data with confidence
- Sort and limit results
- Summarise with aggregate functions
- Group results for comparison
- Join related tables
- Complete the sales analysis exercise
CAREER EXPLORER
Compare realistic next steps
Understand the work, expectations, and gaps before committing to a path.
Data Analyst
Turn business questions into clear answers using data.
- Typical preparation
- 3–6 months
- Priority skills
- SQL, Excel, Power BI
- Language context
- English; French helpful
Business Analyst
Improve processes by translating business needs into workable solutions.
- Typical preparation
- 2–5 months
- Priority skills
- Process mapping, SQL, communication
- Language context
- English and French often requested
Analytics Engineer
Build reliable data models that analysts and teams can use.
- Typical preparation
- 6–12 months
- Priority skills
- Advanced SQL, dbt, data modelling
- Language context
- English commonly accepted
YOUR PROGRESS
Small steps, visible growth
Review what you can now do—not just how much content you finished.
Skills you have demonstrated
Role understandingReady to explain the analyst workflow
DemonstratedBasic SQL queriesCan retrieve and select relevant columns
BuildingFiltering dataComplete today's lesson to demonstrate this
NextYour evidence
Completed work will become examples you can discuss in applications and interviews.
＋Your first portfolio exercise starts in Chapter 2
We’ll guide you through the brief, work, and explanation.