SQL advice

[seidu]

Please could you advice on which SQL package (Oracle, Microsoft, etc...) is good for a risk manager (or finance in general). @Mkaim @brian.field and @Dr. Jayanthi Sankaran which one is more applicable in the industry.

Thanks

Seidu

 

[brian.field]

I don't know much about sql, regrettably. That being said, I have seen SQL Server Management Studio most often. However, SQL is SQL is it not? So, if you can program in one application, you should be able to do in others, more or less. Additionally, you can utilize SQL syntax in proc SQL in SAS to some degree.

 

[Mkaim]

Hi @seidu ,

Oracle (Toad being the UI) is the platform used in most large organizations followed by Sybase (Embarcadero being the UI) for SQL. I know there is a slight difference in syntax, like Sybase is case sensitive while Oracle is not. Anyways, to @brian.field 's point, the language is the same irrespective of which platforms you use it on; the minor differences are just, well, minor. If someone does want you to select between the options before moving on, I would select Oracle (at the end of the day it doesn't really matter if the objective is to learn the language).

 

[seidu]

Thanks for the insight @brian.field and @Mkaim

 

[Dr. Jayanthi Sankaran]

Sorry Seidu - don't know anything about SQL!

 

[seidu]

Ok thanks, I am even thinking of focusing on SAS since it has some features of SQL.

 

[Dr. Jayanthi Sankaran]

I did a lot of SAS during my PhD. But that was years back! It is fantastic - good luck!!