MCDBA Vs MCITP which is better???

  • I have been working with SQL Server 2000 for past 2 years. I was working with Programming side basically. I have worked on some DBA activities too.I have started working with SQL Server 2005.

    I have planned to do a certification. Which one will be better MCDBA or MCITP ????

    Please give me a suggestion

  • If you want to position yourself as a SQL 2000 guru, then maybe MCDBA better.  Also, MCDBA includes a Server operating system test the MCITP does have, which may interest some employers.  I'm a developer and that test was the first one I failed. And I failed it twice.  Also, if you have most of the MCDBA, I would finish it.

    However, if you are just starting or you are looking to the future, I would clearly vote one of the MCITP certs.  By the time you finish, SQL 2005 will be taking hold, so why not be certified with the most current?

    Russel Loski, MCSE Business Intelligence, Data Platform

  • The MCDBA is a SQL2K cert, as mentioned above. The MCITP is a 2005 cert. If you have experience with SLQ Server and Windows, I'd get the MCDBA as there will be lots of SQL 2K installs for awhile out there and it should be easier.

    As you start working with 2005, I'd look at the other cert.

  • I want to get my certification in MCDBA, too. If I prepare SQl2000, by the time, I finish all the test. It will be late 2007. I think at 2008 will be Microsoft will not support sQL 2000. so I do not know what I plan to do yet. I am reading the book since I do not have 2005 version in my company. I will like to listen to other people's opinion. Thx.

  • If you're going for the MCDBA cert, may I offer a piece of advice?

    There are (or were) two OS tests as part of the MCDBA.  Windows 2000 Server & Professional.  I don't know if MS has changed that to 2003 Server & XP or if it's still the same.  Regardless, whatever other order you may study for and take your SQL tests in, study for the Server OS test BEFORE you study for the PC OS test.  If you can get all the info for the Server OS test in your head (and understand it), then you should be able to pass BOTH tests with flying colors. 

    That's how it worked for me when I got my MCDBA.  I studied for the Server OS test before the PC OS test because I thought (rightly so) that the Server OS was going to be harder.  I passed both tests within a week of each other because the PC OS test had essentially the same things on it that the Server OS test did, only it was a lot less.  If you know what I mean.

    Anyway, I hope this advice helps out anyone going for the MCDBA.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • When it comes to certifications, latest == greatest

  • I would either go with MCITP of MCTS.

  • I would recommend the MCITP on the basis that it is more current and has less exams.

    If you can use 2005 you should be able to use 2000 due to the fact that it's functionality is largely a subset of 2005.

    If you work with 2005 regularly you should not have too many problems passing the exams.

    I passed them and have never used 2005 for any real work as we only use 2000 at present.

  • The only OS exam for MCDBA is Windows Server; no desktop exam is part of it.  The 2000 Pro or XP Pro could be used as an elective, but it's not a core requirement.

    While there isn't a separate OS requirement for MCITP: DBA, the exams really pile on top of the one Windows Server exam as part of the SQL exams, including networking, ISA Server, clustering, etc.  If you feel you can pass 70-228 and 70-229 in the next six months, and you are not primarily working with SQL Server 2005 right now, then MCDBA is a good warm up to MCITP.  There is an upgrade path.  Once you complete MCDBA, you can take one upgrade exam (70-447)instead of the two MCITP: DBA exams.  You still need to take the MCTS exam, but that's pretty tame after getting MCDBA and spending a little time with SQL 2005 BOL.

    However, if you are not already well on your way to SQL Server 2000 MCDBA, then you should consider spending your learning efforts and money on the current version.

    -Eddie

    Eddie Wuerch
    MCM: SQL

  • I am looking into taking one of those boot camp courses for MCITP. I am more likely able to get my company to send me to that than the MCDBA courses (14 days vs 6 days)

    We will not be upgrading to SQL2005 for a while, but I am currently doing lots of development and am concerned mostly with tuning/performance etc....

    My question is similar...Do most of the principles learned in the MCITP course apply to SQL 2000?

    Thanks,

    Dan

  • Yes,

    You will also pick up which are the new features and then get infuriated being unable to use them to solve problems

Viewing 11 posts - 1 through 10 (of 10 total)

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