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

Any advice on testing Data Warehouse solution?

We are looking at deploying a data warehouse solution soon that has been
being developed for a few months. The development team has been working on
developing this for the company. Soon they will be turning this over to the
DBA group to do some level of integration testing with the rest of our
production data.
What guidelines are there for testing data warehouse solutions?
What types of things should I be looking for other than user sign off that
the data looks good?Function test of Backup/restore of full data size
Performance/Load testing of full data size
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Doug Needham" <dneedham@.cfsloans.com> wrote in message
news:eqTaIH3xDHA.2148@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We are looking at deploying a data warehouse solution soon that has been
> being developed for a few months. The development team has been working on
> developing this for the company. Soon they will be turning this over to

---

the

quote:

---

> DBA group to do some level of integration testing with the rest of our
> production data.
> What guidelines are there for testing data warehouse solutions?
> What types of things should I be looking for other than user sign off that
> the data looks good?
>
>

---