RE: Certification to choose



I passed 70-229 in December 2006, and now the 70-431 is very hot. And I am
currently working on SQL Server 2005 as a junior developer. I am not sure
whether I should go for MCITP or MCDBA. And does anyone know which exams in
MCDBA and MCITP have simulation questions? I would like to know and prepare
well to before I go to exam.

"Derik Hinz" wrote:

When I got ready for the MCDBA exams I had a hard time finding quality
material to study from. I wasted a bunch of $ on Sybex which which turned
out to be of no help getting ready for the test. My two favorite DBA books
are:

"Professional SQL Server 2000 Programming" by Rob Vierira
"Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook" by
Ken England

The 2nd book gives an intense look at tunning and is not an easy read.

You will also benefit when it comes time to take the test from having used
some practice material like Transcender - those aren't cheap but, it will get
you used to the types of questions you are likely to see on the exam.


--
Derik Hinz
MCAD, MCDBA, MCITP, MCSA


"Vamsi Korrapati" wrote:

Derik Thanks for your suggestions. i have decided to go with MCDBA. please
can you suggest the good books for this?
--
Thanks,
Vamsi


"Derik Hinz" wrote:

If you are comfortable on SQL 2000 and consider the Enterprise Manager to be
an old friend then I would consider going MCDBA. MCITP is the "new
generation" cert that focuses on the SQL 2005 BI Development Studio.

If you do a lot of development you might want to get an MCAD which comes in
several flavors: C#.NET, VB.NET and WinApp or WebApp. Most if not all of the
MCAD courses will count as electives in your MCDBA program which I thought
was a plus. MCAD uses SQL Server heavily as it's preferred data store so you
have to know your way around the db to be sucessful.
--
Derik Hinz
MCAD, MCDBA, MCITP, MCSA


"Vamsi Korrapati" wrote:

I am working on Sql server 2000 for past 3 yrs and would like get some
certifications on this. i am using sql server 2000 as my back end and asp,
asp.net as front end. so i am working on developmemt. Please can any ons
suggest me the best way i can upgrade my knowledge and get the certification.
--
Thanks,
Vamsi
.



Relevant Pages

  • Re: Upgrade from MCDBA to MCPD
    ... You can update your MCDBA SQL Server 2000 to MCITP (SQL Server 2005 ... Database Administration) by taking two exams: ...
    (microsoft.public.cert.mcdba)
  • Re: user access to db
    ... rights on the SQL server? ... Warren Brunk - MCITP - SQL 2005, MCDBA ...
    (microsoft.public.sqlserver.security)
  • Need help to get certified on upgrading to MCITP MS SQL Server 200
    ... Can any one help me on how to go about the upgradation from MCDBA MS SQL ... Server 2000 to MCITP MS SQL Server 2008. ...
    (microsoft.public.cert.mcdba)
  • Re: MCDBA
    ... Some people seem to have MCDBA without knowing the basics of SQL ... history and references, and perhaps even your academic qualifications. ... Looking for a SQL Server replication book? ... > I am a sql server dba with more than 2 yrs of experience in managing ...
    (microsoft.public.sqlserver.server)
  • Re: How to Study for exam
    ... would like to obtain the MCDBA. ... The "MCDBA" is a SQL Server 2000 only certification. ... Microsoft MVP - Software Distribution ... MS WSUS Website: http://www.microsoft.com/wsus ...
    (microsoft.public.cert.mcdba)