Learn to harness the power of SQL with Postgresql and PostGIS for advanced GIS tasks and spatial data management in this comprehensive course.
This course is your go-to for mastering spatial SQL and GIS with Postgresql and PostGIS. Forget about just clicking around in the GUI! You’ll learn to write SQL queries for advanced tasks that will make your work smoother and more powerful. Trust me, it’s a game changer!
learning spatial SQL and GIS with Postgresql and PostGIS for performing sophistical data analytics and data mining
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!"
use SQL to manage spatial data
create advanced spatial analysis tools in SQL
replicate many traditional GIS tasks (overlay, buffer, etc.) using SQL
1 Lectures
2 Lectures
2 Lectures
7 Lectures
3 Lectures
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...
This course is from 2016 and was updated in 2021, while its 2024 now. I could not access all the data in the resources, which, I assume, is because the technology has changed. So, I ended up missing out a huge section of the course by just watching the lecture instead of following it along and practicing writing code. I regret buying the course and I wish I had invested the money borrowed from my parents, in another Spatial SQL course.
Dr. Lembo's courses never disappoint. A great teacher and speaks at a level of understanding that the most novice of students can understand. Highly recommend any course he teaches!
Ja, er war gut geeignet. Der Kurs ist leider etwas älter, was beim Einstieg mit den aktuellen Software Versionen ein paar Schwierigkeiten bereitet. Das Weitere ist dann etwas sprunghaft und wirkt nicht sehr strukturiert. Wenn man sich aber darauf einlässt, dann bekommt man am Ende doch einen recht guten Überblick oder Einblick.
Apresenta muitos triques legais para trabalhar com sql. Não diria que é um curso para iniciantes, pois não é aprofundado, mas o intrutor explica muito bem, de forma simples e direta. O que ele se própôs a explicar eu entendi rapidamente.
Very informative and easy to follow, a great first step into coding for GIS use, myself having more knowledge of coding & SQL than of GIS the course does a good job of demonstrating the use, applications and how it might be done using the GUI to show the advantage presented by using SQL
Outdated with missing data. Subject matter and instruction was good. Would have rated higher if not for the two previously mentioned issues.
attend only if you already have a passable knowledge of GIS terminology and functions. outdated program versions but solid overview. also assumes prior knowledge of basic SQL, or zero knowledge but quick learning ability
Had some issues getting the data configured but I thought the actual content of the course was excellent. I look forward to continue to explore spatial SQQL further. A more advanced SQL course that uses up-to-date software would be very welcomed :)
El curso presenta consultas SQL simples pero poderosas, bien explicadas. Elige muy bien qué mostrar y en que orden, logrando un muy buen uso del tiempo con efectividad en el aprendizaje.
Your email address will not be published. Required fields are marked *
Frank G.
Awesome