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

SQL / CHAPTER 04

SQL
Schema design.

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

9 lessons available

Learn0/9

Practice0/9

Challenges0/3

The foundations behind your ideas.

1. 01

   CREATE TABLE and types · Locked

   CREATE TABLE and types

   Open lesson
2. 02

   PRIMARY KEY and identity · Locked

   PRIMARY KEY and identity

   Open lesson
3. 03

   NOT NULL, DEFAULT, UNIQUE, CHECK · Locked

   NOT NULL, DEFAULT, UNIQUE, CHECK

   Open lesson
4. 04

   FOREIGN KEY 1:N · Locked

   FOREIGN KEY 1:N

   Open lesson
5. 05

   Junction table M:N · Locked

   Junction table M:N

   Open lesson
6. 06

   Normalization · Locked

   Normalization

   Open lesson
7. 07

   ALTER TABLE · Locked

   ALTER TABLE

   Open lesson
8. 08

   Integrity and invalid data · Locked

   Integrity and invalid data

   Open lesson
9. 09

   Mini library schema · Locked

   Mini library schema

   Open lesson