Included in Pro Max
Learn PostgreSQL on your iPhone
Learn PostgreSQL with 30 short lessons and 150 exercises. Each lesson explains the idea, shows you an example and gets you practicing, with an AI tutor that gives hints when you get stuck.
- lessons
- 30
- exercises
- 150
- Beginner
- 10
- Intermediate
- 10
- Advanced
- 10
What is PostgreSQL used for?
PostgreSQL is one of the most powerful and widely used open-source relational databases. Master indexes, transactions, JSON and advanced queries for professional backend work.
How the course starts
- 01
Intro to PostgreSQL
What PostgreSQL is, how to install it, and the first psql CLI commands.
- 02
Databases and Tables
CREATE DATABASE, CREATE TABLE, and basic types such as INTEGER, VARCHAR, BOOLEAN, and TEXT.
- 03
Inserting Data
INSERT INTO, default values, RETURNING, and multiple rows in a single statement.
- 04
Basic Queries
SELECT, WHERE, ORDER BY, LIMIT, and OFFSET to read and sort rows.
- 05
Update and Delete
Modify rows with UPDATE, remove them with DELETE, and clear tables with TRUNCATE.
-
+25 more lessons in the app
The full syllabus, the explanations and the practice are in the app.
PostgreSQL course syllabus
Beginner 10 lessons
- Intro to PostgreSQL
- Databases and Tables
- Inserting Data
- Basic Queries
- Update and Delete
- Numeric Types
- Text and Dates
- Special Types
- Constraints
- ALTER TABLE
Intermediate 10 lessons
- INNER JOIN
- LEFT and RIGHT JOIN
- Subqueries
- Aggregation
- UNION and Set Operations
- Built-in Functions
- Date Functions
- CASE and Conditionals
- Window Functions
- Creating Functions
Advanced 10 lessons
- Basic Indexes
- Index Types
- EXPLAIN and Analysis
- Query Optimization
- Transactions and MVCC
- Roles and Permissions
- Backup and Restore
- Views and Materialized Views
- Triggers and Events
- Production and Monitoring
A question from the course
Databases and Tables
Complete the statement to create the `store` database:
CREATE DATABASE ___; The answer, the explanation and many more exercises are waiting for you in the app.
DownloadQuestions about the course
Is the PostgreSQL course free?
PostgreSQL is part of Pro Max. The app is free and you can start with the free courses before subscribing.
Do I need experience to learn PostgreSQL?
No. The course starts at beginner level (10 lessons) and moves on to intermediate and advanced at your pace.
How long is the PostgreSQL course?
It has 30 lessons and 150 exercises. Lessons are short, so you can move forward a few minutes a day; adaptive learning brings back what you are about to forget.