Introduction to Spatial Databases with PostGIS and QGIS 3
Learn Spatial SQL and database management for GIS Professionals
- Description
- Curriculum
- FAQ
- Reviews
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
Installing software and loading data
Data Query Language - SQL queries for non-spatial data
Making SQL Spatial - Introduction
-
12
The SQL SELECT statement -
13
The WHERE clause
-
14
Aggregate functions and the GROUP BY clause
-
15
Multi-table Queries Part 1
-
16
Multi-table Queries Part 2
-
17
Data Types in PostgreSQL Part 1
-
18
Data Types in PostreSQL Part 2
-
19
The FROM clause implies a loop
-
20
SQL Expressions and Functions Part 1
-
21
SQL Expressions and Functions Part 2
-
22
The CASE Statement
-
23
SQL Views
Making SQL Spatial - Advanced Topics
SQL Data Definition Language
SQL Data Manipulation Language
SQL Data Control Language
Automation
Deploying your database
Miscellaneous
Bonus Lecture
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Stars 5
313
Stars 4
193
Stars 3
39
Stars 2
16
Stars 1
0
Course details
Video
13 hours
Certificate of Completion
Popular courses
Social Network