SQL from Scratch

🎓 All tutorials free · no login required · new lessons every week
Learn  ›  SQL  ›  SQL from Scratch
✦ Free · written step-by-step tutorial · no login

SQL from Scratch

Go from zero to writing real queries — SELECT, WHERE, JOINs, GROUP BY and more. Every lesson is a written, step-by-step guide with copy-paste code examples and the exact output you’ll see.

📖 30 lessons · 6 modules ~4 hrs of reading 🟢 Beginner friendly 🆓 Free · no login 🔄 Updated weekly
PK
Written by PKMicrosoft Certified Professional · 15+ yrs · @PK-AnExcelExpert · 297K+ subscribers

What you’ll learn

By the end you’ll be comfortable writing everyday SQL — the kind you’d actually use at work.
Write SELECT queries to pull exactly the data you need
Filter and sort results with WHERE and ORDER BY
Summarise data with GROUP BY and aggregate functions
Combine tables with every type of JOIN
Modify data safely with INSERT, UPDATE and DELETE
Tackle subqueries, views and window functions
Read real code examples with the exact output shown
Practise with exercises at the end of every chapter
Advertisement
Leaderboard / responsive ad unit

Course content

6 modules · 30 chapters · ~4h of reading Expand all
01
Getting Started4 chapters · ~20 min read
1SQL IntroductionStart here
2SQL Syntax5 min
3The SELECT Statement7 min
4SELECT DISTINCT5 min
02
Filtering & Sorting6 chapters · ~35 min read
5The WHERE Clause6 min
6ORDER BY6 min
7AND, OR & NOT7 min
8LIKE & Wildcards6 min
9IN & BETWEEN6 min
10NULL Values5 min
03
Functions & Aggregates5 chapters · ~35 min read
11COUNT, SUM & AVG8 min
12MIN & MAX5 min
13GROUP BY9 min
14HAVING7 min
15String & Date Functions8 min
04
Joining Tables6 chapters · ~50 min read
16INNER JOIN9 min
17LEFT & RIGHT JOIN10 min
18FULL OUTER JOIN8 min
19Self Join8 min
20UNION7 min
21Practice: Multi-table reportProject
05
Modifying Data4 chapters · ~30 min read
22INSERT INTO7 min
23UPDATE7 min
24DELETE6 min
25Constraints & Keys9 min
06
Going Further + AI5 chapters · ~40 min read
26Subqueries9 min
27Views7 min
28Window Functions11 min
29Common Table Expressions (CTEs)9 min
Writing SQL with AIBonus
Advertisement
In-article ad unit
Follow along

One dataset, all the way through

Every example uses the same simple Customers & Orders tables, shown right in the lesson — so you can read the query, see the exact result, then copy the code and run it in your own SQL tool.

Your instructor

PK
PK
Founder, Neotech Navigators · Microsoft Certified Professional

PK is a Microsoft Certified Professional with 15+ years in data visualization, Excel automation and dashboard creation. Through Neotech Navigators and the @PK-AnExcelExpert YouTube channel (297K+ subscribers), PK has taught practical data skills to learners around the world. The approach here is simple: clear explanations, real code you can copy, and a short practice at the end of every lesson.

Microsoft Certified15+ years experience297K+ YouTube subscribers500+ tutorials published

Frequently asked

Is this course really free?+

Yes — every chapter is free and there’s no login or signup. The site is supported by Google AdSense, so the tutorials always stay open for everyone.

Do I need to install any software?+

No. Each lesson shows the SQL and the exact output right on the page, plus copy-paste code you can run in any SQL tool — SQLite, MySQL, PostgreSQL or the database of your choice.

Do I need prior experience?+

None at all. The course starts from absolute basics and builds up gradually — module one assumes you’ve never written a query before.

Is there a video version?+

Yes — matching walkthroughs are on the @NeotechNavigators YouTube channel. Read here, watch there — whichever suits you.

Advertisement
Leaderboard / responsive ad unit