Spatial Database Management and Advanced Geographic Information Systems Training Course

GIS, Spatial Technologies & Development Planning · 10 Days

Course Overview

Spatial data now underpins decision-making in government, utilities, humanitarian response, natural resource management, agriculture and urban planning across Africa. Yet many organisations still manage their geographic data in scattered files, with inconsistent standards, weak quality control and limited ability to share or scale. This course addresses that gap by moving delegates from desktop GIS use to professional spatial database management and advanced analysis. Over ten days, participants learn relational and spatial database concepts, data modelling, SQL and spatial SQL, geodatabase design, topology and data integrity, multi-user editing, and performance tuning. They then apply these foundations in advanced vector and raster analysis, network and spatial statistics, automation with Python, and the publication of maps and services through web GIS platforms and open standards. The programme is highly practical, using open-source tools such as PostgreSQL, PostGIS, QGIS and GeoServer alongside ArcGIS concepts, and real-world African datasets. Delegates finish with a working enterprise-style spatial database and a clear implementation roadmap they can apply in their own institutions.

Who Should Attend

  • GIS analysts and officers seeking to advance to database and enterprise GIS roles
  • Geospatial data managers and database administrators
  • Surveyors, cartographers and remote sensing specialists
  • Urban, regional and physical planners
  • Monitoring and evaluation officers working with geo-referenced data
  • Government mapping, land administration and statistics agency staff
  • Environmental, agriculture and natural resource management professionals
  • Researchers and academics using spatial data
  • Humanitarian and development programme information management staff

Learning Objectives

  • Design and implement relational and spatial database models for organisational needs
  • Write SQL and spatial SQL queries to manage, query and analyse geographic data in PostGIS
  • Create and manage geodatabases with domains, subtypes, relationships and topology rules
  • Apply data quality control, validation and metadata standards to spatial datasets
  • Set up multi-user editing, versioning, security and backup strategies
  • Perform advanced vector, raster, network and spatial statistical analysis
  • Automate geoprocessing and data workflows using Python and scripting
  • Publish spatial data as web maps and OGC-compliant services
  • Develop an implementation plan for an enterprise spatial data infrastructure

Key Takeaways

Course Curriculum

1

Foundations of Spatial Data and Enterprise GIS

2

Relational Database Concepts and Data Modelling

3

SQL Fundamentals for GIS Professionals

4

Introduction to PostgreSQL and PostGIS

5

Spatial SQL and Spatial Queries

6

Geodatabase Design and Data Integrity

7

Multi-User Editing, Security and Database Management

8

Metadata, Standards and Data Governance

9

Advanced Vector Analysis and Spatial Statistics

10

Advanced Raster, Terrain and Remote Sensing Analysis

11

Network Analysis and Location Intelligence

12

Automation with Python and Geoprocessing Workflows

13

Web GIS, Services Publishing and Capstone Implementation

Requirements

Participants should have a working knowledge of GIS concepts and experience using desktop GIS software such as QGIS or ArcGIS. Basic familiarity with databases or spreadsheets is helpful but not essential. Delegates should bring a laptop capable of running the course software, which will be set up with guidance.

Certification

Participants who complete the course will receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).

Frequently Asked Questions

What background knowledge is expected before attending?

Participants should have a working knowledge of GIS concepts and experience using desktop GIS software such as QGIS or ArcGIS. Basic familiarity with databases or spreadsheets is helpful but not essential. Delegates should bring a laptop capable of running the course software, which will be set up with guidance.

Is a certificate issued upon completion?

Participants who complete the course will receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).

Can this training be delivered on-site for our organisation?

Yes. Ecotrio Impact Growth and Development Centre (EIGDC) offers a bespoke in-house delivery option for Spatial Database Management and Advanced Geographic Information Systems, tailored to your organisation's context within GIS, Spatial Technologies & Development Planning. Contact our training team to discuss customisation, scheduling and group pricing.

Can I attend this course virtually instead of in person?

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.

What are the key learning outcomes of this course?

By the end of this course, you will be able to design and implement relational and spatial database models for organisational needs, write SQL and spatial SQL queries to manage, query and analyse geographic data in PostGIS, create and manage geodatabases with domains, subtypes, relationships and topology rules, apply data quality control, validation and metadata standards to spatial datasets, set up multi-user editing, versioning, security and backup strategies, perform advanced vector, raster, network and spatial statistical analysis, automate geoprocessing and data workflows using Python and scripting, publish spatial data as web maps and OGC-compliant services, and develop an implementation plan for an enterprise spatial data infrastructure. The programme is designed to be immediately applicable to your day-to-day role.

Upcoming Sessions

LocationDatesMode
Pretoria, South Africa 02 Nov 2026 – 11 Nov 2026 Classroom Register →
Zanzibar, Tanzania 02 Nov 2026 – 11 Nov 2026 Classroom Register →
Live Virtual 02 Nov 2026 – 11 Nov 2026 Online Register →
Mombasa, Kenya 02 Nov 2026 – 11 Nov 2026 Classroom Register →
Johannesburg, South Africa 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Nairobi, Kenya 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Kampala, Uganda 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Kigali, Rwanda 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Dubai, United Arab Emirates 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Cape Town, South Africa 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Cairo, Egypt 23 Nov 2026 – 02 Dec 2026 Classroom Register →
Accra, Ghana 23 Nov 2026 – 02 Dec 2026 Classroom Register →

Ready to Register for Spatial Database Management and Advanced Geographic Information Systems Training Course?

See full pricing, exact upcoming dates across South Africa, Tanzania, Kenya, and secure your seat online in minutes.

Book This Training →