Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Which class to take


Which class to take

Author
Message
Charlie-120533
Charlie-120533
Mr or Mrs. 500
Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)

Group: General Forum Members
Points: 503 Visits: 3927
Good Morning

I have a few questions regarding training. We are going to wait to migrate to SQL Server 2008. I
was looking at training and I'm having a difficult time choosing what class to take. I am looking
at the SQL 2005 courses and trying to decide between 1) Maintaining a Microsoft SQL Server 2005
Database - Course 2780 and 2) Implementing a Microsoft SQL Server 2005 Database - Course 2779.

I will wait until these classes are available for SQL 2008, but I am wondering what the difference
is between these two classes. I have only one shot at the training and I want to get the most out of it.

History - I have been working with SQL 7, 2000, and am playing with 2005 Express for eight plus years. I am familiar with the basics and I know enough TSQL to get by. (I need to learn more!) We do not design databases here, but we are going to move eight instances over to a new server. I believe they want to use SQL 2008, and we are currently using SQL 2000.

Can anyone explain the differences between these two classes or could recommend another class to take?

I appreciate any help you can offer.

Regards,
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: Administrators
Points: 49058 Visits: 18997
I'm not sure about either of those courses directly, but it does seem that the MS courses teach more to the exam than than the real world. If you have a dollar allocation, I'd look for a third party trainer to help you. (disclosure, I own part of End to End Training).

If it's a contract with a local trainer, and you have to use them, I'd pick the more advanced one.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Charlie-120533
Charlie-120533
Mr or Mrs. 500
Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)

Group: General Forum Members
Points: 503 Visits: 3927
Thanks, Steve. Actually, the school is AUM - Auburn University, Montgomery, Alabama Technicenter. It's a certified Microsoft training center. My experiences with these is that they "Read the Book" to you in class. As you mentioned, no real world training which is what I'm looking for. Not too much to choose from here. Most of the certified Microsoft training is the same. At lease the instructor is there to answer a few questions, but it's not customized for you.
Source-NH
Source-NH
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1681 Visits: 479
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
Charlie-120533
Charlie-120533
Mr or Mrs. 500
Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)

Group: General Forum Members
Points: 503 Visits: 3927
Thanks, Rich. That's what I was looking for. Even though I won't primarily be programming, I'm the only one here who does the queries. I believe that the 2779 Implementing is what I'm looking for - the new stuff. I need information on SSIS, (creating DTS packages, etc.) which I don't have access to in the 2005 Express version. I'll wait to see what the equivalent classes will be for 2008.

I appreciate the input. Thanks,
Key DBA
Key DBA
Say Hey Kid
Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)Say Hey Kid (695 reputation)

Group: General Forum Members
Points: 695 Visits: 655
Charlie,

For the Certification process for SQL Server 2005, your first step to pass one exam to get you the MCTS: SQL Server 2005.

--

For Classroom training, you will need 2 courses:

Course 2779: Implementing a Microsoft SQL Server 2005 Database

and
Course 2780: Maintaining a Microsoft SQL Server 2005 Database

--

The exam you need to pass is:

Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

--

There is a handy breakdown located here:

MCTS: SQL Server 2005 Certification Requirements
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx

--

After you gain your MCTS: SQL Server 2005 you will most likely want to attain the next level of Certification, which is the MCITP "rank". For SQL Server there are two tracks. One for SQL Server 2005 DBA skills, and one for SQL Server 2005 Developer skills. Each track has a requirement of a total of 3 exams.

Note that the Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance is a prerequisite for both tracks, meaning that you are 1/3 on your way to MCITP certification by passing the 70-431 exam.


See the links below for more details about each track:

MCITP: Database Administrator
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx

--

MCITP: Database Developer Certification
http://www.microsoft.com/learning/mcp/mcitp/dbdev/default.mspx

--

I would be more than happy to discuss the whole certification process in more detail, and can make (legal) recommendations about self-study or other materials that will help you with the foundation of knowledge you will need to master the topics covered for the exams.

Best of luck with your studies and keep us posted on your progress.

Best Regards,

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search