PostGIS from Scratch: Mastering PostGIS with QGIS

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: MARCH2026, APRIL2026, MAY2026

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!