tell me about SQL?

[Crazy Fool]

Hi

I’m just starting a new job and I will be using SQL, I have no idea what this is to tell the truth and although I will be given full training, can anyone sum it up for me in a simple format? Pretty please with sugar on top!!

and what about versions has there been many and what is the latest and so on?

[TiG]

SQL is standard query language, its the language you query databases with.
SQL is a true standard, however no-one actually uses it.
MS SQL server 2000 uses T-SQL, Oracle uses PL-SQL and other projects use their own versions of it.

It truely depends on which database you will be using.

And in terms of a development skill, easy to pick up, flipping difficult to master in my opinion.

TiG

[LWA]

Sorry Tig don't mean to be an ar*e, but SQL stands for Structured Query Language iirc.

I have experience in both standard sql and pl-sql and would definately agree with the 'easy to pick up, flipping difficult to master' statement.

If you are going to be given full training you will be fine.

[MrFlibble]

If you have to use it every day, you'll soon pick it up

[TiG]

LOL Big Leon, no problems, probably something to do with getting up at 4am, travelling nearly 250 miles up to Lancaster, and coming back after a 6hr meeting

if YOU know nothing of SQL and are interested in learning the "HISTORY"

here is a very good document to read..

SQL Standand....

Good for learning and understanding new SQL DB's you may have not dealt with before.

TiG

[DaBeeeenster]

SQL-92 is the standard. Most DB's manage to get fairly close to it. The problem is that most also extend it which is where the problems arise.

Agree with the above posters; very easy to grasp, very hard to master.