Introduction to Spatial Databases with PostGIS and QGIS 3

Introduction to Spatial Databases with PostGIS and QGIS 3, available at $79.99, has an average rating of 4.32, with 69 lectures, based on 1202 reviews, and has 6009 subscribers.

You will learn about 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 This course is ideal for individuals who are GIS professionals who are interested in expanding their GIS skillsets into multi-user enterprise level spatial databases. It is particularly useful for GIS professionals who are interested in expanding their GIS skillsets into multi-user enterprise level spatial databases.

Enroll now: Introduction to Spatial Databases with PostGIS and QGIS 3

Summary

Title: Introduction to Spatial Databases with PostGIS and QGIS 3

Price: $79.99

Average Rating: 4.32

Number of Lectures: 69

Number of Published Lectures: 69

Number of Curriculum Items: 69

Number of Published Curriculum Objects: 69

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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 Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: What can a spatial database do for you?

Lecture 3: What is a spatial database exactly?

Lecture 4: Where does a spatial database live?

Lecture 5: What is SQL and why would you want to use it?

Chapter 2: Installing software and loading data

Lecture 1: Installing PostGIS on your local computer

Lecture 2: Installing QGIS

Lecture 3: Loading spatial data into PostGIS

Lecture 4: Loading non-spatial data into PostGIS

Lecture 5: Accessing PostGIS from the commandline, the pgAdmin GUI, QGIS, and ArcGIS

Lecture 6: Organization of a database

Chapter 3: Data Query Language – SQL queries for non-spatial data

Lecture 1: The SQL SELECT statement

Lecture 2: The WHERE clause

Lecture 3: Aggregate functions and the GROUP BY clause

Lecture 4: Multi-table Queries Part 1

Lecture 5: Multi-table Queries Part 2

Lecture 6: Data Types in PostgreSQL Part 1

Lecture 7: Data Types in PostreSQL Part 2

Lecture 8: The FROM clause implies a loop

Lecture 9: SQL Expressions and Functions Part 1

Lecture 10: SQL Expressions and Functions Part 2

Lecture 11: The CASE Statement

Lecture 12: SQL Views

Chapter 4: Making SQL Spatial – Introduction

Lecture 1: The PostGIS Vector Geometry model

Lecture 2: The Spatial Reference ID

Lecture 3: The Geometry Field

Lecture 4: Geometry vs.Geography data type

Lecture 5: Spatial Queries – Working with Geometries

Lecture 6: Spatial Queries – Measurements

Lecture 7: Spatial Queries – Accessing the geometry

Lecture 8: Spatial Queries – Testing spatial relationships

Chapter 5: Making SQL Spatial – Advanced Topics

Lecture 1: Multi-table Spatial Queries

Lecture 2: Optimizing your queries

Lecture 3: Spatial aggregate functions

Lecture 4: Geometry processing functions Part 1

Lecture 5: Geometry processing functions Part 2

Lecture 6: Challenge Scenarios Part 1

Lecture 7: Challenge Scenarios Part 2

Chapter 6: SQL Data Definition Language

Lecture 1: Creating tables

Lecture 2: Primary and Foreign Keys

Lecture 3: Creating indexes

Lecture 4: Creating custom data types

Lecture 5: Modifying data structures with the ALTER statement

Lecture 6: GUI methods for defining data structures

Chapter 7: SQL Data Manipulation Language

Lecture 1: Adding new records with the INSERT statement

Lecture 2: Adding geometry to a feature with the INSERT statement

Lecture 3: Modifying data with the UPDATE statement

Lecture 4: Deleting records

Lecture 5: Challenge exercise: Putting it all together

Chapter 8: SQL Data Control Language

Lecture 1: Creating Roles with SQL

Lecture 2: Granting privileges with SQL

Lecture 3: Example – roles and privileges in pgAdmin4 GUI

Lecture 4: Example – roles , privileges, and multi-user editing in QGIS

Chapter 9: Automation

Lecture 1: Transactions

Lecture 2: User defined functions – SQL

Lecture 3: User defined functions – PL/pgSQL – Introduction

Lecture 4: User defined functions PL/pgSQL – Branching and looping

Lecture 5: User defined Functions – PL/pgSQL – Error handling

Lecture 6: Triggers

Lecture 7: Pulling it all together – examples

Chapter 10: Deploying your database

Lecture 1: Introduction

Lecture 2: Registering for a web hosting service

Lecture 3: Moving the database to a remote server

Lecture 4: Deploying to the AcuGIS Cloud

Lecture 5: Performance considerations

Lecture 6: Strategies for mitigating slow response times

Chapter 11: Miscellaneous

Lecture 1: Backing up and exporting data

Lecture 2: Where to go next

Chapter 12: Bonus Lecture

Lecture 1: Bonus Lecture: How to get the most from my series of Udemy courses.

Instructors

Michael Miller
GIS Programming

Rating Distribution

1 stars: 5 votes

2 stars: 22 votes

3 stars: 96 votes

4 stars: 402 votes

5 stars: 677 votes

Frequently Asked Questions

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!