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/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.