
Training Item Code: POSTGIS101
Dive into the world of spatial databases with Geospatial Data & Design with PostGIS, a hands‑on, two‑day instructor‑led course that transforms PostgreSQL into a powerful geospatial engine. You’ll learn to store, query, analyse and visualise spatial data—all from a single, shared database—fueling everything from web maps to enterprise GIS.
Format & Duration
Delivery: Online, instructor‑led.
- On-site Training is available on request (must be 7+ people)
Length: 2 full days
Requirements: Personal laptop with two screens
Key Learning Outcomes
PostGIS & PostgreSQL Setup
Install and configure a geospatial RDBMS ready for production.
Spatial Data Manipulation
Insert geometries, run spatial queries, and leverage PostGIS functions and operators.
SQL Fundamentals
Build CRUD queries, understand tables, fields, and primary/foreign keys—no prior database experience needed.
QGIS Integration
Use QGIS as both a visualisation tool and SQL client (via DB Manager) to import/export data and display results.
Enterprise GIS Workflows
Explore how PostGIS serves as the backbone of a FOSS‑based GIS stack in mixed IT environments.
Practical Application
Bring your own datasets for real‑time exercises and continue practising on your setup after the course.
Assessment & Certification
Interactive exercises throughout each module
Certificate of attendance upon successful completion
Pricing
All‑inclusive fee covering VAT, software, course materials, datasets, and certificate
Equip yourself with the skills to design, manage, and analyze spatial data at scale—join Geospatial Data & Design with PostGIS and elevate your GIS capabilities!