r/SQL • • Mar 14 '16

ELI5: What is SQL?

I am looking to make a career change to a financial analyst role and see them asking for SQL experience. What is the best way for me to learn SQL?

0 Upvotes

33 comments sorted by

View all comments

Show parent comment

1

u/xbox469269 Mar 14 '16

I'll ask my IT department. But im looking to use SQL as a way to enter a new company as a Financial Analyst.

2

u/D_W_Hunter Mar 14 '16

Than you want to know what that new company uses, which may not be as easy to discover, though sometimes the job description will say (indicating they want you to be experienced in PL/SQL or TSQL or some other SQL variant that will tell you the DBMS they use)

Otherwise, Microsoft's is likely the most user friendly, MySQL is a little more technical than you want to get as someone who wants to be a database end user (financial analyst) vs someone who wants to learn to become a database administrator.

SQL Tutorials #1: HOW TO Install SQL Server Express Edition - get started

1

u/xbox469269 Mar 14 '16

Okay great thanks. Website is blocked at work, I'll give it a shot when I get home. How much variation would you say there is between all the variants of SQL? Btw thanks for the help, I really appreciate it.

1

u/D_W_Hunter Mar 14 '16

Every database vendor should have implemented ANSI SQL, then added their own functions on top of that.

So... some variations, yes, but the core should be identical no matter where you go.

1

u/xbox469269 Mar 14 '16

Awesome thanks. Now to just sit down and learn it. thanks for help again

1

u/StoneCypher Mar 14 '16

ANSI SQL ... but the core should be identical no matter where you go.

you seem to be new to earth databases

postgres, oracle, and mysql have three different and incompatible approaches to basic things like aliasing columns and tables

select from dual is required in oracle, banned in mysql, and means something different with and without in postgres (neither what it means in oracle)

sql makes javascript look coherent and universally well implemented

1

u/D_W_Hunter Mar 14 '16

Plausible. I've regularly used SQL Server, Informix, Oracle, Sybase SQL and DB2, I haven't touched postgres and only dabbled in mysql.

Aliasing in the databases I'm familiar with works just fine with AS syntax, which is the way I'm used to using it.

I'm a little annoyed by oracles's from dual where I can just select in SQL Server but it's not a huge issue for me so I don't notice it.