Skip to content
Hands-on IT IT Drills

Course

PostgreSQL hands-on

Running the database – from a server to CloudNativePG on Kubernetes

Tick off what you've done and continue on any device. Sign up for free

  1. Welcome to the Drills
  2. Day 0: Training Ground approx. 60 min
  3. Day 1: psql Craft approx. 75 min
  4. Day 2: Databases, Schemas, Roles and Privileges approx. 90 min
  5. Day 3: Configuration and Access approx. 75 min
  6. Day 4: Transactions, MVCC and Locks approx. 90 min
  7. Day 5: Indexes and EXPLAIN approx. 90 min
  8. Day 6: VACUUM, Autovacuum and Bloat approx. 75 min
  9. Day 7: Monitoring and Logs approx. 70 min
  10. Day 8: Logical Backups approx. 60 min
  11. Day 9: Physical Backups and PITR approx. 120 min
  12. Day 10: Streaming Replication approx. 120 min
  13. Day 11: Logical Replication approx. 90 min
  14. Day 12: Connection Pooling with PgBouncer approx. 60 min
  15. Day 13: Major Upgrade approx. 90 min
  16. Day 14: Installing CloudNativePG and Your First Cluster approx. 90 min
  17. Day 15: CNPG: Backups and Recovery approx. 75 min
  18. Day 16: CNPG: High Availability approx. 90 min
  19. Day 17: CNPG: Operations approx. 85 min
  20. Day 18: Connecting the Application approx. 80 min
  21. Day 19: Competition – Repairing Broken Databases approx. 120 min
  22. Appendix A: Cheat Sheet
  23. Appendix B: Final Exam 120 min