Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.
Interactive Course
Learn how to work with maps in SQL
Did you know that databases can store geographical data? With the help of spatial extensions, a database can store the locations of stores, ATMs, hotels, streets, districts, and other points of interest. Moreover, you can use SQL queries to process this information.
In this course, you'll learn about PostGIS, a spatial extension of the PostgreSQL database. You will learn how PostGIS stores geographical data and how its basic geographical functions can be used in simple and complex SQL queries.
To make your learning process more interesting, we'll be working with both real and not-so-real places in San Francisco and the United States. Additionally, we've prepared a special surprise—some exercises will even let you see the results of your queries drawn on a real world map!
Are you ready? Let's jump right in!
Course progress
Exercises completed
Not sure if you're ready to take this course? Take this preliminary quiz to find out.
Exercises completed
We're getting started with PostGIS. You'll learn the basic terminology related to spatial databases.
Exercises completed
Introduction to spatial databases
Short quiz
That's where the real fun begins. You'll get to know points, linestrings and polygons.
Exercises completed
Introduction
Points
Linestrings
Polygons
How can points, linestrings and polygons relate to each other? Let's find out in this part of the course.
Exercises completed
Introduction
ST_Equals
Relationships Between Geometries
ST_Distance and ST_Dwithin
Spatial joins practice
In this part, we'll present further spatial functions and introduce collections.
Exercises completed
Introduction
Functions returning geometries
Finally, it's time to get to know geography column type.
Exercises completed
Introduction
Geometry vs. Geography
Do you think you remember everything from our course? It's time to practice before the final quiz.
Exercises completed
The time has come to test your knowledge in the final PostGIS quiz.
Exercises completed
Introduction
Quiz
Congratulations