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