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
Introduction to PostgreSQL
What sets Postgres apart, and connecting to a database.
- 2
Data Types
Postgres-specific types including JSONB and arrays.
- 3
Constraints
NOT NULL, UNIQUE, CHECK, and foreign keys.
- 4
Joins
INNER, LEFT, and combining tables.
- 5
Indexes
B-tree, GIN, and choosing the right index.
- 6
Window Functions
Calculations across rows without collapsing them.
- 7
JSONB Columns
Storing and querying semi-structured data.
- 8
Transactions
ACID guarantees and isolation levels.
PostgreSQL is free to study, self-paced. Pass the final exam to earn an optional Certificate of Completion for $40.