HawkX

← All courses

Founding cohort · Live online course

SQL for Data Analysis

Pull the numbers yourself. Ask real databases real questions, without waiting on IT.

  • StartsTue 3 Nov
  • WhenTue & Thu, 19:00 CET
  • Length16 live classes
  • Class8–20 students

What you'll be able to do

  1. Write SELECT queries with filters, sorting and grouping
  2. Join several tables to answer business questions
  3. Use aggregates, subqueries and window functions
  4. Build a reusable analysis on a real dataset

Your final project · weeks 7–8

You'll build: An analysis of a real online-shop database that answers 5 business questions, like which customers bring the most revenue and which products are slipping.

What's included

  • 16 live classes with a real teacher
  • Ask questions and get help live
  • Materials and exercises after every class
  • Your own final project, with feedback
  • HawkX Certificate of Completion

Week by week

Two live classes a week. Weeks 7 and 8 are your project.

  1. Week 1

    Databases and your first query

    Tables, rows, SELECT, WHERE

  2. Week 2

    Sorting and summarising

    ORDER BY, COUNT, SUM, AVG, GROUP BY

  3. Week 3

    Joining tables

    INNER and LEFT joins, keys, common mistakes

  4. Week 4

    Cleaning data in SQL

    NULLs, CASE, text and date functions

  5. Week 5

    Subqueries and CTEs

    Breaking big questions into steps

  6. Week 6

    Window functions

    Rankings, running totals, month-over-month change

  7. Week 7

    Final project build

    Analyse a real dataset with the teacher's help

  8. Week 8

    Presentations + certificate

    Present your findings, get feedback, receive your certificate

Your teacher

  • A working professional who uses SQL in their day-to-day job
  • Passed a paid trial lesson with us before teaching you
  • Introduced to you by email 7 days before class 1

Your money is safe.

  • Take class 1. Not for you? Email before class 2, get 100% back.
  • Changed your mind before the start? 100% back.
  • Class doesn't reach 8 students by Sun 25 Oct? 100% back, automatically.

Is it for you?

Yes, if

  • You work with reports and want to pull the data yourself
  • You want to move into a data or analyst role
  • You know Excel and want the next step

Probably not, if

  • You already write complex SQL at work
  • You want database administration or server setup

Quick questions

What do I need?

A laptop (Windows, Mac or Linux) and a stable internet connection. Everything runs in your browser.

What if I miss a class?

Your teacher shares the materials and exercises after every class, so you can catch up before the next one.

How do I get the certificate?

Attend 13 of the 16 live classes and submit your final project. Your certificate has your name and a unique ID, ready for your CV and LinkedIn.

What language are classes in?

English.

More in the full FAQ.

Your seat for Tue 3 Nov is €99.

16 live classes, a real teacher, a project of your own.

Book my seat · €99

Questions? contact@hawkx.net, we reply within one working day.

€99Starts Tue 3 Nov
Book my seat