SQL for Data Analysis: Work as an Analyst
Work as the analyst for three companies. Answer real business questions in SQL, build three portfolio projects, and pass a timed skills test.
- Free
- About 24 hours
- 117 lessons
- Beginner
383 practice questions · 2 timed tests · a score for each skill area
You’ll learn toContents
- Turn a manager's question into a query, check the result, and say the answer in one sentence
- Clean and validate messy data (missing values, duplicates, stray text, wrong types) before you trust a number
- Join, group and rank with confidence: CTEs, subqueries, window functions, top-N per group, month-over-month change
- Measure the business: margin after refunds, funnels, cost per customer, response times, cohort retention, churn and an A/B test
- Show your work: three portfolio projects, each with SQL, a chart and a one-page recommendation
- Pass interview-style SQL problems on data you have never seen, and check SQL that an AI tool wrote
Free, about 25 hours, all in your browser, even on a phone. You join an online shop, a city service desk and a fitness app as their analyst. Managers send you questions. You answer with SQL on messy, realistic data, then make a chart and a short memo. You practise interview-style problems and finish with three portfolio projects, a timed skills test and a certificate.
- Chapter 1 · Getting started: your first week as an analystMeet the three companies and the job, run a first query in under 10 minutes, and see where you start.
Your first request5 lessons · 2 optionalFree
- Welcome to Quillon
- Your skills map
- Build your first query, one clause at a time
- First look at the shop
- Where you start
- Words analysts use
- Key points
- Chapter 2 · Case file A: Quillon Home, where the money goesAnswer Quillon's managers about orders, data quality, sales, margin and marketing, then write the CEO a one-page memo on where the shop loses money.
Pull the right rows6 lessons · 1 optional
- The brief
- Build the query, clause by clause
- NULL: the value that is not a value
- Sam's order questions
- Key terms
- Assessment
- Key points
Clean, validate and reconcile6 lessons · 1 optional
- The brief
- Build the query
- The five checks before any number leaves your desk
- Make the city report tie
- Key terms
- Assessment
- Key points
Summarise and trend the business6 lessons · 1 optional
- The brief
- Build the query: the monthly trend
- Why WHERE and HAVING differ
- Lena's board numbers
- Key terms
- Assessment
- Key points
Join tables without double-counting6 lessons · 1 optional
- The brief
- Add one table at a time, and count your rows
- The fan-out trap: why my discounts doubled
- Tomás's lists, without double-counting
- Key terms
- Assessment
- Key points
Margin, discounts and refunds6 lessons · 1 optional
- The brief
- Build the query
- Revenue is not profit
- Priya's margin check
- Key terms
- Assessment
- Key points
Which marketing pays: funnels and attribution6 lessons · 1 optional
- The brief
- Build a funnel, one CTE per step
- Attribution in plain words: first touch vs last touch
- Tomás's campaign review
- Key terms
- Assessment
- Key points
Project 1 · Where Quillon loses money5 lessons · 1 optional
- The project brief
- Project 1: the numbers
- Project 1: the charts
- Report it
- Write your memo
- Interview drill 1: card transactions
- Chapter 3 · Case file B: Kestova, who stays and did the change work?Do the product analytics employers test most: ranking, cohorts, retention, churn, recurring revenue and an A/B test you can trust.
Rank and band users: window functions6 lessons · 1 optional
- The brief
- Build the query: top 3 per country
- Ranks, latest rows and bands
- Mei's leaderboard
- Key terms
- Assessment
- Key points
Cohorts and retention6 lessons · 1 optional
- The brief
- Build the query
- Reading a retention curve, and what not to share
- Mei's cohort table
- Key terms
- Assessment
- Key points
Churn and recurring revenue6 lessons · 1 optional
- The brief
- Build the query
- Churn definitions that disagree
- Jonah's investor numbers
- Key terms
- Assessment
- Key points
Reading an A/B test6 lessons · 1 optional
- The brief
- Build the readout
- Can we trust it? A 4-point checklist
- Mei's experiment readout
- Key terms
- Assessment
- Key points
Project 2 · Did the new onboarding work?5 lessons · 1 optional
- The project brief
- Project 2: the numbers
- Project 2: the charts
- Report it
- Write your memo
- Interview drill 2: support tickets
- Chapter 4 · Case file C: Marrowby City Services, are we keeping our promise?Use dates, distributions, trends, self-joins and calendars to measure how fast a city answers its residents, and report on its 72-hour promise.
Dates, times and three dialects6 lessons · 1 optional
- The brief
- Build the query: from timestamp to met the promise?
- Same idea, other databases
- How long do requests really take?
- Key terms
- Assessment
- Key points
Distributions and trends6 lessons · 1 optional
- The brief
- Build the query
- Mean vs median, and reporting fairly
- Ade's waits and backlog
- Key terms
- Assessment
- Key points
Gaps, self-joins and calendars6 lessons · 1 optional
- The brief
- Build a calendar in 3 stages
- Self-joins without fear
- Closed, then reopened?
- Key terms
- Assessment
- Key points
Project 3 · The 72-hour promise report5 lessons
- The project brief
- Project 3: the numbers
- Project 3: the charts
- Report it
- Write your memo
- Chapter 5 · Job ready: beyond this courseCarry your SQL to other databases and to AI-assisted work, practise interview screens, publish your projects, and prove your skills in a timed test.
SQL in the real world, and checking AI8 lessons · 1 optional
- The brief
- Build the query: check the AI's work
- Working with an AI assistant
- One language, many databases
- Make a view, make a table
- Fix the AI's query
- Key terms
- Assessment
- Key points
Interview practice4 lessons · 1 optional
- How SQL interviews work, and what is scored
- Interview drill 3: grocery deliveries
- Interview drill 4: course reviews
- Schema-only round
- Common analyst interview questions, and how to answer them
Publish your projects4 lessons · 1 optional
- Turn a project into a portfolio piece
- Your CV and LinkedIn lines
- Keep practising after this course
- Make the INSERT lines
- Check yourself
Skills test and certificate3 lessons · 3 optional
- How the skills test works
- Practice data: Brindlewick Bikes
- Practice skills test
- Exam data: Quayside Clinic
- Skills test
- Your certificate, and what next
Share