The PostgreSQL administration field guideField notes · Runbooks · Free certification

Practise · Real PostgreSQL

SQL lab

Use real SQL to complete a guided task in a temporary PostgreSQL database. Your lab is isolated from every other learner and is removed when you finish or when it expires.

Your goal

Correct a backup policy against stated RPO and RTO, then show evidence that the chosen artefact is usable.

What to do

  1. Start your temporary database.
  2. Read the task and run SQL in the workspace.
  3. Check your work. The server will inspect the database state.
  4. When every task passes, continue to the assessment.

Managed PostgreSQL workspace

Real SQL lab

The team says backups are enabled, but an audit asks what was protected and when the contents were last validated.

Your database is temporaryIt is private to this lab and deleted when you finish or it expires.

Goal

Create backup evidence for a critical table and prove the validation record includes scope, time, and a restorable row count.

Start when you are ready. Creating your private database can take a few seconds. You do not need a Neon account.