BeginnerCoder
Donate
Databases & SQL course cover

Databases & SQL

Run real SQL in your browser — SQLite via Python, no setup.

1
Lesson 1 — Create a table
basics · 7 min
→2
Lesson 2 — Insert rows
easy · 8 min
→3
Lesson 3 — Filtering with WHERE
medium · 9 min
→4
Lesson 4 — Sorting
medium · 8 min
→5
Lesson 5 — COUNT & SUM
medium · 10 min
→6
Lesson 6 — ORDER BY & LIMIT
medium · 9 min
→7
Lesson 7 — DISTINCT
medium · 8 min
→8
Lesson 8 — LIKE search
medium · 9 min
→9
Lesson 9 — AVG, MIN, MAX and ROUND
medium · 9 min
→10
Lesson 10 — Indexes (concept)
medium · 9 min
→11
Lesson 11 — Filtering with IN and BETWEEN
medium · 9 min
→12
Lesson 12 — JOIN
hard · 12 min
→13
Lesson 13 — GROUP BY
hard · 12 min
→14
Lesson 14 — HAVING
hard · 11 min
→15
Lesson 15 — Subqueries
hard · 12 min
→16
Lesson 16 — LEFT JOIN: keep rows without a match
hard · 12 min
→17
Lesson 17 — Conditional UPDATE
hard · 10 min
→18
Lesson 18 — Three-table JOIN
hard · 12 min
→19
Lesson 19 — GROUP BY + HAVING + ORDER
hard · 12 min
→20
Lesson 20 — Correlated subquery
hard · 12 min
→21
Lesson 21 — Recursive CTE
hard · 13 min
→22
Lesson 22 — Indexes & EXPLAIN (expert)
hard · 12 min
→23
Lesson 23 — Transactions & rollback
very hard · 15 min
→24
Lesson 24 — Views
very hard · 14 min
→25
Lesson 25 — Ultimate: sales report
★ ultimate · 15 min
→