SQLLearn
LessonsLog inSign up

Lessons

9 free lessons

✦ Start here — free, no sign-up

Lesson 1: What is SQL? Database basics

Your first step into SQL. Write an actual query in your browser and get a feel for retrieving data. No installation needed — you can start right now.

📝 3 questions⏱ ~5 min🎓 Beginner
Start this lesson →
No sign-up, no installation

Beginner course

0 / 5 complete
1
Beginner

What is SQL? Database basics

Learn the basic concepts of databases and SQL

3 questions →
2
Beginner

The basics of the SELECT statement

Learn the fundamentals of retrieving data with SELECT

3 questions →
3
Beginner

Filtering with the WHERE clause

Learn how to filter data by specifying conditions

3 questions →
4
Beginner

Sorting and limiting results with ORDER BY / LIMIT

Learn how to sort data and limit the number of results

3 questions →
5
Beginner

INSERT, UPDATE, and DELETE

Learn how to add, update, and delete data

3 questions →

Intermediate course

0 / 4 complete
🔒 Login required
1
Intermediate

Combining tables with JOIN

Learn how to combine multiple tables to retrieve data

3 questions →
🔒 Login required
2
Intermediate

Aggregating data with GROUP BY and HAVING

Learn how to group data and aggregate it

3 questions →
🔒 Login required
3
Intermediate

Subqueries

Learn how to write a query inside another query

3 questions →
🔒 Login required
4
Intermediate

Modeling many-to-many relationships with a junction table

Understand many-to-many relationships using a junction table (order_products)

3 questions →