Skip to main content

Introduction to PostgreSQL

8 Topics • 22 Lessons

The powerful open-source database - tables and types, querying, indexes, JSONB, roles, and operating it well.

Course Contents

Start Here

1 lesson

Welcome & How to Use This Course

What Postgres Is & Installing It

3 lessons

What PostgreSQL Is and Why It Wins

Installing Postgres and Connecting with psql

Check Yourself

Databases, Tables & Types

3 lessons

Creating a Database and Your First Table

Constraints and a Two-Table Schema

Check Yourself

CRUD & Querying

3 lessons

Inserting and Reading Data

Changing Data, Aggregates, Joins, and Upserts

Check Yourself

Indexes & Performance

3 lessons

What Indexes Are and How to Create Them

Choosing Indexes and Reading Query Plans

Check Yourself

JSONB & Advanced Types

3 lessons

Storing and Querying JSONB

Indexing JSONB, Arrays, and Design Guidance

Check Yourself

Users, Roles & Security

3 lessons

Roles and Least-Privilege Access

Authentication, Network, and Safe Queries

Check Yourself

Operating Postgres

3 lessons

Backups and Schema Migrations

Scaling, Replication, and Monitoring

Check Yourself