Skip to main content
Back

PostgreSQL

Silver exam

Sixteen questions across the whole track: types, indexes and query plans, transactions and locks, window functions and search, and running Postgres. Expect to read real SQL, predict what it does and spot the usual mistakes.

  • 16 questions
  • 20 minutes
  • Pass mark 80%
  • At least 6 hands-on tasks
Covers psql and sessionsTypes and jsonbIndexes and EXPLAINTransactions and MVCCLocks and UPSERTWindows, recursion, searchRunning Postgres

The clock cannot be paused, and leaving counts as an attempt.