Resources for learning SQL 2

[Eldaria]

Anyone know where I can find Resources for learingn to build SQL, I have figured the idea behind the SELECT FROM WHERE etc, but all the other is still unknown for me, I would like to be able to build SQL querys for my code, without having to open the query builder then build the Query, chnge to SQL view, and copy it.
And it would be nice to generaly learn SQL.
Also is there some kind of Developer SQL server, like there is Personal Web server, that can handle ASP, so that you don't need IIS for that. does there exist a similar product for SQL?
Eldaria

http://www.eldaria.net

That was my 25cent** of opinion.

** Inclusive Intrest, tax on interest, Genral tax, Enviromental tax, Tax, and tax on intrest, tax on fees, tax on tax, and other Various taxes and fees.

 

[cjashwell]

I found a great place to learn the basics of SQL is

http://www.sqlcourse.com/

which includes an interactive SQL interpreter. There are also many good books on the subject, including SAMS 'Teach Yourself SQL in 24 Hours'. Bear in mind that the Jet SQL employed by Access is not standard. Nevertheless, learn standard SQL and you'll find life a lot easier.

Hope this helps

 

[Eldaria]

Cool, this site gives the Solution to both questions, Brilliant...
Eldaria

http://www.eldaria.net

That was my 25cent** of opinion.

** Inclusive Intrest, tax on interest, Genral tax, Enviromental tax, Tax, and tax on intrest, tax on fees, tax on tax, and other Various taxes and fees.

 

[tlbroadbent]

A quick search of Tek-Tips would have lead you to the following FAQs which discuss SQL training resources.

Access SQL forum:
faq701-721 - What Help is Available for Developers at Microsoft.com

Links in this FAQ includes:
Fundamental Microsoft Jet SQL for Access 2000
Intermediate Microsoft Jet SQL for Access 2000
Advanced Microsoft Jet SQL for Access 2000

SQL Server forum:
faq183-513 - SQL Websites
faq183-694 - Where can I find training/tutorials for SQL and T-SQL?

Links in these FAQs include:
Online Book: Teach Yourself SQL in 21 Days, 2nd Edition
SQL Course and SQL Course 2 provide a tutorial in ANSI SQL Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Eldaria]

Ok, I know, I was a little to fast to ask the question, before searcing.
But see, now i got even more info.
Eldaria

http://www.eldaria.net

That was my 25cent** of opinion.

** Inclusive Intrest, tax on interest, Genral tax, Enviromental tax, Tax, and tax on intrest, tax on fees, tax on tax, and other Various taxes and fees.