PostgreSQL
A complete 37-lesson PostgreSQL 18.6 course from SQL, schema design, and transactions through indexes, MVCC, security, performance, backup, monitoring, and a production Tutorial Platform capstone.
37 Lessons · 740 min · Learning Platform Editorial Team
Getting Started — PostgreSQL 18 Course Roadmap
What you need on the desk
- PostgreSQL 18.6 or a PostgreSQL 18 Docker image
- psql command-line client
- Docker Desktop or a native PostgreSQL installation
- A code editor and Node.js 20+ for the API project
Know this much before you start
- Basic computer and terminal use
- No prior database experience is required
- Docker is recommended for the consistent local setup
By the end, you can
- Design normalized relational schemas with constraints and safe migrations
- Write SQL from CRUD and joins through CTEs, windows, JSONB, and full-text search
- Use transactions, MVCC, locks, roles, privileges, and row-level security correctly
- Diagnose and improve queries with EXPLAIN ANALYZE and workload-specific indexes
- Integrate PostgreSQL safely with a pooled, parameterized Node.js API
- Operate a production database with vacuuming, monitoring, tested backups, and recovery objectives