Spatial SQL with Postgres : A language for geographers

learning spatial SQL and GIS with Postgresql and PostGIS for performing sophistical data analytics and data mining

Ratings 4.26 / 5.00
Spatial SQL with Postgres : A language for geographers

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

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 Should Attend!

  • 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

TAKE THIS COURSE

Tags

  • PostgreSQL
  • SQL
  • Statistics
  • PostGIS

Subscribers

2884

Lectures

19

TAKE THIS COURSE



Related Courses