This course introduces PostGIS, the spatial extension for PostgreSQL, and teaches you how to store, manage, and analyze geographic data using spatial SQL. You will learn to build and query spatial databases, work with vector and raster data, and integrate PostGIS with tools like QGIS and GeoServer. By the end, you will have practical skills to develop and support real-world desktop, server, and web-based GIS applications.
English
Last updated
Mon, 02-Feb-2026
PostGIS is a powerful spatial extension for
PostgreSQL that enables you to store, analyze, and manipulate geographic and
geometric data with precision and efficiency. This course provides a complete
learning journey through PostGIS, covering both foundational concepts and
advanced spatial operations.
You will begin by learning how to install, configure, and manage PostgreSQL and
PostGIS using both graphical and command-line tools. As the course progresses,
you will design spatial databases, manage vector and raster data, work with
coordinate reference systems, and write efficient spatial SQL queries.
The course also introduces QGIS and GeoServer as companion tools for
visualizing spatial data, publishing services, and validating query results. To
ensure real-world relevance, learners will build a hands-on Web GIS application
using a web mapping library connected directly to PostGIS, demonstrating how
modern spatial applications are built.
By the end of the course, you will have the confidence and practical skills
required to manage, analyze, and serve spatial data for desktop, server, and
web-based GIS projects.
