Geospatial Data in PostGIS
Introduction to PostGIS

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.

  1. 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!