Learn the FOSS4g Stack: Spatial SQL with PostgreSQL/PostGIS
Spatial SQL: a language for geographers, GIS and remote sensing experts
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 PostgreSQL, 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 will simulate some real-world examples of GIS projects and spatial analysis.
Whether you need to learn SQL within PostgreSQL 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.
Welcome
FREE PREVIEWLesson 1: Introduction to the course
FREE PREVIEWLesson 2: Download and Install PostgreSQL 11
Lesson 3: Download and Install QGIS 3.8
Lesson 4: Explore our dataset
Lesson 5: Loading and checking the data
Lesson 6: Interacting with data: QGIS and PGAdmin
FREE PREVIEWLesson 7: Why and what is SQL?
Lesson 8: Numeric data types
Lesson 9: Boolean and character data types
Lesson 10: Data and time data types
Lesson 11: Spatial data types
Lesson 12: SELECT statements and some variations
Lesson 13: AGGREGATE and GROUP BY functions
Lesson 14: UPDATE, INSERT and DELETE functions in SQL
Lesson 15: Conditional statements in SQL - the CASE function
Lesson 16: Coordinate systems in SQL
Lesson 17: Indexing in SQL - spatial and non-spatial
Lesson 18: Spatial operations Part 1
Lesson 19: Spatial operations Part 2
Lesson 20: Basic problems in geography
Lesson 21: Variogram modeling with SQL
Lesson 22: Spatial analysis tools - Distance, Adjacency, Interaction
Lesson 23: How to create functions with PostgreSQL/PostGIS
Lesson 24: Summarize and produce statistics of parcel data with watershed and flood-zone areas
Course Slides
Course dataset
€25,00
Regular price
How to conduct spatial analysis with Postgres 11 and PostGIS
Basic 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
Under/post graduate students
Professionals and Companies
Master students and PhD candidates
Researchers and Academics
Understanding of what a database is
Some exposure to GIS operations
Comfortable with using GIS software
Arthur Lembo
Professor
Free
Enroll Now€35,00
Enroll Now