Training Trains logo

PostgreSQL DBA Internship Roadmap: What to Learn Before You Apply

By K. Boopathikumar, CEO & Founder · 16 November 2026 · 6 min read

This PostgreSQL DBA roadmap takes you from the basics to internship-ready in about four months of steady practice. Finish each stage's project before moving on; the projects are what interviewers ask about.

Stage 1: SQL (3 weeks)

  • Queries.
  • Joins.
  • Transactions.
  • Build: a sample database with queries.

Stage 2: Internals (3 weeks)

  • MVCC and VACUUM.
  • WAL.
  • Configuration.
  • Build: notes with experiments.

Stage 3: Tuning (3 weeks)

  • EXPLAIN.
  • Indexes.
  • pg_stat_statements.
  • Build: an index tuning report.

Stage 4: Recovery and HA (3 weeks)

  • Backups and PITR.
  • Replication.
  • Roles and access.
  • Build: a tested restore and a replica.

You are ready to apply when you can

  • Explain MVCC.
  • Read an EXPLAIN plan.
  • Restore to a point in time.
  • Set up a replica.

Next steps

Looking for an internship near Erode?

10 days to 6 months, online or at our Erode and Perundurai branches, with a verifiable certificate.

See internships →

More guides