Does anyone know a good training course to learn SQL for ArcGIS?

[MariaRoquet_Guàrdia]

I am looking for a training course to give a full coverage on SQL for ArcGIS to work with Server. I haven't found any set courses on the ESRI website so I was wondering if anyone knows of the existence of a course like that, online or not.

[Egge-Jan_Pollé]

Hi Maria Roquet Guàrdia‌,

Did you have a look at this one? SQL reference for query expressions used in ArcGIS—ArcGIS Pro | ArcGIS Desktop 

It is not a formal training course, I know, but trying to apply the examples on your own data might be insightful.

As with any language, the best way is to learn SQL step-by-step.

HTH,

Egge-Jan

[MariaRoquet_Guàrdia]

Thanks, Egge-Jan

I came across this link few days ago but I am need of something more complex so I can use in Microsoft SQL Server Management Studio along side data stored in ArcGIS Server. Basically to create triggers, set procedures, etc...

[MichaelGreen]

Hi Maria,

I am not sure if this is relevant but we do have an instructor led course called Deploying and Maintaining a Multiuser Geodatabase.  https://www.esri.com/training/catalog/57630436851d31e02a43f104/deploying-and-maintaining-a-multiuser...

If you go to this link you can take a look at the table of contents to see if the workflows that you will learn apply to the creation of triggers, setting procedures, etc that you need.

If this course is not what you need, let me know and I will have a training consultant reach out to help look for other courses.

Thanks!

[MariaRoquet_Guàrdia]

Hi Michael,

Thanks for your answer although this course doesn't really teach what I need as it barely touches the aspects I am more interested in (basically creating stored procedures, triggers, etc...)

[Egge-Jan_Pollé]

DataCamp?

Writing Functions and Stored Procedures in SQL Server | DataCamp 

HTH,

E-J