Skip to main content
Level 2 · Intermediate Databases

PostgreSQL Professional PostgreSQL Professional

Verify intermediate PostgreSQL proficiency used in real-world database development and operations, including advanced queries, window functions, CTEs, JSONB, indexing strategies, transactions, query analysis, partitioning, stored functions, triggers, roles and permissions, backup and recovery, extensions, schemas, and VACUUM/maintenance.

Skills Tested
  • Advanced Queries
  • Window Functions
  • CTEs
  • JSONB & Semi-Structured Data
  • Indexing Strategies
  • Transactions & Concurrency
  • Query Analysis & EXPLAIN
  • Partitioning
  • Stored Functions
  • Triggers
  • Roles & Permissions
  • Schemas
  • Backup & Recovery
  • Extensions
  • VACUUM & Maintenance
  • pg_stat_statements
Assessment Details
25
Questions
78%
To Pass
50 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