Re: How to Study for exam

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



"Pete" <Pete@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5C49C76E-745E-4723-A12C-6405575CDE82@xxxxxxxxxxxxxxxx
At work I was moved into the tech unit with concentration in SQL 2005. I
would like to obtain the MCDBA. My question/concern is that with so much to
learn, what is the best path to take or how does one go about studying for
MCDBA.


The "MCDBA" is a SQL Server 2000 only certification.

http://www.microsoft.com/learning/mcp/mcdba/mcdba.mspx

and requires four exams (two on SQL Server 2000 one on Windows Server 2003, and an elective, either on Windows Server 2003 or Visual Studio .NET)


Since you're already assigned to a SQL 2005 environment, you'd probably be better served by pursuing the MCTS: SQL Server 2005.

http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx
http://www.microsoft.com/learning/en/us/exams/70-431.mspx

Following that introduction, then you'll have the decision whether your interest is more tuned to "Database Administration"

http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
http://www.microsoft.com/learning/en/us/exams/70-443.mspx
http://www.microsoft.com/learning/en/us/exams/70-444.mspx

or "Database Development"

http://www.microsoft.com/learning/mcp/mcitp/dbdev/default.mspx
http://www.microsoft.com/learning/en/us/exams/70-441.mspx
http://www.microsoft.com/learning/en/us/exams/70-442.mspx

--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Senior Data Architect, APQC, Houston, Texas
Microsoft MVP - Software Distribution (2005-2008)

MS WSUS Website: http://www.microsoft.com/wsus
My Websites: http://www.onsitechsolutions.com;
http://wsusinfo.onsitechsolutions.com
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin

.



Relevant Pages

  • RE: Certification to choose
    ... MCDBA and MCITP have simulation questions? ... "Professional SQL Server 2000 Programming" by Rob Vierira ... MCAD, MCDBA, MCITP, MCSA ...
    (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: SQL 2000
    ... I am a long time Network Administrator looking to change my career. ... been eyeing the MCDBA track. ... geting certified in SQL Server 2005 to improve your resume. ...
    (microsoft.public.cert.mcdba)
  • Re: HELP! VB.NET killed SQL Server
    ... > MCDBA, MCSD, MCP+SB ... Right now I desperately need SQL Server but not VB. ... and that may not even work because such a big install cannot be ...
    (microsoft.public.sqlserver.programming)
  • Re: Catalog of tables in an SSCE database
    ... William Vaughn ... Microsoft MVP ... Please reply only to the newsgroup so that others can benefit. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)