SQL Server 2005 Training Classes

  • Our company is looking at finally making 'the move' to 2005 upgrading from 2000. We are looking at taking a training class to familiarize ourselves with the new look and features in 2005. I'm interesting in hearing from the community as to which classes they may have taken that they felt were beneficial to them.

    thanks in advance...

  • I think it depends on what you are trying to learn. Ss2K5 is so wide, so many parts, that I don't think you can cover the entire product in a class. It would be multiple ones. SSIS needs a week or two on it's own.

    I'm part owner of End to End Training in Florida (www.endtoendtraining.com) and we've had great feedback on our classes. We don't have one specifcially on this, but we have an admin class and we've experimented with a one on one mentoring class that might suit you. Contact my partners from the site if you're interested.

    Solid Quality Mentors and SQLSkills would be other companies I'd recommend.

  • Well right now we do pretty much everything except for the administration of the server. We are responsible for creating the databases, DTS packages, cubes and reports. I guess that we're looking for something that touches on each of these aspects to familiarize ourselves with the product before we go live with it.

    Would you say that the biggest change from 2000 to 2005 would be SSIS?

  • I found Itzik Ben Gan's course on advanced TSQL very helpful. He covered all the new TSQL functionality in great depth. He's from Solid Quality Mentors.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Prep for the 70-431 certification exam with a good book and build a test environment. The cert requirements touch on a bit of everything and is a good overview. I'm on 2000 and have been following this procedure for about a month now. I feel comfortable with 2005 and wouldn't have a problem migrating any of my db's from 2000. Unfortunately I have to wait on my 3rd party app's guys to make the commitment.

  • Yeah, One of the classes that we were looking at from a local training company was Course 2780 - Maintaining a Microsoft SQL Server 2005 Database. Anyone have experience with training companies in the PA/MD area?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply