How is this course delivered?

This is a tutor-led course delivered live online, taught in English (Uganda). Your tutor guides you through the curriculum live rather than leaving you to self-study pre-recorded videos.

Will I get a certificate?

This course does not currently include a certificate on completion.

What do I need to know before I start?

You should have: Production PostgreSQL administration experience; Strong knowledge of backup, recovery, security and performance tuning; Comfort with Linux, networking and shell scripting; Basic cloud or container knowledge.

How long does the course take, and what does it cost?

The course runs for 4 weeks and costs UGX 450,000. Paying for one programming course also unlocks 25% off your next one.

What do I need to have ready to join?

You'll need: Computer capable of running multiple Linux virtual machines or cloud instances; PostgreSQL current stable release; Git and shell scripting tools; Docker or equivalent container platform; pgBouncer; HAProxy or equivalent proxy; Prometheus and Grafana or equivalent monitoring tools; Access to a cloud sandbox where available.

Can I get help if I get stuck?

Yes. Enrolled students can book one-on-one tutor sessions any time through Get Help, in addition to regular class time.

Programming All learnersPostgreSQL High Availability, Cloud & Production Engineering for Africa

Databases

All learners

PostgreSQL High Availability, Cloud & Production Engineering for Africa

Duration

4 weeks

Investment

UGX 450,000

Teaching

Live online

Enroll in this tutor-led course Get Help

Program Introduction

Design and operate resilient PostgreSQL platforms for mission-critical African digital services. This professional programme covers high availability, replication, disaster recovery, cloud architecture, observability, security governance, migrations and production reliability engineering.

Key Features & Benefits

• High-availability architecture labs • Replication and failover exercises • Cloud deployment patterns • Disaster recovery simulations • Observability and SRE practices • Professional architecture capstone

Real-World Applications

• Design resilient databases for fintech and digital banking • Support telecom and high-volume transaction platforms • Engineer reliable government and national-scale services • Modernise legacy databases for cloud deployment • Plan disaster recovery for regional organisations • Operate multi-tenant SaaS and e-commerce platforms • Lead PostgreSQL architecture, platform engineering and database reliability teams

Course outline and learning expectations

This is a tutor-led course. The outline shows what your tutor will cover; teaching materials and examinations are provided directly to enrolled students.

PostgreSQL High Availability AfricaPostgres ReplicationCloud PostgreSQLDatabase Reliability EngineeringDisaster RecoveryStreaming ReplicationLogical ReplicationPostgreSQL FailoverpgBouncerDatabase ObservabilityPostgreSQL MigrationPlatform Engineering Africa

Teaching format

Live online

Teaching language

English (Uganda)

Intended learners

All learners

What you will learn

Design PostgreSQL architectures against availability and recovery objectives
Implement and troubleshoot physical streaming replication
Use logical replication for selective data movement and upgrades
Plan automated failover, connection routing and pooling
Engineer tested disaster recovery strategies
Evaluate managed cloud, virtual machine and container deployment models
Implement metrics, logs, alerts and service-level indicators
Plan low-risk PostgreSQL migrations and major upgrades
Apply capacity, security and cost governance
Defend a production PostgreSQL platform architecture

Modules

1
Reliability architecture and production requirements
Translate business risk into PostgreSQL platform design
Availability targetsRecovery objectivesFailure domainsArchitecture trade-offsCapacity assumptions
2
Physical streaming replication
Build and validate resilient standby systems
WAL and replication conceptsReplication slotsStandby creationSynchronous and asynchronous replicationLag troubleshooting
3
Logical replication and data movement
Use selective replication for integration and controlled change
Publications and subscriptionsReplication identityConflict considerationsSelective replicationUpgrade and migration patterns
4
Failover, routing and connection management
Maintain service access during failures and traffic growth
Failover orchestration conceptsHealth checksHAProxy patternspgBouncer poolingApplication reconnection strategy
5
Disaster recovery and resilience testing
Design recovery systems that work under pressure
Backup architectureCross-site recoveryRestore automationDisaster recovery drillsRunbooks and communications
6
Cloud and container deployment patterns
Evaluate secure and scalable PostgreSQL operating models
Managed versus self-managed PostgreSQLCompute storage and networkingContainers and orchestration conceptsCost and vendor risk
7
Observability, SRE and production governance
Operate PostgreSQL through measurable reliability practices
Metrics logs and tracesService-level indicatorsAlert designCapacity planningSecurity and change governance
8
Professional PostgreSQL architecture capstone
Design and defend a mission-critical African data platform
Business and technical requirementsHA and DR designMigration planObservability modelCost and risk reviewArchitecture presentation