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

( 208 Reviews )

Created by: Arthur Lembo

Produced in 2016

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Course Description

Are you stuck in a rut of only knowing how to use a GIS GUI? Do you want to learn how to automate tasks, but are afraid of computer programming. If so, SQL is the most powerful tool you can learn to help you perform complex GIS tasks. This course is designed to teach you how to write SQL to replicate many database and GIS tasks. We will start at a very basic overview, and then proceed to more advanced topics related to GIS.
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

Time: 4h

Instructor Details

Arthur Lembo

4.5 Rating
208 Reviews

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.

Using Open Source Tools to Create an Enterprise GIS

Using Open Source Tools to Create an Enterprise GIS (2015)
4.5 (245 Reviews)

- Provider: Udemy
- Time: 3.5h

$11.99

All courses by Arthur Lembo

Reviews

4.5

208 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

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.