Spatial SQL with Postgres : A language for geographers (Udemy.com)
learning spatial SQL and GIS with Postgresql and PostGIS for performing sophistical data analytics and data mining
Created by: Arthur Lembo
Last updated April 2021
What you will learn
- use SQL to manage spatial data
- create advanced spatial analysis tools in SQL
- replicate many traditional GIS tasks (overlay, buffer, etc.) using SQL
- understand and manage traditional and spatial indexes
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.1 out of 5higher than 8% of them
- Reviews650#185 of 389 by number of reviews
- Length4.1 hoursshorter than 65% of them
- Last updatedApril 2021earlier than 63% of them
Quality Score
Overall Score : 82 / 100
Course Description
Through a series of lectures, I will work side-by-side with you to develop SQL queries that perform advanced GIS tasks, some of which might be impossible to perform in the GUI. Once my students learn GIS, they very rarely want to return back to using the GUI.
By writing SQL code alongside me, you will see how solving GIS tasks in SQL is like a second nature. This is a very comprehensive course that should take multiple days to complete - but don't worry about that - you will be having a lot of fun learning how powerful SQL can be, and continually ask yourself "why didn't I start using SQL sooner!"Who this course is for:
- students who want to learn SQL
- students who want to apply spatial techniques with SQL
- students who are ordinarily intimidated by programming
- students who want to perform GIS task in a fraction of the time it takes to use the GUI
- students who want to understand the ins-and-outs of how spatial operations work
Instructor Details
- 4.1 Rating
650 Reviews
Arthur Lembo
Dr. Arthur J. Lembo, Jr. is an educator with a passion for GIS and almost 30 years of GIS industry experience. He has won numerous teaching awards, including the prestigious New York State Chancellors award for Excellence in Teaching (2006), and the Maryland Board of Regents Teaching Award (2018) - both of these awards are the highest awards in academia for both States.
Currently, Dr. Lembo is a Professor in the Department of Geography and Geosciences at Salisbury University, where he is also the Technical Director of the Eastern Shore Regional GIS Cooperative. Dr. Lembo has published numerous academic papers on GIS, authored a leading textbook on Statistical Problem Solving in Geography, and conducted sponsored research for organizations like the National Science Foundation, NASA, the United States Department of Agriculture, and the Kellogg Foundation.
More courses by Arthur Lembo
Using Open Source Tools to Create an Enterprise GIS (2015)
4.4 (924 Reviews)
Provider: Udemy
Time: 3.5h
$11.99
Learning Open Source GIS: Spatial SQL w/ Postgres/PosGIS (2023)
4.4 (119 Reviews)
Provider: Udemy
Time: 4.8h
$64.99
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Jonas Kaminskas on 11/22/2020
It would be useful to get the database for making the same actions with the course.
By Kevin Ukueku on 11/8/2020
I love most of his courses.
By Eduardo Antonio Cruz Jurado on 10/2/2020
good choice
By Parminder Singh Bola on 9/26/2020
Good Work!!!
By Joel Rodriguez on 9/4/2020
A lot of the material is old and some of the coding needs updating.
Other that that it was good.
By Alberto Velazquez on 7/11/2020
The greatest course ever, thanyou
By Bianca Flores on 7/7/2020
I like it, he doesn't lose time with things one can learn by him/herself, instead focusing on demonstrating how practical PostGIS and SQL querying can be when dealing with all kinds of Data.
By Eddy Ensing on 6/12/2020
i tought this was a course over spatial slq (like the title : learning spatial SQL and...) but not more than one hour of the 4 is spend on spatial commands. you spending a lot of time on basic sql , also when we getting to spatial sql you only mention the easy spatial commands. a touch of intersec, and non of the fun stuf.
By Eliecer Diaz Diaz on 6/5/2020
Good course! very easy to follow!
By Jerry Ring on 6/2/2020
This is a great introduction to SQL and the spatial aspect to in GIS. Very helpful!
By Sasha Shcheglov on 5/14/2020
This course is great. Thanks!
By Jeremy Herbert on 5/5/2020
The course is good for someone with a bit of GIS knowledge and a bit of SQL knowledge and wants to understand how to use SQL to perform GIS operations.
There is one quote from an article that the author vehemently tries to defend against which seems like a bit of a distraction in terms of the learning, but if you can get past that the course creator provides a good intro for merging SQL and GIS.








