Finding a Good Class or Book to Learn Intermediate SQL Concepts

[Melagan]

Greetings,

Thanks to all of you wonderful posters at tek-tips, I have found myself in a much more advanced state of competence with SQL and VBA. I am very interested in increasing my knowledge further! My overall goal with this thread is to find out a good place to start; there are some classes available in my area but most are not too flexible with those who already have somewhat demanding schedules. Perhaps there are some good online alternatives, or good books?
Additionally, in looking for a class (realtime/online) or published learning material, what are key topics you feel need to be covered in a beginning ~ intermediate type of scope?
The things I'm keeping my eyes out for are: Relational Database concepts, Database Normalization, SQL Statement composition and syntax, indexing, etc.

Any advice you can give to this novice but ambitious programmer would be greatly appreciated!

P.S. I'm also looking for the same sort of things to use with VBA / Visual Basic 6.0 =)


~Melagan
______
"It's never too late to become what you might have been.

 

[r937]

many good resources linked here -- SQL Links

r937.com | rudy.ca

 

[dhookom]

Check out these recommendations from John Viescas

http://www.viescas.com/Info/books.htm#Database Design.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Melagan]

Does anyone know either if or how compatible JetSQL is with PHP? Almost everything I see references MySQL and PHP together, not JET (MS Access). I've heard that MySQL is almost all-around better than Access; but I'm more familiar with Access and would rather use that as a neutral ground when trying to learn HTML and PHP. I'm not looking to do anything other than personal projects for the time being anyway; nothing professional yet, so please keep that in mind with your responses. Thank you!


~Melagan
______
"It's never too late to become what you might have been.

 

[dhookom]

Access should be just fine working with PHP for personal use. If you want to put something on the web with lots of concurrent users, MySQL (or other client-server database) is recommended.

You might want to Google [blue]PHP with MS Access[/blue] or even check out some other fora in Tek-Tips.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[chillay]

Introduction to SQL" is a great online course that covers intro to advanced SQL. Two fabulous books are following: SQL for Microsoft Access and SQL Simplified.

For the course:

Go here

http://www.jaffainc.com/IntroToSQL.htm

or you can find it at the following site

http://www.ed2go.com

Chillay

 

[r937]

chillay, you forgot to mention the fee that is required for that course



r937.com | rudy.ca