PostGIS
Course Index
40 Lessons · 3 Levels
Complete PostGIS spatial database roadmap — spatial SQL, geometry types, spatial joins, indexing, pgRouting, GeoServer, cloud hosting, and real spatial database builds.
40Lessons
3Levels
3Projects
FreeAccess
Level IFoundations & SetupLessons 1–12
Lesson 01
Introduction to PostGIS
Lesson 02
Why Spatial Databases?
Lesson 03
PostgreSQL Basics
Lesson 04
Installing PostgreSQL & PostGIS
Lesson 05
pgAdmin Tour
Lesson 06
SQL Refresher: SELECT & WHERE
Lesson 07
SQL Joins & Aggregations
Lesson 08
Enabling the PostGIS Extension
Lesson 09
Geometry vs Geography Types
Lesson 10
Points, LineStrings & Polygons
Lesson 11
SRID, EPSG & Projections
Lesson 12
Creating Spatial Tables
Level IISpatial SQLLessons 13–27
Lesson 13
Loading Shapefiles with shp2pgsql
Lesson 14
Importing with QGIS & ogr2ogr
Lesson 15
ST Functions Overview
Lesson 16
Measuring Distance, Area & Length
Lesson 17
Spatial Relationships: ST_Intersects
Lesson 18
ST_Contains, Within & Touches
Lesson 19
Spatial Joins
Lesson 20
Buffers in PostGIS
Lesson 21
Overlay: Intersection, Union & Difference
Lesson 22
Geometry Processing & Simplification
Lesson 23
Transforming Projections: ST_Transform
Lesson 24
Nearest Neighbor Queries
Lesson 25
Clustering & Aggregating Geometries
Lesson 26
Geocoding in PostGIS
Lesson 27
Validating & Fixing Geometries
Level IIIAdvanced & ProjectsLessons 28–40
Lesson 28
Spatial Indexing with GiST
Lesson 29
Query Optimization & EXPLAIN
Lesson 30
Raster Data in PostGIS
Lesson 31
3D Geometries
Lesson 32
pgRouting: Network Analysis
Lesson 33
PostGIS with QGIS
Lesson 34
Serving Maps with GeoServer
Lesson 35
Users, Roles & Permissions
Lesson 36
Backup & Restore
Lesson 37
PostGIS in the Cloud
Lesson 38
Build a City Analysis Database
Lesson 39
Build a Store Locator Backend
Lesson 40
Build a Routing Application