Skip to main content
GIS-Schools GIS-Schools
GISSchools Course

Learn Spatial Databases with PostGIS and QGIS

Build dependable spatial database skills with PostgreSQL, PostGIS, SQL, geometry operations, indexing and QGIS database workflows.

21 verified lessons
Start Course View lessons
Learn Spatial Databases with PostGIS and QGIS
Course overview

What you will learn

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.

  • Install and administer PostgreSQL/PostGIS.
  • Write useful attribute and spatial SQL queries.
  • Build efficient, well-indexed spatial tables.
Course/Video Tutorial Part 8

PostgreSQL: The WHERE clause

Use the WHERE clause to filter spatial and attribute data in PostgreSQL. Learn powerful SQL filtering techniques.

  • Muhammad Sohail
  • 1 min read
View resource