Zafari Academy

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 to
  • 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
About

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.

Contents
  1. 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.
  2. Your first request5 lessons · 2 optionalFree
    • Welcome to QuillonReading
    • Your skills mapReading
    • Build your first query, one clause at a timeReading
    • First look at the shopSQL
    • Where you startShort assessment
    • Words analysts useFlashcards
    • Key pointsReading
  3. 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.
  4. Pull the right rows6 lessons · 1 optional
    • The briefReading
    • Build the query, clause by clauseReading
    • NULL: the value that is not a valueReading
    • Sam's order questionsSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  5. Clean, validate and reconcile6 lessons · 1 optional
    • The briefReading
    • Build the queryReading
    • The five checks before any number leaves your deskReading
    • Make the city report tieSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  6. Summarise and trend the business6 lessons · 1 optional
    • The briefReading
    • Build the query: the monthly trendReading
    • Why WHERE and HAVING differReading
    • Lena's board numbersSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  7. Join tables without double-counting6 lessons · 1 optional
    • The briefReading
    • Add one table at a time, and count your rowsReading
    • The fan-out trap: why my discounts doubledReading
    • Tomás's lists, without double-countingSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  8. Margin, discounts and refunds6 lessons · 1 optional
    • The briefReading
    • Build the queryReading
    • Revenue is not profitReading
    • Priya's margin checkSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  9. Which marketing pays: funnels and attribution6 lessons · 1 optional
    • The briefReading
    • Build a funnel, one CTE per stepReading
    • Attribution in plain words: first touch vs last touchReading
    • Tomás's campaign reviewSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  10. Project 1 · Where Quillon loses money5 lessons · 1 optional
    • The project briefReading
    • Project 1: the numbersSQL
    • Project 1: the chartsDashboard
    • Report itShort assessment
    • Write your memoReading
    • Interview drill 1: card transactionsSQL
  11. 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.
  12. Rank and band users: window functions6 lessons · 1 optional
    • The briefReading
    • Build the query: top 3 per countryReading
    • Ranks, latest rows and bandsReading
    • Mei's leaderboardSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  13. Cohorts and retention6 lessons · 1 optional
    • The briefReading
    • Build the queryReading
    • Reading a retention curve, and what not to shareReading
    • Mei's cohort tableSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  14. Churn and recurring revenue6 lessons · 1 optional
    • The briefReading
    • Build the queryReading
    • Churn definitions that disagreeReading
    • Jonah's investor numbersSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  15. Reading an A/B test6 lessons · 1 optional
    • The briefReading
    • Build the readoutReading
    • Can we trust it? A 4-point checklistReading
    • Mei's experiment readoutSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  16. Project 2 · Did the new onboarding work?5 lessons · 1 optional
    • The project briefReading
    • Project 2: the numbersSQL
    • Project 2: the chartsDashboard
    • Report itShort assessment
    • Write your memoReading
    • Interview drill 2: support ticketsSQL
  17. 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.
  18. Dates, times and three dialects6 lessons · 1 optional
    • The briefReading
    • Build the query: from timestamp to met the promise?Reading
    • Same idea, other databasesReading
    • How long do requests really take?SQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  19. Distributions and trends6 lessons · 1 optional
    • The briefReading
    • Build the queryReading
    • Mean vs median, and reporting fairlyReading
    • Ade's waits and backlogSQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  20. Gaps, self-joins and calendars6 lessons · 1 optional
    • The briefReading
    • Build a calendar in 3 stagesReading
    • Self-joins without fearReading
    • Closed, then reopened?SQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  21. Project 3 · The 72-hour promise report5 lessons
    • The project briefReading
    • Project 3: the numbersSQL
    • Project 3: the chartsDashboard
    • Report itShort assessment
    • Write your memoReading
  22. 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.
  23. SQL in the real world, and checking AI8 lessons · 1 optional
    • The briefReading
    • Build the query: check the AI's workReading
    • Working with an AI assistantReading
    • One language, many databasesReading
    • Make a view, make a tableReading
    • Fix the AI's querySQL
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  24. Interview practice4 lessons · 1 optional
    • How SQL interviews work, and what is scoredReading
    • Interview drill 3: grocery deliveriesSQL
    • Interview drill 4: course reviewsSQL
    • Schema-only roundShort assessment
    • Common analyst interview questions, and how to answer themReading
  25. Publish your projects4 lessons · 1 optional
    • Turn a project into a portfolio pieceReading
    • Your CV and LinkedIn linesReading
    • Keep practising after this courseReading
    • Make the INSERT linesSQL
    • Check yourselfShort assessment
  26. Skills test and certificate3 lessons · 3 optional
    • How the skills test worksReading
    • Practice data: Brindlewick BikesSQL
    • Practice skills testPractice exam
    • Exam data: Quayside ClinicSQL
    • Skills testPractice exam
    • Your certificate, and what nextReading