Query Spatial with PostGIS

Querying spatial data effectively starts with understanding how geography is modeled, indexed, and analyzed inside a relational database. In this hands-on course, you’ll move beyond basic SQL by learning how to query geospatial data using PostGIS, PostgreSQL’s spatial extension. You’ll begin by working with core geometry types and spatial reference systems, building a foundation for how location data is stored and interpreted. From there, you’ll write spatial queries that perform distance calculations, proximity searches, and spatial joins to answer real-world questions. As you progress, you’ll explore spatial indexing and query patterns that improve performance and reliability as datasets grow. By the end of the course, you’ll produce reusable spatial SQL queries and analysis patterns that support practical use cases in areas such as logistics, urban planning, and geospatial data engineering—equipping you to work confidently with location-based data in production environments

• Apply spatial indexing to improve query speed
• Construct advanced spatial queries to answer real-world questions
• Analyze query patterns to enhance performance and reliability

• Basic computer and internet skills
• Ability to read course instructions in English