Level 3 · Advanced
Databases
PostgreSQL Specialist - PostgreSQL Engineer
Specialist-level PostgreSQL certification covering query optimization and execution plans, MVCC and transaction behavior, vacuum and autovacuum tuning, locking and concurrency control, advanced indexing strategies, partitioning, JSONB performance, replication and failover, backup and point-in-time recovery, PL/pgSQL, and production performance monitoring and troubleshooting.
Skills Tested
- Query Optimization & Execution Plans
- MVCC & Transaction Isolation
- Locking & Concurrency Control
- VACUUM, Autovacuum & Freeze Management
- Advanced Indexing
- Partitioning
- JSONB Querying & Indexing
- Replication & Failover
- Backup & Point-in-Time Recovery
- Performance Monitoring & Observability
- PL/pgSQL & Functions
Assessment Details
25
Questions
78%
To Pass
55 min
Time Limit
—
Pass Rate
- Questions are drawn randomly from the question pool each attempt
- Answers cannot be reviewed after submission
- Escalating cooldown between attempts: 8h, 24h, 72h, then 1 week
- Certificates include a shareable verification token
- Open Badges 2.0 compliant. Add to LinkedIn and digital wallets
Track
Databases → PostgreSQL
Part of Career Paths
PostgreSQL Database Administrator
Available in Bundles
PostgreSQL DBA Bundle
Save 25%