Any Good SQL Server Intermediate Training Courses?

Quick question. I am in the NYC area (Westchester) and I am using Cognos DecisionStream to build my SQL Server 2000 Enterprise Data Warehouse.

I want to learn more about complex SQL, specifically for SQL Server.

What do you reccommend? Should I go for strictly an advanced SQL course, or should I go for SQL Server training.

Does anyone know of a really good site where I can find Advanced SQL training?

Also, I want to learn more about scripting and VB. Can anyone reccommend a place where I can get this beginner training.

Sorry to take up your time, but to sum up:

1. Advanced SQL training in NYC area
2. Beginner VB training in NYC area.

Cost is not necessarily an issue.

Thanks!You are asking for recommendations, which mean you want other people's opinions. I've always got at least one of those to spare!

For VB and Microsoft SQL Server, I'd recomment Quilogy (http://www.quilogy.com/). in my opinion, Alan Groh is one of the best teacher/mentor types in the business.

For the really, really interesting SQL, I'd recomment Joe Celko (http://www.celko.com/). Joe was on the committee that defined what SQL ought to do, and he has been a consultant for years teaching and helping folks figure out just what the existing SQL engines really do, especially when that deviates from the standard. If nothing else, he's fun to listen to when he discovers a new "feature" in one of the SQL dialects!

-PatP|||Thank you very much, I will look them up! I really appreciate it!|||Logon to these forums daily and look at what people are asking and try to figure the problems out...

kinda like a pop quiz every day...

Oh and read the solutions...

Do you have access to sql server and client side tools?

What do you consider "complex sql" to be?

Theta joins always give me a moment to pause...|||I consider complex SQL to be anything other than the simple select statement, like sub-queries, and transformation/alterations on fields like date conversions, etc.

Do you suggest any books with good amounts of source code and puzzles, that is up to date?|||Yeah...Celko's SQL for Smarties should blow your mind...it's not really platform specific

Ken Hendersons Book The Guru's Guids to SQL Server, Stored Procedures, XML and HTML is, and it's outstanding...AND comes with a cd loaded with code...

And there's also

http://www.sqlteam.com/store.asp