Your cart is empty.
Keep shoppingPostGIS from Scratch: Mastering PostGIS with QGIS
216 students
PostGIS from Scratch: Mastering PostGIS with QGIS
Master PostGIS fundamentals, spatial queries, database management, and QGIS integration for exploration and management.
Created byIkrom Nishanbaev
Last updated 8/2025
English
What you'll learn
- SEE DESCRIPTION FOR DISCOUNT CODE
- All the key Concepts of PostGIS
- Introduction to PostgreSQL, PostGIS and pgAdmin
- QGIS integration for exploration and database management
- Uploading shapefiles and CSV into the PostGIS database
- Spatial and non-spatial queries and geometry types
- Coordinate Reference System Functions
- Filtering, limiting and sorting data
- Data Types including Vector Geometry and Raster
- Managing Database Tables and Primary and Foreign Keys
- Database Relationships including one-to-one, one-to-many and many-to-many
- Spatial Insert, Update and Delete records
- Spatial Indexing and Vacuum and Analyze
- Spatial Joins and Spatial Relationship Queries
- PL/pgSQL basics
- Pl/pgSQL control structures, functions and procedures
- And much more!
Explore related topics
Course content
14 sections • 89 lectures • 6h 28m total length
Requirements
- Interest in Spatial Data: This course is ideal for anyone interested in working with spatial data and learning how to manage, query, and analyze geospatial information in a PostGIS database.
- No Previous Experience with PostGIS: This course is designed for beginners, so you don't need prior experience with PostGIS. We’ll cover everything from the ground up.
Description
**DISCOUNT CODE**: Use the current month in uppercase followed by the year.
Examples: JUNE2026, JULY2026, AUGUST2026
PostGIS is a powerful spatial database extension for PostgreSQL, enabling advanced spatial data storage, analysis, and manipulation.
This course focuses on the latest capabilities of PostGIS (updated for 2024) and is one of the most comprehensive PostGIS courses available on UDEMY. Starting from the very basics, you’ll progress through advanced spatial queries, data optimization techniques, and practical use cases. Along the way, QGIS is introduced as a tool to visualize and explore spatial query results, enhancing your understanding of the database concepts.
No prior experience with spatial databases is required, as we start from scratch and cover all the essential concepts.
By the end of this course, you’ll have the skills and confidence to handle spatial data efficiently and leverage PostGIS for diverse applications.
More details about what the course covers
Introduction to PostGIS
PostgreSQL and PostGIS installation
Introduction to pgAdmin
QGIS installation including connecting QGIS into the PostGIS database
Uploading shapefiles and CSV into the PostGIS database
Handling large datasets in QGIS
Introduction to Spatial and non-spatial queries and geometry type
Coordinate Reference System Functions
Filtering, limiting and sorting data
Data Types including Vector Geometry and Raster
Managing Database Tables and Primary and Foreign Keys
Database Relationships including one-to-one, one-to-many and many-to-many
Spatial Insert, Update and Delete records
Spatial Indexing and Vacuum and Analyze
Spatial Joins and Spatial Relationship Queries
PL/pgSQL basics
Pl/pgSQL control structures, functions and procedures
And much more!
Who this course is for:
- Beginners to Intermediate Users: If you're new to PostGIS and spatial databases or want to enhance your understanding of spatial queries, this course will guide you through the fundamentals and take you to an intermediate level of mastery.
- GIS Enthusiasts: Whether you're a GIS analyst, cartographer, or geospatial professional, this course will help you strengthen your spatial database skills and deepen your knowledge of working with geographic data.
- QGIS Users: While QGIS is not the focus of this course, if you're already using QGIS and want to integrate PostGIS with it to enhance your spatial analysis and data management, this course will show you how to do that effectively.
- Database Administrators and Developers: If you're a database administrator or developer looking to add spatial capabilities to your PostgreSQL database, this course will teach you how to manage and query spatial data with PostGIS.
- Anyone Interested in Geospatial Data Management: If you're interested in learning how to manage, store, and query spatial data efficiently, this course will provide you with the practical skills to handle PostGIS databases.