← Back to Tools
PostgreSQL

Tool

PostgreSQL

A powerful, standards-compliant open-source database

Learn PostgreSQL-specific features — constraints, window functions, and JSONB.

8

Chapters

17

Hours (estimated)

1

Self-paced

Part-time

About 6 weeks

1 hour a day, 3 days a week

Full-time

About 2 weeks

3 hours a day, 3 days a week

Estimated from 8 chapters (notes, practice, labs, quiz, exercise, and challenge) plus the final exam. Go at your own pace.

Curriculum

8 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.

  1. 1

    Introduction to PostgreSQL

    What sets Postgres apart, and connecting to a database.

  2. 2

    Data Types

    Postgres-specific types including JSONB and arrays.

  3. 3

    Constraints

    NOT NULL, UNIQUE, CHECK, and foreign keys.

  4. 4

    Joins

    INNER, LEFT, and combining tables.

  5. 5

    Indexes

    B-tree, GIN, and choosing the right index.

  6. 6

    Window Functions

    Calculations across rows without collapsing them.

  7. 7

    JSONB Columns

    Storing and querying semi-structured data.

  8. 8

    Transactions

    ACID guarantees and isolation levels.

Start learning — it's free →

PostgreSQL is free to study, self-paced. Pass the final exam to earn an optional Certificate of Completion for $40.