SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


MCDBA Vs MCITP which is better???


MCDBA Vs MCITP which is better???

Author
Message
aravind-305595
aravind-305595
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1183 Visits: 119

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


Russel Loski
Russel Loski
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6109 Visits: 8935

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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (650K reputation)SSC Guru (650K reputation)SSC Guru (650K reputation)SSC Guru (650K reputation)SSC Guru (650K reputation)SSC Guru (650K reputation)SSC Guru (650K reputation)SSC Guru (650K reputation)

Group: Administrators
Points: 650165 Visits: 21472
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.

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
Frances L
Frances L
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4289 Visits: 299
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.
Brandie Tarvin
Brandie Tarvin
SSC Guru
SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)

Group: General Forum Members
Points: 164280 Visits: 9884

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/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.
NULLgarity
NULLgarity
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1414 Visits: 539
When it comes to certifications, latest == greatest

Twitter | LinkedIn


sqlstar2011
sqlstar2011
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5492 Visits: 626
I would either go with MCITP of MCTS.
Richard Josey
Richard Josey
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1026 Visits: 26
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.
Eddie Wuerch
Eddie Wuerch
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11428 Visits: 3387

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

Dan Kaufman
Dan Kaufman
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 1
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
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