Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 4 Minute(s)
Language
English
Taught by
Arthur Lembo
Rating
Course Overview
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!"
Course Content
- 7 section(s)
- 19 lecture(s)
- Section 1 Welcome Message - What you need to get started
- Section 2 Loading Software and Data
- Section 3 Overview of SQL
- Section 4 SQL Data Types
- Section 5 Traditional SQL
- Section 6 Spatial SQL for Vector Geometry
- Section 7 Spatial SQL for geographic analysis
What You’ll 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
Reviews
-
BBrock Calliou
Outdated with missing data. Subject matter and instruction was good. Would have rated higher if not for the two previously mentioned issues.
-
KKevin
This course is a great introduction to Spatial SQL using PostGIS. The knowledge gained here allowed me to use a spatial database for a web application, which changed my career path trajectory dramatically. If you have no experience in PostGIS, like myself when I started this class, I can't recommend it enough.
-
WWalter Humberto Subiza Pina
Installation tutorial must be updated to the new versions of postgres, postgis and QGIS, anyway the tutorial is still useful, but could be confuse for new comers
-
SSmartRural
Ha sido buena elección, hace un repaso desde la base hasta llegar a un nivel bastante avanzado. Todo ello condensado en vídeos en los que no se pierde el tiempo.
