Introduction to Spatial Databases with PostGIS and QGIS 3

Name: Introduction to Spatial Databases with PostGIS and QGIS 3
Rating: 4.6 (1078 reviews)

Learn Spatial SQL and database management for GIS Professionals

Bestseller

(1,078 ratings)

5,351 students

Created by Michael Miller

Last updated 11/2019

English

English [Auto], Spanish [Auto]

What you'll learn

Understand the advantages of storing spatial information in spatially enabled databases
Install PostGIS locally for development purposes and/or access an instance of PostGIS that is running on their organizations intranet, a web host, or the cloud
Write SQL queries to retrieve and analyze spatial data.
Use the tools available in PostGIS to validate data and control user access
Perform basic database administration functions to keep your spatial database running smoothly

Requirements

You should be familiar with GIS concepts and be willing to learn QGIS. My course QGIS 3.0 for GIS professionals will provide all the background that is necessary but it is not a formal pre-requisite.

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. This course uses the latest (as of 2/18) versions of PostgreSQL (10.1), PostGIS (2.4), and QGIS (3.0). I believe it is the most current and thorough course on spatial databases available today. 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

Who this course is for:

GIS professionals who are interested in expanding their GIS skillsets into multi-user enterprise level spatial databases.

Featured review

Alaina M.

3 courses

2 reviews

3 years ago

Aside from being a great instructor, Mike is a thoughtful and kind person. His course truly encompasses the essentials of PostGIS AND includes other information you didn't even know that you wanted to know. This course is wonderful if you are new to the SQL or PostGIS world. He takes an intimidating task and breaks it down into digestible chunks. There is useful information for intermediate and advanced PostGIS users, too. Thank you, Mike. And, good luck future PostGIS students!

Michael Miller

GIS Programming

4.5 Instructor Rating
7,028 Reviews
20,468 Students
20 Courses

I have been programming and working with database applications for over 30 years, and specializing in geospatial applications for over 20 years. I am a believer in the 80/20 pareto principle which suggests that you only need to understand 20% of a subject in order to do 80% of your work. My goal in all my courses is to teach at the level of that 20% sweet spot and to provide my students with the background and the tools they need to learn the rest of what they need on their own.