is there any kind of instructer led classes for SQL users that is geared toward GIS users?
Are you wanting classes in terms of managing an enterprise geodatabase or classes geared towards using non-Esri GIS technologies available to the RDBMS, such as SQL-Spatial, Oracle-Spatial, and PostGIS?
I would check out these class descriptions Esri Training (if the list isn't filtered, search for SQL). Most are for administrators, but the Esri Training | Building Geodatabases is more for users, I believe. Also, check out and search Esri Video | Videos Covering GIS Events, Products, People, & Topics
If you are asking more about the SQL language, and not Microsoft SQL or SDE specific, you may want to look at something like SQL Tutorial
Retrieving data ...