An Introduction to SQL for ArcGIS Pro® for Esri Users

teaching Esri users how to leverage SQL in their ArcGIS projects.

3.95 (26 reviews)
Udemy
platform
English
language
Other
category
instructor
235
students
5 hours
content
Aug 2021
last update
$59.99
regular price

What you will learn

how to operate the SQL for ArcGIS Pro interface.

how to write SQL for GIS and data analytics.

spatial operations for GIS analysis using SQL.

how to integrate geodatabases, Postgres databases, shapefiles and other data sources into a cohesive GIS solution.

how to perform perform parallel processing using SQL for ArcGIS Pro.

Description

Just released by Manifold Software Limited - SQL for ArcGIS Pro!  This new add-in for ArcGIS Pro now allows you to perform full SQL processing on Esri geodatabases.  That means for the first time selects, updates, inserts, joins, aggregate queries, spatial SQL, and other SQL functionality now apply to Esri geodatabases.    And if that isn't enough, the SQL for ArcGIS Pro Add-In is fully parallel, meaning if you have the cores on your computer, SQL for ArcGIS Pro will use it - with no restrictions or additional costs to use the massive number of cores typically found on gaming PCs. 

Like my other video training, SQL for ArcGIS Pro for Esri Users is a full video course, equivalent to two days of training. In this course you'll learn to use basic and advanced SQL to explore, analyze, edit, and update Esri geodatabases using the new SQL for ArcGIS Pro Add-In.  You'll learn how to write SQL queries, integrate spatial concepts, and pull in data sources from other technologies within a common application that works directly with ArcGIS Pro. 

If you are an Esri professional, you likely know how to perform GIS analysis within the Esri GUI, and may even be skilled with Model Builder and Python.  But, if you haven't been exposed to SQL, you'll gain so much knowledge about the power that SQL offers to GIS professionals. 

The course will cover:

  • an overview of SQL

  • traditional SQL queries

  • spatial SQL for vector geometry

  • advanced concepts in SQL

  • and numerous real life scenarios to demonstrate how SQL for ArcGIS can be used within your current Esri environment.

Important note:  The SQL for ArcGIS Pro module is sold by Manifold Software Limited.  It is a low-cost Windows-based application.  But, it is not free.  However, you can download the Manifold GIS Free Viewer and make use of almost all of the functionality in SQL for ArcGIS Pro.  The only limitations of using the free viewer include having to import the geodatabase yourself into the Manifold GUI, no ability to save or print out your results, and you can't update Esri geodatabases.  However,  this is an excellent way to test out the SQL queries in SQL for ArcGIS Pro without having to pay anything.

Content

Introduction to the workshop

Purpose, learning objectives, and schedule
Installation of SQL for ArcGIS Pro
Quick Start Tutorial: why you need to leverage SQL in your GIS projects
Why you should use SQL with your geodatabases
Overview of the data and scenarios

Practical matters when working with SQL for ArcGIS Pro

Understanding the user interface
The query window - this one is important!
Three options for creating queries: SQL from scratch, transforms, function calls
Read the *fine* manual (RTFM), get help from others.

Let's start writing some queries: Basic SQL Queries for Esri Users

Introduction to writing queries: what to expect over the next few hours
Select and conditional statements
Calculations in queries
Aggregation functions in queries
Rolling SELECTS, calculations, and Aggregate functions into one

Intermediate SQL Queries for Esri Users

Joining tables with SQL
Modifying data with SQL

Spatial SQL Queries for Esri Users

Spatial Considerations with SQL for ArcGIS Pro
Spatial operations in queries
Spatial operations with considerations for ditances

Real world scenarios where SQL for ArcGIS Pro is ideal

Think fast! Responding with SQL in crisis situations
Simplifying messy data easily: determining access to COVID19 vaccination sites

Screenshots

An Introduction to SQL for ArcGIS Pro® for Esri Users - Screenshot_01An Introduction to SQL for ArcGIS Pro® for Esri Users - Screenshot_02An Introduction to SQL for ArcGIS Pro® for Esri Users - Screenshot_03An Introduction to SQL for ArcGIS Pro® for Esri Users - Screenshot_04

Reviews

Fred
May 21, 2023
This is a great introduction to SQL and how it can be used in addition to your current SQL tools in Arcpro.
Michelle
March 9, 2023
This is not useful unless a third party software is purchased separate from ArcGIS Pro. Supposedly there is a free version to to learn how to use the software by Manifold, but there is no link I can find on the website.

Charts

Price

An Introduction to SQL for ArcGIS Pro® for Esri Users - Price chart

Rating

An Introduction to SQL for ArcGIS Pro® for Esri Users - Ratings chart

Enrollment distribution

An Introduction to SQL for ArcGIS Pro® for Esri Users - Distribution chart

Related Topics

4230276
udemy ID
8/8/2021
course created date
8/16/2021
course indexed date
Bot
course submited by