PostgreSQL Tutorial

Learn PostgreSQL from fundamentals to practical query optimization through concise, production-oriented lessons.

Start Here

Start with core SQL terms and continue through filtering, joins, grouping, modifications, and performance topics.

Open First Lesson

Core Sections

Querying Data
5 lessons
Filtering Data
9 lessons
Join Tables
9 lessons
Group Data
5 lessons
Set Operations
3 lessons
Common Table Expression (CTE)
2 lessons
Modifying Data
10 lessons
Transactions
1 lessons
Import / Export
2 lessons
Subquery
5 lessons
Managing Tables
17 lessons
Database Constraints
6 lessons
PostgreSQL Data Types
20 lessons
Conditional Expressions & Operators
5 lessons
Performance
6 lessons