For spreadsheet and BI people
You already do analysis. SQL is the same work in other words.
Filter, pivot, VLOOKUP: you know the ideas.
What you do now, in SQL
| In a spreadsheet or BI tool | In SQL | Lesson |
|---|---|---|
| A sheet with one row per order | A table: rows, columns and a keyWhy one order is one row, and what identifies it. | Day 1 · free |
| Hiding columns you don’t need | SELECT the columns, FROM the tableAsk a table for exactly what you want to see. | Day 2 · free |
| Filter and sort | WHERE, AND / OR, ORDER BYIncluding the empty cell that is not equal to anything. | Day 3 · free account |
| A helper column with IF | CASE WHEN … THEN … ENDLabel rows by a rule, in the query itself. | Day 4 · free account |
| A pivot table with SUM and COUNT | GROUP BY with SUM, COUNT, AVGNine thousand orders into one line per category. | Day 5 · free account |
| Counting unique customers | COUNT(DISTINCT …)Orders and people are different numbers. | Day 6 · free account |
| A sheet that feeds the next sheet | WITH: named stepsA question broken into steps that read top to bottom. | Day 7 · free account |
| VLOOKUP / XLOOKUP | JOIN … ON, LEFT JOINWhich rows each kind of join keeps. | Day 8 · free account |
| A lookup key that matches several rows | A JOIN that multiplies rowsThe doubled total, and how to add up before you join. | Day 9 · free account |
| A running total column | Window functions: SUM() OVER, ranksThen a report you can hand over. | Day 10 · free account |
Where to begin
“I want the SQL words first”
Days 1 and 2 need no account; a free account opens all ten. What you know from Excel goes fast.
Start day 1, free →“Show me the analysis part”
Case 1 starts from a ready query: read it, then find the trap.
Open case 1, free →“I just need to check one number”
Paste what an AI or a dashboard said about a number and get the questions to ask back. No code.
Open the AI Answer Checker, free →All ten days of the course are free with an account. You pay only for practice beyond it: case rounds in Atterna Foundations · €19 and, once the words are familiar, eight episodes of analyst work in Atterna Analyst · €59. Not sure? The level check is six questions and tells you where to begin.