PostgreSQL Training

A complete 3-course learning path to master PostgreSQL, from installation to production optimization.

Beginner

PostgreSQL: Getting Started & Administration

🕑 8-10 hours

  • Installation and initial setup
  • Getting started with psql & pgAdmin
  • Roles, privileges and authentication
  • Essential configuration parameters
  • Logical backups (pg_dump / pg_restore)
  • Monitoring and system views
  • Minor and major version upgrades
View on Udemy →
Advanced

PostgreSQL: Advanced Administration & High Availability

🕑 6-8 hours

  • Internal architecture (processes, memory, WAL)
  • MVCC, isolation levels and locking
  • VACUUM, autovacuum and pg_repack
  • OS tuning and advanced configuration
  • Declarative partitioning
  • Physical backups, PITR & pgBackRest
  • Physical and logical replication
View on Udemy →
Expert

PostgreSQL: Performance & Optimization

🕑 6-8 hours

  • Diagnostic methodology
  • Execution plans (EXPLAIN ANALYZE)
  • Statistics and planner impact
  • Indexing: B-tree, GIN, GiST, BRIN
  • Full-text search, JSONB, PostGIS, pg_trgm
  • pg_stat_statements and auto_explain
  • PoWA and advanced analysis tools
View on Udemy →

A progressive learning path

Each course builds on the knowledge from the previous one to develop solid expertise.

🌱
Fundamentals

Course 1

→
🌳
Mastery

Course 2

→
🚀
Expertise

Course 3

Need custom training?

We also offer private training sessions tailored to your specific context and challenges.

Contact us