PostGIS from Scratch: Mastering PostGIS with QGIS
Master PostGIS fundamentals, spatial queries, database management, and QGIS integration for exploration and management.
PostGIS from Scratch: Mastering PostGIS with QGIS free download
Master PostGIS fundamentals, spatial queries, database management, and QGIS integration for exploration and management.
**DISCOUNT CODE**: Use the current month in uppercase followed by the year.
Examples: MAY2025, JUNE2025, JULY2025
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!
