Administering PostgreSQL database server

The training is addressed to administrators, who haves just started working with PostgreSQL databases, and administrators who would like to consolidate their knowledge.

The participants will gain knowledge about architecture, configuration, functionalities and operations of PostgreSQL database server.

The training covers such topics as: software deployment, security configuration, database backup and recovery, database replication, query performance management foundations, server operation monitoring and diagnostics.

General knowledge of IT topics and relational databases concepts (including SQL), as well as good computer skills.

• Training: English
• Materials: English

• 3 days of work with a trainer
• Trainer’s supervision
• Contact with community
• Coursebook
• Lab environment

Training method

• lecture
• workshops

• PostgreSQL 16 database server architecture and configuration
• Database server management (installation, upgrade, initialisation, starting, stopping)
• Physical and logical server structures (databases, tablespaces, schemas)
• Vacuum, Analyze, Reindex operations
• Security management (roles, privileges)
• Database server monitoring (logs, Cumulative Statistics, auditing)
• Protecting databases from failures (logical and physical backups, Disaster Recovery)
• Database replication mechanisms (standard physical and logical replication)
• Overview of query optimisation topics and performance management (Query Planner, statistics, configuration, execution plans)