GIS, Spatial Technologies & Development Planning · 10 Days
Spatial data is the backbone of planning, natural resource management, humanitarian response, utilities and land administration. Yet many organisations in Africa still rely on scattered shapefiles and spreadsheets that are difficult to share, validate and maintain. A well-designed geodatabase built on open-source technologies such as PostgreSQL, PostGIS and QGIS offers a robust, scalable and cost-effective alternative. This course takes participants from relational database fundamentals to advanced spatial administration. Delegates will design data models, load and clean data, write advanced spatial SQL, enforce data integrity with constraints, triggers and topology rules, manage multi-user editing and versioning, and tune performance for large datasets. QGIS is used throughout as the desktop client for visualisation, editing and quality control. The programme is highly practical. Each day combines short concept sessions with guided labs and a capstone project in which participants build a complete organisational geodatabase, document it, secure it and publish it to web services. By the end, delegates will be able to establish and administer a production-grade spatial data infrastructure for their institutions.
Participants should have working knowledge of GIS concepts and basic experience using QGIS or similar desktop GIS software. Familiarity with basic database concepts is helpful but not essential. Delegates should bring a laptop with administrative rights to install software.
Participants who complete the course will receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).
Participants should have working knowledge of GIS concepts and basic experience using QGIS or similar desktop GIS software. Familiarity with basic database concepts is helpful but not essential. Delegates should bring a laptop with administrative rights to install software.
Participants who complete the course will receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).
Yes. Ecotrio Impact Growth and Development Centre (EIGDC) offers a bespoke in-house delivery option for Advanced Geodatabase Management Using PostgreSQL and QGIS, tailored to your organisation's context within GIS, Spatial Technologies & Development Planning. Contact our training team to discuss customisation, scheduling and group pricing.
Yes. Selected cohorts of this course are available as live virtual sessions delivered over video conferencing by an experienced facilitator, with the same certificate issued on completion as the in-person format.
By the end of this course, you will be able to design normalised and spatially aware data models for organisational needs, install, configure and administer PostgreSQL with the PostGIS extension, connect QGIS to PostGIS and manage layers, styles and projects in the database, write advanced spatial SQL queries for analysis and data processing, import, clean, validate and migrate spatial data from multiple formats, apply constraints, triggers and topology rules to enforce data quality, manage users, roles, permissions and security for multi-user environments, optimise spatial queries and databases using indexes and performance tuning, implement backup, recovery, replication and versioning strategies, and publish spatial data through web services and automate workflows. The programme is designed to be immediately applicable to your day-to-day role.
| Location | Dates | Mode | |
|---|---|---|---|
| Dar es Salaam, Tanzania | 02 Nov 2026 – 11 Nov 2026 | Classroom | Register → |
| Accra, Ghana | 02 Nov 2026 – 11 Nov 2026 | Classroom | Register → |
| Cairo, Egypt | 02 Nov 2026 – 11 Nov 2026 | Classroom | Register → |
| Zanzibar, Tanzania | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Pretoria, South Africa | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Mombasa, Kenya | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Live Virtual | 09 Nov 2026 – 18 Nov 2026 | Online | Register → |
| Kampala, Uganda | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Nairobi, Kenya | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Johannesburg, South Africa | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Kigali, Rwanda | 23 Nov 2026 – 02 Dec 2026 | Classroom | Register → |
| Cape Town, South Africa | 23 Nov 2026 – 02 Dec 2026 | Classroom | Register → |
See full pricing, exact upcoming dates across Tanzania, Ghana, Egypt, and secure your seat online in minutes.
Book This Training →