Skip to content
Write a review
UdemyIT & SoftwarePaid courseAll LevelsCertificate

Learning Open Source GIS: Spatial SQL w/ Postgres/PosGIS (Udemy.com)

Spatial SQL: a language for geographers

4.4
119 reviews

Created by: Arthur Lembo

Last updated June 2023

icon
What you will learn

  • How to conduct spatial analysis with Postgres 11 and PostGIS
  • Traditional SQL statements
  • Spatial SQL statements
  • Creating spatial functions with SQL
  • How to create geographic models with SQL
  • PGAdmin IV to manage Postgres databases
  • QGIS Database module to manage Postgres databases
  • Join multiple tables together

How it compares

Against the other 1,182 rated Udemy courses in IT & Software on CourseDuck:

  • Rating4.4 out of 5higher than 30% of them
  • Reviews119#962 of 1,183 by number of reviews
  • Length4.8 hoursshorter than 54% of them
  • Last updatedJune 2023earlier than 72% of them

icon
Course Description

This course is part of an entire curriculum based on Free and Open Source GIS (FOSS4g) software, and represents one of the most comprehensive curriculum on FOSS4g. The curriculum are grouped into the categories of Desktop, Server, and Developer parts of the FOSS4g stack. For this course, you will learn the most popular open source database: Postgres 11. We'll start with a basic understanding of Postgres, introduce PostGIS as a spatial plug in, and begin to solve spatial problems using SQL. 

This course uses real data from Tompkins County, New York, and seamlessly integrates with other gisadvisor courses that will teach you QGIS, GDAL, Geoserver, and Python. You'll be working alongside me as we explore the capabilities of SQL, working with raster, vector, and attribute data. And most importantly, after you learn SQL and spatial SQL you willl simulate some real-world examples of GIS projects and spatial analysis.

Whether you need to learn SQL within Postgres and PostGIS for your job, or want to get spun up on FOSS4g to nail that big interview, this course will prepare you to work with the ins-and-outs of SQL and spatial SQL, and give you confidence as you interact with other GIS experts.

The curriculum is designed so that you can start with either this course, or any of the other courses. They will refer back and forth with one another, and because we are camping out in the same geographic area, all the courses will use the same data. As you move through each course, you are going to have experience with all the different parts of the FOSS4g stack.
Read More All Levels All Levels product length iconTime: 4.8h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

Read More

icon
More courses by Arthur Lembo

$11.99

$39.99

All courses by Arthur Lembo

icon
More IT & Software courses

$49.99

$10.99

$124.99

$19.99

$11.99

$19.99

All IT & Software courses

icon
Reviews

4.4

119 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Jenny Deygin on 2/16/2026

The audio quality is difficult to listen to, which makes it harder to stay focused throughout the lessons. In addition, the lecturer moves the cursor around the screen excessively during explanations. This constant movement makes it difficult to follow what part of the content he is referring to and interrupts the flow of the presentation.

By Neil Tucker on 5/20/2023

A great overview of PosGIS and general GIS concepts. Great for beginners. Easy to follow and engaging.

By Ana López Díaz on 5/19/2021

Everything good excepts the last two sections, because they are focus on complex statistics and functions . Also, I am still waiting for someone answer my question.

By Ogrenci Learn on 4/7/2021

Im new to GIS but comfortable with Databases. Great course and I was really surprised how powerful spatial sql can be. Thanks Arthur

By Edilberto Flores Uribe on 5/31/2020

No tenía ninguna noción previa acerca de SQL ni de Postgres; las explicaciones me parecieron concisas y precisas. El material que se descarga es suficiente para realizar todos los ejemplos a lo largo del curso y practicar aún más. Me sorprendió la gran cantidad de procesos que se pueden realizar de forma más rápida -y sencilla- dentro de PostGIS que dentro de un SIG. Muy recomendable para cualquier persona interesada en los SIG.

By Fabian Feijen on 4/25/2020

Ik ben dankzij deze cursus definitief overtuigd om spatial SQL te gaan gebruiken. De toegevoegde waarde van spatial SQL is dat: - een taak die in een GIS in vele stappen goed is uit te voeren ook met het schrijven van slechts enkele regels SQL kan worden uitgevoerd. In sectie 7 wordt duidelijk dat de inzet van spatial SQL een goed alternatief voor een QGIS model kan zijn. - taken die in een GIS lastig zijn uit te voeren met SQL relatief eenvoudig zijn uit te voeren (zie sectie 6). Docent Arthur Lembo houdt in sectie 2 een warm pleidooi voor het gebruik van SQL. Hij legt onder meer uit waarom het gebruik van SQL statements de voorkeur geniet boven het gebruik van query wizards.

By Rafał Pogorzelski on 4/15/2020

A little bit confusing if you are a beginner with sql. Lack of any assignment to do on your own. Overall a plenty of room for improvement.

By Aranzazu Muelas Molina on 4/1/2020

Me gusta porque me mantiene la motivación durante el curso, también mantiene y asciende el nivel poco a poco. Es muy fácil de seguir y completar. Ha cubierto todas mis expectativas. Estoy deseando aplicar todo lo que he aprendido.Gracias.

By Ethan Ray on 3/8/2020

This was my first course diving into SQL and I was able to follow along and grasp the lessons. Dr. Lembo is a great teacher!

By Logan Hall on 3/6/2020

Great pace; quality video and audio; content is relevant and appropriately spaced out through the course. Highly recommended!

Showing all 10 reviews on CourseDuck

Read all 119 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100

Learning Open Source GIS: Spatial SQL w/ Postgres/PosGIS
Visit course on Udemy Write a review
  • Video Duration: icon 4.8h
  • Price: $64.99
  • Provider: icon Udemy
  • Updated: icon June 2023
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com