What is the best source to learn about SQL

I have been learning a lot about setting up websites. The programs I am using seem to keep getting more complicated. I need a good source for learning SQL, You can reccomend anything. Book, website even if you are selling an ebook. Please let me know.

 

The best way is to install it on your local machine and play with it, all SQL queries very simple and easy to learn quickly
The most basic SQL commands are -
SELECT
INSERT
UPDATE
MODIFY


Hope this helps you

Regards,
R

 

Thanks, I use godaddy so it sets it up for me but if I need to change anything then it is hard to figure out

 

Hi,

Here are two things you have to consider, database structure and database records.
I think you should have received a Control Panel from godaddy using.
You can create databases, its user from this control panel.
But you can not manage tables, records through this control panel.
SQL server management studio allows you to connect the database remotely, create tables in it, insert records in tables etc.
Let me know if you have any queries or difficulties to manage/modify the database

Regards,
R

 

Thank you, I wil pm you if I have any question. One again grateful for your help.

 

I would just do queries in HeidiSQL (free), or phpMYAdmin, or even SQLBuddy (all free). To practice.
Id also suggest reading Simply SQL by Rudy Limeback, great book I have it also.

 

I've learned web programming from scratch and database from this website : tizag.com

 

Try books from amazon.com

 

I once come across SQL in learning Access. You can have a try~

 

It is good to learn fisrt

select
insert
update
delete

then where clause , group functions, having clause , join conditions etc


But I recoment you to follow good sql book , there are lot of sql book in shops

I learned sql from Oracle's course, that is really good , you can study the concepts well

 

Yeah thats true markup

Syntax of Oracle and sql are almost same.
but yes, select, insert, update, delete these are the basics of database servers and then you can go into deep for jois, hash etc.

Regards,
R

 

Thanks for everyones input. I will probably buy a book on it. That way I can just reference it when needed.

 

hi...

there is simple website guide as in simple way to learn sql and oracle .... chk dba17.com

simple to learn.... i think 2 days is enough to learn sql.

 

W3Schools is also one of the good source for reading about SQL...!!

 

with hostgator i have been using phpmyadmin i've learned to add tables on my own .. but i learn most of the things i know on my own.. i recommend making a BS database and messing around with it... with the help of w3schools that is! =]

 

You want to learn about the SQL. SQL is used to communicate with a database.SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. The standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. And if you want to learn about the SQL through website is http://sqlcourse.com/intro.html