What Will I Get ?

• Setup an instance of PostgreSQL and PostGIS either locally or accessible via the internet.
• Access your PostGIS instance and load your own geospatial data.
• Utilize PostGIS data from a variety of clients (Primarily QGIS, but also ArcGIS, pgAdmin4, web clients, and more)
• Learn to create new tables, modify existing tables, and view existing data via SQL
• Perform geospatial analysis using Spatial SQL
• Control user access to your data with roles and privileges
• Automate the datbase with custom functions
• Deploy your database to an internet accessible server

Requirements

• Basic understanding of QGIS (displaying geospatial data, etc.)
• Desire to expand your knowledge of multi-user spatial databases.

Description

This course is intended to provide an introduction to spatial databases in general and PostGIS in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. You will learn

• What a spatial database is and why you would want to use one.

• What SQL is, why you would want to use it, and how it can be applied to geospatial concepts.

• How to install PostGIS locally for development purposes and how to access a production version via a network or the internet.

• How to load your spatial data into PostGIS and access it from a variety of clients, especially QGIS

• The basics of SQL for both spatial and non-spatial queries

• How to validate data and control user access with the tools built-in to PostGIS

• Optimizing your queries for the best performance

• How to work with raster data in PostGIS

• The basics of programming custom functions with PL/pgSQL

• The basics of database administration to keep your database operating smoothly