◈ Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.

SQL / CHAPTER 01

SQL
Queries.

Learn SQL with real tables and PostgreSQL in your browser. Learn and Practice per topic, separate challenges.

Choose a section

LearnPracticeChallenges

Lesson with explanation and a guided task. Theory stays readable; completion requires a passing solution.

Challenges are optional and do not block the next chapter.

Start lesson Random task

SQL

12 lessons available

Learn0/12

Practice0/12

Challenges0/3

The foundations behind your ideas.

1. 01

   Tables and SELECT

   Tables and SELECT

   Start lesson
2. 02

   Selecting columns · Locked

   Selecting columns

   Open lesson
3. 03

   Aliases with AS · Locked

   Aliases with AS

   Open lesson
4. 04

   Filtering with WHERE · Locked

   Filtering with WHERE

   Open lesson
5. 05

   AND, OR, NOT and parentheses · Locked

   AND, OR, NOT and parentheses

   Open lesson
6. 06

   IN and BETWEEN · Locked

   IN and BETWEEN

   Open lesson
7. 07

   Patterns with LIKE · Locked

   Patterns with LIKE

   Open lesson
8. 08

   Missing data: NULL · Locked

   Missing data: NULL

   Open lesson
9. 09

   Distinct results · Locked

   Distinct results

   Open lesson
10. 10

    Ordering results · Locked

    Ordering results

    Open lesson
11. 11

    The first N rows · Locked

    The first N rows

    Open lesson
12. 12

    Calculated columns · Locked

    Calculated columns

    Open lesson