← Back to courses
Data Science and AI
PostgreSQL Database Administration
Install, secure, back up, replicate and monitor a server
A lab-based classroom course in running PostgreSQL in production. The modules follow Part III of the PostgreSQL 18 documentation, "Server Administration": server setup and configuration, client authentication, roles, routine maintenance, backup and restore, high availability and replication, monitoring, and the write-ahead log. This course prepares for no exam.
10Modules
IntermediateLevel
2 monthsDuration
COURSE THUMBNAIL
What you will be able to do
Install and configure a PostgreSQL server
Control who can connect and what each role can do
Keep a database healthy with routine maintenance
Back up a database and prove the backup restores
Set up replication to a standby server
Monitor activity and find the cause of a slowdown
Course outline
01
Installation, server setup and operation
02
Server configuration
03
Client authentication
04
Database roles and managing databases
05
Routine database maintenance tasks
06
Backup and restore
07
Reliability and the write-ahead log
08
High availability, load balancing and replication
09
Logical replication
10
Monitoring database activity
Tools you will use
PostgreSQLpsqlpg_dumppg_basebackupLinux
What you need
Working knowledge of SQL (SQL with PostgreSQL or equivalent)
Basic Linux command-line skills
