Databases & SQL

Every lesson runs in your browser — write real code, press Run, and the tasks check themselves. Free, no account needed, with translated notes paired with English.

Start the course

Lessons in this course

No lessons match. Clear the search or choose another filter.

1. history A short history of SQL Reading and resources
2. usage What SQL is used for Reading and resources
3. resources Where to learn more Reading and resources
4. setup Set up your computer Reading and resources
5. Databases and SELECT 01 · 3 required tasks · ★ Video
6. Choosing columns 02 · 3 required tasks · ★ Video
7. Filtering with WHERE 03 · 3 required tasks · ★★ Video
8. AND, OR, NOT 04 · 4 required tasks · ★★ Video
9. Sorting with ORDER BY 05 · 4 required tasks · ★★ Video
10. Counting and averaging 06 · 3 required tasks · ★★ Video
11. LIKE, IN and BETWEEN 07 · 4 required tasks · ★★ Video
12. Grouping with GROUP BY 08 · 3 required tasks · ★★★ Video
13. Tables, keys and relationships 09 · 3 required tasks · ★★ Video
14. INNER JOIN 10 · 3 required tasks · ★★★ Video
15. Joins with grouping 11 · 3 required tasks · ★★★★ Video
16. Creating tables 12 · 4 required tasks · ★★ Video
17. Changing the schema 13 · 3 required tasks · ★★ Video
18. Inserting rows 14 · 3 required tasks · ★★ Video
19. Updating rows 15 · 3 required tasks · ★★ Video
20. Deleting rows 16 · 3 required tasks · ★★ Video
21. Normalisation 17 · 3 required tasks · ★★★ Video

Language reference

/know/reference/sql