Explore Kartoza

Try searching for: QGIS, Training, GeoNode, PostGIS

PostGIS PostgreSQL SQL

Introduction to PostGIS

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.

2 Days
On-site or Remote
Certificate Included
View Dates & Book Learn More
Introduction to PostGIS
Expert Instructors
Hands-on Learning
Course Materials
Post-Course Support

Course Overview

This comprehensive course introduces participants to spatial database concepts and practices using PostgreSQL and PostGIS, the industry-leading open source spatial database solution. Participants will learn how to design efficient spatial database schemas, import and export spatial data, write complex spatial SQL queries, perform advanced spatial analysis, and optimise database performance.

The course combines theoretical concepts with extensive hands-on practice, ensuring participants can immediately apply their knowledge to real-world scenarios.

What You Will Learn

  • General database concepts, including what is a relational database?
  • SQL basics including syntax, structure, standards and conventions
  • Connecting to a database
  • Building queries including Commands, functions, operators, etc
  • Resources - documentation and tutorials

Who Should Attend

This course is ideal for:

  • GIS professionals moving to database-driven workflows
  • Database administrators managing spatial data
  • Developers building spatial applications
  • IT staff responsible for GIS infrastructure
  • Analysts working with large spatial datasets

Participants should have basic knowledge of SQL and relational databases.

Prerequisites

  • Basic SQL knowledge
  • Familiarity with GIS concepts
  • Experience with spatial data formats
  • Interest in data management

Course Materials

All participants receive:

  • Comprehensive PostGIS reference guide
  • SQL cheat sheets and query templates
  • Sample databases for exercises
  • Performance tuning checklist
  • Certificate of completion
  • 30-day post-course email support

Choose Your Training Session

Select a date, venue, and number of attendees below. We offer flexible options to suit your needs.

No Scheduled Sessions Yet

We don't have any public sessions scheduled for this course at the moment, but we can arrange custom training for your team.

Request Custom Training

Why Train With Kartoza?

Join thousands of professionals who have advanced their careers with our training

Industry Experts

Learn from practitioners who contribute to open source projects and work with organiations worldwide.

Practical Focus

Our courses emphasize hands-on exercises and real-world scenarios you can apply immediately.

Customized Training

We tailor content to your team's specific needs, data, and workflows for maximum relevance.

Open Source Leaders

As major contributors to QGIS, PostGIS, and other projects, we teach from deep expertise.

"Kartoza's training transformed how our team approaches GIS. The hands-on approach and expert guidance gave us skills we use every day."
Training Participant GIS Professional