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: Ability to create PostgreSQL tables and databases; Comfort writing SELECT, INSERT, UPDATE and DELETE queries; Understanding of joins, grouping and basic constraints.

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 with Windows, Linux or macOS; PostgreSQL current stable release; pgAdmin 4, DBeaver or DataGrip; Visual Studio Code; Git; Optional Python, Java, PHP or Node.js development environment.

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 University · General PublicPostgreSQL Database Development & Query Optimisation for East Africa

Databases

University · General Public

PostgreSQL Database Development & Query Optimisation for East Africa

Duration

4 weeks

Investment

UGX 450,000

Teaching

Live online

Enroll in this tutor-led course Get Help

Program Introduction

Develop robust PostgreSQL databases and write efficient SQL for modern applications and analytics. The course uses realistic East African business, fintech, logistics, health, education and e-commerce scenarios to strengthen database design, query optimisation and application integration skills.

Key Features & Benefits

• Advanced SQL labs • East African application scenarios • Database modelling workshops • Query plan analysis • JSONB and API-ready data • Team-style capstone project

Real-World Applications

• Develop databases for fintech and mobile-payment applications • Build e-commerce inventory and order systems • Create logistics and delivery data platforms • Support NGO monitoring, evaluation and reporting • Design health and education information systems • Improve slow SQL queries in business applications • Prepare for PostgreSQL developer, data analyst and backend engineer roles

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 DevelopmentAdvanced SQL East AfricaQuery OptimisationQuery OptimizationDatabase DesignData ModellingPostgreSQL IndexingJSONBWindow FunctionsBackend DatabaseSQL Training UgandaPostgres Developer Africa

Teaching format

Live online

Teaching language

English (Uganda)

Intended learners

University · General Public

What you will learn

Design normalised and maintainable relational schemas
Write advanced joins, subqueries and common table expressions
Use window functions for analytics and reporting
Create reusable views, functions and triggers
Manage transactions and concurrency correctly
Choose and evaluate effective indexes
Interpret EXPLAIN and EXPLAIN ANALYZE output
Model semi-structured data with JSONB
Connect PostgreSQL securely to an application
Deliver an optimised database-backed capstone

Modules

1
Relational modelling and schema refinement
Turn business requirements into maintainable PostgreSQL designs
Entities and relationshipsNormalisationNaming conventionsSchemas and search paths
2
Advanced SQL query patterns
Solve complex reporting and application data problems
Advanced joinsSubqueriesCommon table expressionsSet operationsLATERAL queries
3
Analytical SQL with window functions
Produce rankings, trends and operational insights
OVER and PARTITION BYRanking functionsRunning totalsLead and lagReporting patterns
4
Views, functions and database-side logic
Create reusable and controlled data access layers
Views and materialized viewsSQL and PL/pgSQL functionsTriggersGenerated columns
5
Transactions and concurrent workloads
Protect consistency in multi-user applications
ACID principlesBEGIN COMMIT and ROLLBACKIsolation levelsLocksDeadlock awareness
6
Indexing and query plan analysis
Improve query performance using evidence-based tuning
B-tree and specialised indexesComposite and partial indexesEXPLAINEXPLAIN ANALYZEIndex trade-offs
7
JSONB and application integration
Support flexible data and modern software services
JSON and JSONBJSON operators and indexesParameterized queriesConnection basicsSecure application access
8
Optimised database application capstone
Deliver a production-minded East African database solution
Requirements and architectureSchema implementationAdvanced queriesPerformance testingDocumentation and demonstration