Build dependable spatial database skills with PostgreSQL, PostGIS, SQL, geometry operations, indexing and QGIS database workflows.
Design, query and manage spatial databases with PostgreSQL, PostGIS and QGIS. This 21-lesson Course begins with installation and data transfer, then develops the SQL and geometry skills needed for real spatial database work.
You will back up databases, write SELECT and WHERE queries, join tables, use aggregate functions, manage spatial references, measure geometries, evaluate spatial relationships, create indexes and edit PostGIS data through QGIS.
Master GROUP BY and aggregate functions in PostgreSQL for spatial statistics and summarization.
View resourcePerform multi-table joins in PostgreSQL to merge spatial and non-spatial data efficiently.
View resourceUnderstand CASE statements, data types, and operators in PostgreSQL. Essential for dynamic GIS queries.
View resourceExplore SRID and geometry field essentials in PostGIS. Learn how spatial reference works in GIS databases.
View resourceExecute spatial queries in PostGIS to work with geometries, boundaries, and distance-based filters.
View resourceMeasure area and length in PostGIS using geometry functions. Learn how spatial analysis works in SQL.
View resourceExtract latitude and longitude from geometries in PostGIS. Learn to convert and manipulate XY data.
View resourceHandle spatial relationships in PostGIS using ST_Intersects, ST_Within, and more spatial functions.
View resource
