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

CODE LAB / SQL · POSTGRESQL

SQL
with PostgreSQL

Two chapters: first queries, then reports and joins. Temporary PostgreSQL in the browser.

SQL

06/06

6 chapters available

Queries against real tables.

1. 01

   CHAPTER 01

   Queries

   Tables, SELECT, filtering, sorting and expressions.

   Learn0/12

   Practice0/12

   Challenges0/3

   Open chapter
2. 02

   CHAPTER 02

   Reports & joins

   Aggregates, grouping and joining tables.

   Learn0/10

   Practice0/10

   Challenges0/3

   Open chapter
3. 03

   CHAPTER 03

   Mutations

   INSERT, UPDATE, DELETE, and RETURNING on a temporary database.

   Learn0/10

   Practice0/10

   Challenges0/3

   Open chapter
4. 04

   CHAPTER 04

   Schema design

   CREATE/ALTER, keys, constraints, and normalization.

   Learn0/9

   Practice0/9

   Challenges0/3

   Open chapter
5. 05

   CHAPTER 05

   Advanced queries

   CASE, subqueries, EXISTS, CTEs, UNION, and a monthly report.

   Learn0/11

   Practice0/11

   Challenges0/3

   Open chapter
6. 06

   CHAPTER 06

   Analytics

   Dates, date_trunc, window functions, ranks, running totals, and trends.

   Learn0/11

   Practice0/11

   Challenges0/3

   Open chapter