Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        SQL projects for your portfolio

        SQL projects with a brief, realistic tables and a person waiting for the answer. Write the queries in the browser, get each step checked, and finish with a record you can share.

        Projects that move between tools

        One company brief, worked through each tool in turn. Your own tables carry from one stage to the next, and you finish with a written readout. Every brief is free to read.

        Hearthline
        ExcelSQLpandasPower BI
        ProjectFree

        Why is profit falling when sales are up?

        Your first week as Hearthline's data analyst. Turn a messy order export into gross profit in Excel, roll it up in SQL, measure what each discount code costs in pandas, chart the margin in Power BI and tell your manager what to change.

        5 stages · 2 h 30 minView brief
        Greenbasket Market
        ExcelSQLPower BI
        Project

        Did the summer promotions pay?

        Marketing ran eight promotions this summer and wants to plan the fall. Turn the offers into numbers, measure each one against the weeks before it, total the extra sales and write the memo.

        4 stages · 2 h 30 minView brief
        Greenbasket Market
        Google SheetsSQLTableau
        Project

        The empty-shelf problem

        Store managers say shelves keep running empty, but the shelf checks are messy. Mark every check, compare the stores fairly and show availability next to how much was checked.

        4 stages · 2 h 10 minView brief
        Greenbasket Market
        SQLExcel
        Case study

        Why did September revenue drop?

        The monthly report shows September down on August, and the CFO wants to know why before the board meeting. Separate the calendar from a real decline and say where it came from.

        3 stages · 1 hView brief
        Greenbasket Market
        ExcelSQLPower BIGoogle SheetsTableau
        Journey

        Your first 90 days as a data analyst

        You've joined Greenbasket's two-person analytics team. Review the summer promotions, find the stores running out of stock, then explain a bad month to the CFO.

        4 chapters · 5 h 40 minSee the journey
        Pennant
        SQLpandasMachine learning
        Project

        Who cancels in the first 90 days?

        Pennant loses too many subscribers in their first three months. Build a churn table without peeking at the future, find who leaves, fit a first model and plan what the retention team should try.

        4 stages · 2 h 50 minView brief
        Pennant
        SQLpandas
        Case study

        Is the annual offer result real?

        A checkout test offered half the visitors an annual plan. The dashboard says it worked; count the test fairly and decide whether the difference is real before it ships.

        3 stages · 1 hView brief
        Copperline Freight
        SQLPower BI
        Case study

        Two dashboards, two on-time numbers

        Operations reports one on-time rate and finance reports a lower one, for the same month. Find out why, write the measure both teams agree on, and recommend which number goes to customers.

        3 stages · 1 hView brief
        Wayfriend
        DatabricksdbtSQLDagster
        Project

        From invites to meetups

        Wayfriend wants to know whether friends who plan to meet actually spend time together. Clean the raw events, model meetups, measure success and plan the next day of work.

        5 stages · 3 h 30 minView brief
        Wayfriend
        DatabricksSQL
        Case study

        The reminder question

        Denver tested reminder notifications before planned meetups. Decide whether Wayfriend should send them in every city.

        3 stages · 45 minView brief
        Wayfriend
        DatabricksdbtSQLDagster
        Journey

        Your first 90 days as a data engineer

        You've joined Wayfriend's two-person data team. Build the meetup pipeline, answer the growth team's first question, then keep it running.

        4 chapters · 8 hSee the journey

        Projects and case studies in the SQL course

        12 briefs inside the course, each a realistic task checked step by step in the tool.

        What you can show at the end

        A record with a verification code. Each project, case study and mock exam you finish gets a record that says what you did and when. Anyone you share the code with can check it.

        A portfolio page. Your records collect on one page you can link from a CV or a LinkedIn profile. Check a record

        A good SQL project

        A good SQL project answers a business question someone asked, and survives the awkward parts of real data: duplicates, missing values, a join that multiplies rows, a month with no sales. The projects here have those traps in them. Each step is checked against the result your query should return, and also on a hidden copy of the data, so a query that only works on the visible rows doesn’t pass.

        Two kinds of project

        The projects in the library above go across tools. In Did the summer promotions pay? you prepare offers in Excel, measure them in SQL and report them in Power BI. In Who cancels in the first 90 days? you build a churn table in SQL without looking into the future, then move to pandas.

        The projects and case studies inside the SQL course stay in SQL and follow the course levels, from the April numbers at beginner level to campaign attribution and the cost of stockouts at expert level.

        Talking about your project

        Interviewers ask about one project in depth. Know the grain of each table, why you joined the way you did, and what you checked before you trusted the number. You can rehearse that out loud in a spoken SQL interview, where the interviewer asks follow-up questions about your reasoning.

        For the next step, see data analytics projects or compare practice sites in the best SQL practice sites.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.