PostgreSQL

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.

   preview
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.