Free SQL Tutorial — learn SQL in 12 days
Topic by topic, day by day, with every example runnable right here in the page. No signup, no installation.
A free, hands-on SQL course
Twelve short lessons that take you from your first SELECT to joining four tables for a real management report. Every example runs in your browser — edit it, break it, run it again. Nothing to install and nothing to sign up for.
Start with Day 1, or open the demo database in a second tab first.
Who this is for
Anyone moving into a Data Analyst or MIS role. No programming background needed — if you can write an Excel formula, you can write SQL.
The 12 days
Day 1 — SQL SELECT and FROM
SQL is how you ask a database a question. Today you will write your first one and get an…Day 2 — SQL WHERE — filtering rows
Yesterday you chose columns. Today you choose rows — which is where SQL starts saving yo…Day 3 — SQL AND, OR, NOT, IN, BETWEEN, LIKE
Real questions have more than one condition. Today you learn to stack them — and where t…Day 4 — SQL NULL values — IS NULL and IS NOT NULL
NULL is the quiet cause of wrong numbers in reports. Half an hour today saves you a very…Day 5 — SQL ORDER BY, DISTINCT and LIMIT
Three small tools that turn a wall of rows into something a manager will actually read.…Day 6 — SQL COUNT, SUM, AVG, MIN and MAX
Up to now every query returned rows. Today one query returns a single number — the thing…Day 7 — SQL GROUP BY explained
This is the single most useful thing in SQL for reporting. Every "sales by region" repor…Day 8 — SQL HAVING vs WHERE
A classic interview question, and a genuine source of wrong reports: WHERE filters rows,…Day 9 — SQL INNER JOIN explained
Real data is spread across tables on purpose. JOIN is how you put it back together — and…Day 10 — SQL LEFT JOIN and self join
LEFT JOIN is how you find what is missing — inactive customers, unsold products, student…Day 11 — SQL joining three or more tables
Two tables was the lesson. Three is the job — because that is where the answers manageme…Day 12 — SQL practice questions with answers
No new syntax today. Twelve questions of the kind you get asked in an interview or on yo…How to get the most out of it
- Type the queries, do not copy them. The muscle memory matters more than you think.
- Break things on purpose. Remove a quote, misspell a column. Learning to read the error message is half the skill.
- Do the exercises at the bottom of each day before moving on.
- One day at a time. Twelve short sittings beat one long one.
Want this taught properly?
This tutorial covers the basics. Our SQL course in Noida takes you through window functions, CTEs and stored procedures on a real database, with projects and mentor support.
See the SQL course →