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

SQL / CHAPTER 03

SQL
Mutations.

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

10 lessons available

Learn0/10

Practice0/10

Challenges0/3

The foundations behind your ideas.

1. 01

   INSERT with columns · Locked

   INSERT with columns

   Open lesson
2. 02

   Multi-row INSERT · Locked

   Multi-row INSERT

   Open lesson
3. 03

   NULL, DEFAULT, omitted columns · Locked

   NULL, DEFAULT, omitted columns

   Open lesson
4. 04

   UPDATE with WHERE · Locked

   UPDATE with WHERE

   Open lesson
5. 05

   UPDATE with calculations · Locked

   UPDATE with calculations

   Open lesson
6. 06

   DELETE with WHERE · Locked

   DELETE with WHERE

   Open lesson
7. 07

   What missing WHERE means · Locked

   What missing WHERE means

   Open lesson
8. 08

   RETURNING (PostgreSQL) · Locked

   RETURNING (PostgreSQL)

   Open lesson
9. 09

   SELECT before and after · Locked

   SELECT before and after

   Open lesson
10. 10

    Warehouse maintenance · Locked

    Warehouse maintenance

    Open lesson