Question:
What is the best way to learn SQL?
Annie
2006-03-24 08:26:20 UTC
What is the best way to learn SQL?
Eight answers:
jskud
2006-03-24 08:41:21 UTC
The best way to learn SQL is by using it. The four basic things you need to know are Select, Insert, Update, and Delete.



SELECT [columns to select] FROM [table] [where] [order]



INSERT INTO [table] ([names of fields to insert]) VALUES ([values to insert into respective fields])



UPDATE [table] SET [field name 1]=[value 1], [field name 1]=[value 1] [where]



DELETE FROM [table] [where]





[table]-> the table you want to modify

[field or column name]-> the column in the table you want to modify

[where]-> tell which rows of the table to modify. Usually looks like "WHERE ID=1" or "WHERE ID like '%1%'" or "WHERE ID IN (1,2,3,4,5)"

[order]-> the order by clause tells how the values should be ordered. "ORDER BY Create_Date" or "ORDER BY Create_Date DESC"



That should get you started. Then look at Joins, nesting, etc. Good luck!!
Popocatepetl
2006-03-24 16:47:50 UTC
You can take a course, read a book or manuals, or even get the knowledge from friends.

But the experience is what will give you the hability to use all of the sentences, functions, and tools that SQL gives to you.

You have to live a project, be in touch with real needs, and solve the requirements of the software users in order to get the know-how to use this tool.

It's not really dificult, as a previous answer said, there are only a couple of basic sentences, start with a simple database as it would be even MS Acces, and after knowing the basics, you can go on learning more complex SQL languajes, as Transact SQL for MS SQL Server, or PL-SQL for Oracle Database.

Good luck.
uttoransen
2006-03-24 16:47:40 UTC
first understand the oracle, and have a good knowledge about the databases. and then try the sql, you will understand it better.
macausite
2006-03-24 16:34:10 UTC
Practice makes perfect
rumn8tr
2006-03-24 16:35:20 UTC
There's a nice tutorial at W3 Schools (see sources).
geethapmk
2006-03-24 16:53:43 UTC
first understand the quries.

it will make u simple to write the sql commands.



first understand the dml,ddl,tcl commands.learn wat r they.



then go throuth the syntax.. and see some examples ..



it will really help u i think ..

all the best.
ɹɐzɔ
2006-03-24 16:44:15 UTC
Practice, and a good web tutorial, like this:



http://www.sqlcourse.com/
speed8804
2006-03-25 16:31:31 UTC
http://www.w3schools.com/sql/default.asp...


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...