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: Strong PostgreSQL SQL skills; Understanding of schemas, indexes and transactions; Basic Linux command-line skills; Experience building or supporting a database application.

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 virtual machines or containers; Linux virtual machine; PostgreSQL current stable release; psql and pgAdmin 4 or DBeaver; Git; Shell scripting environment; Optional Docker.

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 UniversityPostgreSQL Database Administration, Security & Performance in Africa

Databases

University

PostgreSQL Database Administration, Security & Performance in Africa

Duration

4 weeks

Investment

UGX 450,000

Teaching

Live online

Enroll in this tutor-led course Get Help

Program Introduction

Gain the operational skills to install, secure, monitor, back up and tune PostgreSQL databases used by African enterprises and institutions. Learners practise production administration for banking, telecom, government, NGO, health, education, logistics and digital-service environments.

Key Features & Benefits

• Production DBA laboratories • Linux and PostgreSQL administration • Security hardening exercises • Backup and recovery drills • Performance troubleshooting • Operational runbook project

Real-World Applications

• Administer PostgreSQL for banks, fintechs and payment platforms • Secure public-sector and institutional databases • Protect NGO, health and education data • Monitor e-commerce and logistics systems • Recover services after data loss or operational failure • Tune high-traffic business databases • Prepare for PostgreSQL DBA, DevOps and database reliability roles in Africa

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 DBA AfricaDatabase Administration UgandaPostgres SecurityPostgreSQL Backup RecoveryPerformance TuningLinux Database AdministrationDatabase MonitoringPoint in Time RecoveryAutovacuumPostgreSQL Training East AfricaDevOps DatabaseEnterprise Database

Teaching format

Live online

Teaching language

English (Uganda)

Intended learners

University

What you will learn

Explain PostgreSQL server architecture and core processes
Install, configure and upgrade PostgreSQL on Linux
Manage roles, privileges and authentication securely
Implement backup, restore and point-in-time recovery procedures
Manage VACUUM, ANALYZE and autovacuum
Monitor activity, locks, waits and resource usage
Diagnose and tune slow queries and server settings
Apply partitioning and lifecycle strategies
Automate routine administration and health checks
Create operational runbooks and incident procedures

Modules

1
PostgreSQL server architecture and Linux deployment
Understand and operate a PostgreSQL server environment
Processes and memoryData directory structureLinux installationService managementConfiguration files
2
Configuration, storage and lifecycle management
Configure databases for dependable operations
Core server parametersTablespacesExtensionsVersion awarenessControlled upgrades
3
Roles, authentication and database security
Apply least privilege and secure access controls
Roles and membershipsGRANT and REVOKEpg_hba.confSSL conceptsAuditing and security baselines
4
Backup, restore and point-in-time recovery
Protect data and prove recoverability
Logical backupsPhysical backupsWAL archivingPoint-in-time recoveryRestore verification
5
Maintenance, vacuum and data health
Maintain performance and control table bloat
MVCC operationsVACUUM and ANALYZEAutovacuum tuningReindexingDatabase statistics
6
Monitoring and troubleshooting
Detect operational risks and resolve database incidents
pg_stat viewsSessions and locksWait eventsLogsDisk and connection issuesIncident triage
7
Performance tuning and workload optimisation
Tune queries, indexes and server resources systematically
Query plan reviewIndex diagnosticsMemory settingsConnection managementWorkload testing
8
Production operations project
Build a DBA runbook for an African organisation
Environment buildSecurity checklistBackup and recovery drillMonitoring planPerformance reviewIncident runbook