Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
12 Hour(s) 39 Minute(s)
Language
English
Taught by
Michael Miller
Rating
1 views
Course Overview
Learn Spatial SQL and database management for GIS Professionals
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
Course Content
- 12 section(s)
- 69 lecture(s)
- Section 1 Introduction
- Section 2 Installing software and loading data
- Section 3 Data Query Language - SQL queries for non-spatial data
- Section 4 Making SQL Spatial - Introduction
- Section 5 Making SQL Spatial - Advanced Topics
- Section 6 SQL Data Definition Language
- Section 7 SQL Data Manipulation Language
- Section 8 SQL Data Control Language
- Section 9 Automation
- Section 10 Deploying your database
- Section 11 Miscellaneous
- Section 12 Bonus Lecture
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
Skills covered in this course
Reviews
-
HHaoxin Zhang
It is excellent teaching for GIS
-
KKim Allen
do not need to know about dbs, need to know about SPATIAL DB
-
EEdward Samuel Nabigwaku
The course provides way more than I expected. Happy to learn both GIS and db management
-
EEmanuel Castillo Cardona
Great Course. This professor is really amazing, thanks my friend for your teachings
