PostgreSQL Administration Training Outline

• PostgreSQL Introduction & Architecture
• PostgreSQL Installation
• The PostgreSQL Cluster
• Creating Databases and Users
• Security – Host-Based Authentication
• PostgreSQL Configuration
• Introduction to PSQL
• PostgreSQL Database Objects
• Copying and Importing Data with PostgreSQL
• pgAdmin
• PostgreSQL Encryption
• PostgreSQL Backup and Recovery
• PostgreSQL Streaming Replication
• PostgreSQL Internals – System Catalogs and Cluster Settings
• Logging and Monitoring Tools
• Upgrading PostgreSQL
• Logical Replication
• Continuous Archiving and Point In Time Recovery (PITR)

Each student receives:

• PDF course notes
• One-on-one lab assistance
• Cloud hosted virtual lab machines for practice sessions

Prerequisites: Basic SQL, Linux, and bash shell competency