Tey Mascot

LOADING.

Every expert you admire was once a beginner who refused to quit.

Learn SQL for Beginners: Real Queries, Free to Start | Teyro

Coding · Beginner

SQL and Databases for Beginners

Learn SQL the fun way: build a real booking database for a 100-year-old cinema, running real queries in every lesson, right on your phone.

50 lessons
5 units
9h 12m
Up to 850 XP

I wrote this one myself. Start now and I'll count your streak from lesson one.

What you'll learn

Design tables with the right columns, types and keys
Add, change and delete data safely
Ask precise questions with SELECT, WHERE and ORDER BY
Combine tables with JOIN and LEFT JOIN
Summarise data with COUNT, SUM, AVG and GROUP BY
Protect data with constraints, transactions and indexes

Course path

5 units · 50 lessons

Seat G7, sold twice10 min · InteractiveFree+10 XP
Rows and columns10 min · InteractiveFree+10 XP
Why the shoebox lies10 min · InteractiveFree+10 XP
CREATE TABLE films11 min · InteractiveFree+10 XP
Checkpoint: Arjun's first call12 min · InteractiveFree+20 XP
INSERT INTO11 min · InteractiveFree+10 XP
One table or two?11 min · InteractiveFree+10 XP
Every row needs an id10 min · InteractiveFree+10 XP
Empty is not zero10 min · InteractiveFree+10 XP
Unit Challenge: Starlight v114 min · InteractiveFree+20 XP
Unit 1 chestFinish every lesson in this unit+50 XP

WHERE: only the rows you want10 min · Interactive
Bigger, smaller, not equal10 min · Interactive
AND, OR and brackets11 min · Interactive
ORDER BY and LIMIT10 min · Interactive
Checkpoint: Walt's Tuesday list12 min · Interactive
LIKE and wildcards10 min · Interactive
IN and BETWEEN10 min · Interactive
Who has no email?10 min · Interactive
DISTINCT, AS and maths11 min · Interactive
Unit Challenge: Walt vs the database14 min · Interactive
Unit 2 chestFinish every lesson in this unit+50 XP

Teyro Original · Chapter 1 free, then Teyro Pro