PostgreSQL

Included in Pro Max

Learn PostgreSQL on your iPhone

Learn PostgreSQL with 30 short lessons and 150 exercises. Each lesson explains the idea, shows you an example and gets you practicing, with an AI tutor that gives hints when you get stuck.

lessons
30
exercises
150
Beginner
10
Intermediate
10
Advanced
10
Syntax, the 3D SyntaxQuest mascot

What is PostgreSQL used for?

PostgreSQL is one of the most powerful and widely used open-source relational databases. Master indexes, transactions, JSON and advanced queries for professional backend work.

How the course starts

  1. 01

    Intro to PostgreSQL

    What PostgreSQL is, how to install it, and the first psql CLI commands.

  2. 02

    Databases and Tables

    CREATE DATABASE, CREATE TABLE, and basic types such as INTEGER, VARCHAR, BOOLEAN, and TEXT.

  3. 03

    Inserting Data

    INSERT INTO, default values, RETURNING, and multiple rows in a single statement.

  4. 04

    Basic Queries

    SELECT, WHERE, ORDER BY, LIMIT, and OFFSET to read and sort rows.

  5. 05

    Update and Delete

    Modify rows with UPDATE, remove them with DELETE, and clear tables with TRUNCATE.

  6. +25 more lessons in the app

    The full syllabus, the explanations and the practice are in the app.

PostgreSQL course syllabus

Beginner 10 lessons

  1. Intro to PostgreSQL
  2. Databases and Tables
  3. Inserting Data
  4. Basic Queries
  5. Update and Delete
  6. Numeric Types
  7. Text and Dates
  8. Special Types
  9. Constraints
  10. ALTER TABLE

Intermediate 10 lessons

  1. INNER JOIN
  2. LEFT and RIGHT JOIN
  3. Subqueries
  4. Aggregation
  5. UNION and Set Operations
  6. Built-in Functions
  7. Date Functions
  8. CASE and Conditionals
  9. Window Functions
  10. Creating Functions

Advanced 10 lessons

  1. Basic Indexes
  2. Index Types
  3. EXPLAIN and Analysis
  4. Query Optimization
  5. Transactions and MVCC
  6. Roles and Permissions
  7. Backup and Restore
  8. Views and Materialized Views
  9. Triggers and Events
  10. Production and Monitoring

A question from the course

Databases and Tables

Complete the statement to create the `store` database:

CREATE DATABASE ___;

The answer, the explanation and many more exercises are waiting for you in the app.

Download

Questions about the course

Is the PostgreSQL course free?

PostgreSQL is part of Pro Max. The app is free and you can start with the free courses before subscribing.

Do I need experience to learn PostgreSQL?

No. The course starts at beginner level (10 lessons) and moves on to intermediate and advanced at your pace.

How long is the PostgreSQL course?

It has 30 lessons and 150 exercises. Lessons are short, so you can move forward a few minutes a day; adaptive learning brings back what you are about to forget.