MCDBA and MCITP(DBA)

[Alcar]

I am looking to start my journey for these 2 certifications.

I have been working in IT and with SQL dbs for 10 years now and I was wondering if there is anyone who has taken these two certifications and can share their opinion on it.

I am also curious to really identify the differences between the MCITP-Database Administrator and the MCITP-Database Developer.



Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.

 

[mrdenny]

I've got both certs. What are you looking to know?

The MCITP dbadmin handles setting up and planning the SQL Server it self. The MITP dbdev handles actually writting the T/SQL code.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Alcar]

I would guess that there is a good amount of T/SQL scripting that yu can do to vetter administer your SQL environment...

I am looking to get the SQL2000 MCDBA, simply because it's what I have mostly used all these years and that is what we currently have at my workplace. I am keeping an eye on 2005 but I hardly played enough with it to say that I know the differences.
I noticed only courses for SQL2000 for the MCDBA and not 2005... ???
How did you find the courses to be like? Anything out of the ordinary?
I am going to choose the self-paced path and I am currently getting the suggested books from MS.

Have these two certs helped any with your professional advancement?

Thanks in advance =)

Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.

 

[Skittle]

I am in the UK and have found that training companies have been slow to provide the SQL 2005 certifications so far.
Many of the CBT companies have not yet added SQL 2005 certification paths either. I guess it's just a matter of time.

I did the MCDBA mostly via self study and a set of books.
I used the Sybex books for 70-228 and 70-229 and found they matched my style of learning. more importantly, the knowledge has stayed with me. Took me about 18 months. I'm now working on the MCTS with a view to eventually getting the MCITP Database Administrator.

There certainly are differences between 2000 and 2005 as you would expect. There is however a great deal of stuff that hasn't really changed.

With regard to career advancement I would say it has helped me. I am a legacy system green screen AS400 guy who recognised a few years ago I needed to upgrade my skills or become extinct. I had done a little work with SQL server and it is an area I have a responsibility for in my current role so I decided to expand on it as a future career path. I certainly feel my studies have been successful in making me much more valuable to me employeer and have enpowered me to play a part in many projects I would other wise have struggled with. In regard to a new job somewhere, I've found agencies like the certification and more and more jobs in the UK tend to mention it. For me though the MCDBA is a means to and end - a way of learning a skill set I hope will lead to position when my current one withers away. I am much more confident I will now be able to stay in IT if my current employeer of 10+ years does not have a role for me when our AS400 is scrapped next year.



MCDBA (2000), MCAD.NET

Dazed and confused

 

[bjb123]

How soon before the MCDBA 2000 track is discontinued?

 

[mrdenny]

It will be a while. Probably not until support for SQL 2000 goes away. I'm sure it will be around for at least a year. (That is just a guess though.)

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[IT4EVR]

It's my understanding that Microsoft publishes those exams slated to be retired on June 1 of each year. MS usually posts this notice one year before the exam is retired. Which means that the SQL Server 2000 exams will live at least until 18 months from now.

I've heard a lot of people say to forget about the SQL 2000 exams and just go for the 2005. But common sense tells me that most businesses will be using SQL Server 2000 until Microsoft decides to drop support of it, which would probably be a year or two after the exam is retired.