Spatial SQL: a language for geographers
Are you a database user who wants to learn about spatial data analytics? Are you a GIS professional 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 using Microsoft's SQL Server. 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 in SQL Server 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!"
Students who complete this task will be comfortable writing traditional SQL and spatial SQL within SQL Server. They will understand how to address different data types, functions, and SQL workflows for traditional and spatial data operations.
2 Lectures
5 Lectures
5 Lectures
2 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...
Excellent course. As a GIS professional, this gave me all of the information I needed to interact with a database outside of ArcGIS Pro. This was particularly useful for a project I am working on currently. Just an FYI you can download the latest free SQL Server Studio client, not the 2012 version, and all of the functionality that is gone over in this course will still work just fine.
I successfully downloaded SQL 2012 Community Edition, SSMS. Installed and restored the database.
This course is a good introduction to spatial SQL
Was more focused on sql vs spatial sql
Perfect introduction and good length for getting a quick familiarity with some of the basic things I want to be able to do and build on using SQL and managing GIS data
Was very helpfull. Maybe i should do another course, but it would be great to learn how to present spacial data in graphics etc in power bi and excel.
Just the course I was looking for to become more familiar with MS SQL Server and spatial data.
My first AH-HA moment came when I saw my first sql code doing a 'JOIN' on two unrelated tables, base solely on their [Geometry] spatial data columns. These tables had no columns in common, no foreign keys, yet SQL was able to intersect them based on location. OK, that was pretty spectacular, and it was Pure Sql Server. No ESRI, no R, just SQL Express. Lost half a star only because the course was not tailored perfectly to my experience level as a SQL veteran.
GOOD, Exactly what i'm working with everyday, it will improve my knowledge about gis in sql server
Your email address will not be published. Required fields are marked *
Andre M.
Spatial part is good, mixing it in with basic SQL assist in showing that its just another data type. Application part also shown quite good. For the time spent on this course a great deal of exposure to using SQL spatial better.