Training course on SQL in ArcGIS Pro

Bud — Sun, 07 Jan 2024 22:15:40 GMT

In my experience, SQL is often a gap in ArcGIS Pro users' skillsets. It seems to me that a course on SQL in ArcGIS Pro would be beneficial.

Could Esri consider offering such a course? Or some other kind of resource?

Some lesser-known SQL topics could include:

Using correlated subqueries in select by attributes, definition queries, Append GP tool expression, etc.
- Example: One-to-first joins: Control what related record is used
Using ST_GEOMETRY functions in select by attributes and definition queries
Use the Diagnostic Monitor to view SQL queries sent from Pro to the database
SQL in Arcade
Querying GIS data in SQL clients like SQL Developer
Using geodatabase system tables in SQL queries
Working with data from on-prem external databases using SQL, in conjunction with GIS data, via database links, etc.
Database views and query layers
SQL comments in select by attributes and definition queries
Generating sample data with SQL in a query layer or view:
- Generate grid line features using SQL
- Convert grid lines to polygons
Generate a EGDB database view that has a spatial SQL query in it using the Select Layer by Location GP tool’s "Intersect (DBMS)" option.

Re: Training course on SQL in ArcGIS Pro

Bud — Thu, 09 Mar 2023 14:56:51 GMT

Another possible idea: Esri staff could hold a session at the next Dev Summit or User Conference about using SQL in ArcGIS Pro.