Training course on SQL in ArcGIS Pro

Bud

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.

Bud

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