Wanted to learn SQL from scratch
Hi Experts,
I wanted to study SQL from scratch, Can you help me in this. As part of the new project I am using TOAD and lots of SQL scripts needs to make and learn.
Thx
Dil
I wanted to study SQL from scratch, Can you help me in this. As part of the new project I am using TOAD and lots of SQL scripts needs to make and learn.
Thx
Dil
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi all,
@ Dil,
1) you might know there's lots of tutorials out there on the net. So don't hesitate to search them yourself (just look for 'sql tutorial' on any search engine). Check a fex of them and use the one you understand the best. The w3schools is a good reference, but look for some others too... In order to learn something you always need at least 2 distinct sources of information...
2) some database editors like oracle and microsoft might add features to their databases that allow extra SQL commands that are not 'standard sql'. Check their documentations to know these commands. I know some docs might be tough for newbies, so begin with the tutorials on the net.
3) do you have a database on your computer ? If not, get one first (TOAD is only a tool to connect to the databases). As far as I know, you have free versions that are perfect to learn both at Oracle (if you wxant to go for Oracle or MySQL) and at Microsoft (if you want to go for SQL Server)...
--------------------------
@ wdfdo1986
I understand you want to help Dil, BUT :
1) You are not legally allowed to post books unless they are GNU licensed or similar.
2) The book you posted is subject to Copyright !
Cheers,
P
@ Dil,
1) you might know there's lots of tutorials out there on the net. So don't hesitate to search them yourself (just look for 'sql tutorial' on any search engine). Check a fex of them and use the one you understand the best. The w3schools is a good reference, but look for some others too... In order to learn something you always need at least 2 distinct sources of information...
2) some database editors like oracle and microsoft might add features to their databases that allow extra SQL commands that are not 'standard sql'. Check their documentations to know these commands. I know some docs might be tough for newbies, so begin with the tutorials on the net.
3) do you have a database on your computer ? If not, get one first (TOAD is only a tool to connect to the databases). As far as I know, you have free versions that are perfect to learn both at Oracle (if you wxant to go for Oracle or MySQL) and at Microsoft (if you want to go for SQL Server)...
--------------------------
@ wdfdo1986
I understand you want to help Dil, BUT :
1) You are not legally allowed to post books unless they are GNU licensed or similar.
2) The book you posted is subject to Copyright !
Cheers,
P
ASKER
Thx. Experts
http://www.w3schools.com/sql/default.asp
You can also buy books like http://www.amazon.com/Learning-SQL-Alan-Beaulieu/dp/0596007272