Introduction to Databases for GIS (PostgreSQL & PostGIS)

This course introduces database fundamentals for GIS users, with a focus on PostgreSQL and spatial databases using PostGIS. Participants will learn how relational databases work, how to write SQL queries, and how spatial data is stored and analyzed inside databases.

The course covers SQL basics, table management, spatial data types, coordinate reference systems, and spatial queries for analysis and validation. By the end of the course, learners will be able to manage GIS data in databases and perform spatial analysis using SQL.

You will learn to:

• Understand relational databases and PostgreSQL

• Write basic SQL queries for GIS data

• Work with spatial databases using PostGIS

• Import GIS data into databases

• Perform spatial queries and analysis with SQL

Level: Intermediate – basic GIS knowledge recommended