• Charlie,

    The 2779 (Implementing) will go over many of the new services available within SQL2005 as compared to SQL2000, and will also talk about the programming objects. The 2780 (Administering) will touch on the features in the back end such as backup / restore, tuning, etc. If you are NOT going to be writing T-SQL code, I would focus on the Administration class, as the Implementation class deals mostly with coding issues.

    Also, I will be very honest with you, many of the Microsoft instructors do not have any real world experience. I teach these classes for Microsoft's largest training partner, and have been an active professional DBA. I recommend that you find a Certified Partner that has an instructor that's "been there, done that".

    Rich