Spatial SQL with PostGIS
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
- Day 1PostgreSQL and PostGIS setup
- Day 2Geometry types and spatial functions
- Day 3Spatial joins, indexes and performance
- Day 4Raster, topology and integration with QGIS
- Day 5Database project and assessment
Upcoming dates
| Date | Location | Fee | |
|---|---|---|---|
| 14 Feb – 18 Feb 2027 | Doha | US$ 5,500 | Book |
| 17 May – 21 May 2027 | Live online | US$ 3,000 | Book |
| 2 Aug – 6 Aug 2027 | Lagos | US$ 5,500 | Book |
| 8 Nov – 12 Nov 2027 | Dar es Salaam | US$ 5,500 | Book |
| 21 Feb – 25 Feb 2028 | Live online | US$ 3,000 | Book |
| 7 May – 11 May 2028 | Jeddah | US$ 5,500 | Book |
| 13 Aug – 17 Aug 2028 | Manama | US$ 5,500 | Book |
| 20 Nov – 24 Nov 2028 | Live online | US$ 3,000 | Book |
| 5 Feb – 9 Feb 2029 | Johannesburg | US$ 5,500 | Book |
| 14 May – 18 May 2029 | Barcelona | US$ 5,500 | Book |
| 20 Aug – 24 Aug 2029 | Live online | US$ 3,000 | Book |
| 4 Nov – 8 Nov 2029 | Al Khobar | US$ 5,500 | Book |
| A date you choose | In-house | Based on group size | Request a quote |
Certificate
ITQAN Global Academy certificate of completion for participants who meet attendance and pass the assessment.