The ClearJob course
Build practical skills for analytics and data roles.
Learn SQL, product analytics, case studies and guesstimates through clear lessons and practice designed around the work you want to do.
Self-paced · Free to use · No sign-in
Build skills by working through real problems.
Query data with SQL
Write, run, and refine queries against practice datasets.
Think through cases
Structure an investigation and explain your choices.
Estimate with clarity
State assumptions and work through guesstimates.
Communicate your reasoning
Practise writing answers as you would explain them in an interview.
See what’s inside
Browse the modules and open any lesson.
Analytics foundationsConcepts, metrics, and working with data
SQL for analyticsQueries, joins, aggregations, and window functions
- SELECT, WHERE and ORDER BY12 min
- Aggregation and GROUP BY15 min
- Joins and NULLs18 min
- Window functions20 min
Product analytics & metricsFunnels, retention, experiments, and decisions
- Funnels and conversion14 min
- Retention and cohorts14 min
- Experiments and decisions15 min
Case studies & guesstimatesPractice structuring and communicating your approach