What is the best way to learn SQL? 2

[kmarr]

I know, it's a broad question. Locally, the community college and tek.school don't offer classes in this. I am reading what I can find and learning VERY slowly. Eventually I will make it but are there any tips on how to accelerate learning?

Thanks a lot!

Ken

 

[GHolden]

Hi,

There is a very good tutorial here...

http://sqlcourse.com/

There are tests and an online database and sql interpreter to check your answers.


There are two ways to write error-free programs; only the third one works.

 

[SkipVought]

Ken,

In addition to tutorials and books, get a database application like MS Access that has a GUI Query Design Facility.

Construct queries of various types in hte QBE Grid and then VIEW the SQL.

You can modify the SQL directly. Some queries cannot be graphically represented in the QBE Grid and MUST be coded directly.

The journey of one thousand miles begins with the first step.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Golom]

There are also sites like Rudy Limeback's (see below) where real experts like Rudy provide answers to questions about SQL and provide complete descriptions of various aspects of advanced SQL topics.

http://www.r937.com/

 

[lespaul]

Here's another good site:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Leslie