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.
- 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 a EGDB database view that has a spatial SQL query in it using the Select Layer by Location GP tool’s "Intersect (DBMS)" option.