Learning SQL

[HiTekRedNek]

Hi,

I would like to hear some suggestions regarding the best way to learn SQL. I am not from a programming background but I know a bit of VBScript for systems administration purposes. I own Office 2007 and use Access and Excel. I know Access has alot of SQL functionality but I have never used it. I was wondering if I could learn by doing a project within Access or should I just start by installing SQL Server Express 2008 and jump right in. I've also heard about people using Access as a front end to a SQL database. I'm thinking maybe I could learn by importing my access data into SQL but I am not sure where to begin.
Does it help if I am well versed in VBA before learning SQL?
I value all recommendations on resources, books and tips on projects that I could start out with.
BTW: This forum rocks!.

 

[namliam]

Start by making a 'normal' query in design view then changing that view to "SQL" and see what it does.

Not always the best solution but a place to start anyways.

 

[HiTekRedNek]

Start by making a 'normal' query in design view then changing that view to "SQL" and see what it does.

Not always the best solution but a place to start anyways.

Thanks for the idea. Do you know of a good cross reference link or resource that has a thorough but easily explained summary of how to use all the statements and how to construct them?

 

[mclifford82]

I've always found w3schools to be a good introduction to SQL.

http://www.w3schools.com/sql/default.asp