ITQANGlobal Academy for Training

Spatial SQL with PostGIS

Code: GS-112Level: AdvancedDuration: 5 days

Course overview

Spatial SQL with PostGIS is a advanced-level ITQAN course focused on storing and analysing spatial data in PostgreSQL/PostGIS. The course covers PostGIS setup, geometry and geography types, spatial indexes, spatial joins, topology functions, raster support and performance tuning, through practical explanation, hands-on exercises and case studies from projects in the GCC and Africa, and ends with an applied project and final assessment.

What you will learn

  • Understand PostgreSQL and PostGIS setup
  • Apply geometry types and spatial functions
  • Use spatial joins, indexes and performance
  • Work confidently with raster, topology and integration with QGIS
  • Complete an applied Spatial SQL with PostGIS project using data or a case from your own work

Who should attend

GIS analysts, surveyors, planners, engineers and data professionals who work with location data

Daily outline

  1. Day 1
    PostgreSQL and PostGIS setup
  2. Day 2
    Geometry types and spatial functions
  3. Day 3
    Spatial joins, indexes and performance
  4. Day 4
    Raster, topology and integration with QGIS
  5. Day 5
    Database project and assessment

Upcoming dates

DateLocationFee
14 Feb – 18 Feb 2027DohaUS$ 5,500Book
17 May – 21 May 2027Live onlineUS$ 3,000Book
2 Aug – 6 Aug 2027LagosUS$ 5,500Book
8 Nov – 12 Nov 2027Dar es SalaamUS$ 5,500Book
21 Feb – 25 Feb 2028Live onlineUS$ 3,000Book
7 May – 11 May 2028JeddahUS$ 5,500Book
13 Aug – 17 Aug 2028ManamaUS$ 5,500Book
20 Nov – 24 Nov 2028Live onlineUS$ 3,000Book
5 Feb – 9 Feb 2029JohannesburgUS$ 5,500Book
14 May – 18 May 2029BarcelonaUS$ 5,500Book
20 Aug – 24 Aug 2029Live onlineUS$ 3,000Book
4 Nov – 8 Nov 2029Al KhobarUS$ 5,500Book
A date you chooseIn-houseBased on group sizeRequest a quote

Certificate

ITQAN Global Academy certificate of completion for participants who meet attendance and pass the assessment.

WhatsApp