Microsoft Certified Professional Magazine OnlineFriday: February 25, 2005 - 20:50 PST
Microsoft Certified Professional Magazine Online
About Us | Subscribe to Redmond | Tech Library | Get Newsletters:
MANAGING THE WINDOWS®  NETWORK
MCPmag.com via RSS
 

 
Partner Showcase
Get a free "Extend This" t-shirt today!.
 
FREE MAGAZINE SUBSCRIPTION
Get a Free Subscribtion to Redmond magazine in Print or Digital Format!



See What's New on Redmondmag.com!
Cover Story: Q & A with Microsoft's Jeff Raikes
Real-World GPMC Troubleshooting
The 10 Essential Rules of Patch Management
Beta Man: Windows Server 2003 SP1
Product Review: Microsoft Operations Manager 2005
 



  -- advertisement --
Traveling to a
Tradeshow or Event?
Leeds Hotels
Mount Ommaney Hotels
Pajara Hotels
Wotton Under Edge Hotels
Abrantes Hotels
Kelso Hotels
Lenk Hotels
Beaucouze Hotels
Alaquas Hotels
Milwaukee Hotels

... Home ... Cert Basics ... Certification Articles

MCDBA

Premier title for SQL Server database administrators.

send e-mail link to article SEND  print article PRINT 
June 2001

MCDBA Microsoft Certified Database Administrator is a premier certification for those who want to prove expertise in implementing and administering Microsoft SQL Server. More specifically: developing physical database designs and logical data models; creating physical databases; creating data services by using Transact-SQL; managing and maintaining databases; configuring and managing security; monitoring and optimizing databases; and installing and configuring SQL Server.

IT professionals who hold titles such as database administrator, database analyst, or database developer are candidates for the MCDBA. Microsoft recommends at least one year of hands-on experience with SQL Server for those contemplating taking exams for the MCDBA.

-- advertisement --

The Benefits
MCDBA titleholders receive the following benefits upon fulfillment of the requirements:

  • Industry recognition of your expertise.
  • The right to use the MCDBA logo on business collateral.
  • A certificate, transcript, wallet card, and lapel pin to identify you as an MCDBA to colleagues and clients.
  • Access to technical and product information direct from Microsoft through the private, secure MCP Web site.
  • Discounts on products and services (such as reduced price on one-year TechNet or TechNet Plus subscription during first year of certification, and discounted MSDN subscription).
  • One-year free subscription to SQL Server Magazine.
  • Invitations to Microsoft and MCP Magazine TechMentor conferences, technical training sessions, and special events.

The Tests
The certification requires you to pass three core exams and one elective, as shown in the following table:

Core Exams: SQL Server Administration
(pass 1)

70-228, Installing, Configuring, and Administering SQL Server 2000 Enterprise

70-028, Administering SQL Server 7.0
Core Exams: SQL Server Design (pass 1)

70-229, Designing, Implementing Databases with SQL Server 2000 Enterprise

70-029, Designing, Implementing Databases with SQL Server 7.0
Core Exams: Networking Systems (pass 1)
70-290, Managing, Maintaining Windows Server 2003
70-291, Implementing, Managing, Maintaining a Windows Server 2003 Network Infrastructure
70-215, Installing, Configuring, Administering Windows 2000 Server
Elective Exams (pass 1)
70-216, Implementing, Administering a Windows 2000 Network Infrastructure
70-293, Planning, Maintaining a Windows Server 2003 Network Infrastructure
70-305, Developing, Implementing Web Applications with Visual Basic .NET and Visual Studio .NET
70-306, Developing, Implementing Windows-based Applications with Visual Basic .NET and Microsoft Visual Studio .NET
70-310, Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
70-315, Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
70-316, Developing, Implementing Windows-based Applications with Visual C# .NET and Visual Studio .NET
70-320, Developing XML Web Services, Server Components with Visual C# and .NET Framework
70-015, Designing and Implementing Distributed Applications with Microsoft Visual C++® 6.0
70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0
70-155, Designing, Implementing Distributed Applications with Visual FoxPro 6.0
70-175, Designing, Implementing Distributed Applications with Visual Basic 6.0

Note: If you had the opportunity to take and pass Exam 70-240, the Accelerated Exam for Windows 2000, you need only take one more Core: Admin (70-028 or 70-228) and one more Core: Design (70-029 or 70-229) to fulfill the MCDBA requirements. More information on all these exams can be found in the table below.

Tests are delivered through Prometric and VUE are the exclusive test providers for these and all Microsoft exams.

Microsoft frequently updates requirements information. For the most recent changes, be sure to view Microsoft's official MCDBA requirements page at http://www.microsoft.com/learning/mcp/mcdba/end article

You can contact the editors about MCDBA at editor@mcpmag.com.
send e-mail link to article SEND  print article PRINT 



...readTESTS TO ACHIEVE MCDBA

See MCP Newsflash (no exams in beta yet) (Beta)

70-019 Designing SQL Server 7.0 Data Warehouses (Live)

70-028 Administering SQL Server 7.0 (Live)

70-029 Designing SQL Server 7.0 Databases (Live)

70-086 Supporting SMS 2.0 (Live)

70-088 Supporting Proxy Server 2.0 (Live)

70-215 Administering Windows 2000 Server (Live)

70-228 Administering SQL Server 2000 (Live)

70-229 Designing SQL Server 2000 Databases (Live)

70-290 Manage/Maintain Windows Server 2003 (Live)

70-291 Impl./Manage/Maintain Windows Server 2003 Network (Live)

70-292 Manage/Maintain Windows 2003 (for MCSA-Win2K) (Live)

70-293 Plan/Maintain a Windows Server 2003 Network (Live)

70-294 Planning, Implementing, Maintaining Windows Server 2003 AD (Live)

70-296 Plan/Impl./Maintain Windows Server 2003 (for MCSE - Win2K) (Live)

70-297 Designing Windows Server 2003 AD, Network (Live)

70-298 Designing Security for a Windows Server 2003 Network (Live)

70-305 Developing Web Apps with VB .NET/VS .NET (Live)

70-306 Developing Windows Apps with VB .NET/VS .NET (Live)

70-310 Developing XML/WS with VB .NET/.NET Framework (Live)

70-315 Developing Web Apps with Visual C# .NET/VS .NET (Live)

70-316 Developing Windows Apps with VC# .NET/VS .NET (Live)

70-320 Developing XML/WS with VC# .NET/.NET Framework (Live)

70-026 Administering SQL Server 6.5 (Retired)

70-027 Designing SQL Server 6.5 Databases (Retired)

70-240 Windows 2000 Accelerated (Retired)


Find More Exams:
...read Select a Certification or Test from the Exam Guide:

...read MCP BY THE NUMBERS
MCP 963,606
MCSA-W2K 104,703
MCSA-W2003 11,314
MCSA:Messaging 15,499
MCSA:Security 2,091
MCSE-NT 394,807
MCSE-W2K 244,153
MCSE-W2003 5,604
MCSE:Messaging 3,082
MCSE:Security 2,505
MCDBA 122,586
MCAD.NET 15,769
MCSD 45,150
MCSD 7,744
MCP+I 229,139
MCP+SB 2,040
MCSE+I 12,456
Total: 2,182,248

Numbers indicate total certifications per title as of April 14, 2004.

Courtesy of Microsoft Corp.


...read NEWS

MCSE: Security Tops 4,000 2/24/05

Exams Under the Radar: Licensing Solutions 2/23/05

Partner Up on XP Exam 2/15/05

New Certification for Administrative Scripters 2/9/05

New Twist to Exams: Just Do It 2/1/05

Windows, SBS OEMs Get Competency Exam 1/27/05

Microsoft Names New MVPs for 2005 1/21/05

New BizTalk Competency Exam Debuts 1/20/05

CompTIA Lets IT Academy Students Take A+ Exams for $99 1/17/05

New Exams Target Competencies 12/14/04

...read NEWS ARCHIVE



The New TechMentor Register Early and Save!
  • 6 New Tracks
  • Focused Training
  • Exam Discounts
    Register by
    March 4th and
    save $200
    off the new TechMentor!

    TOP

    Sponsored Links

    Shed light on your Active Directory: Get a free flashlight.

    Learn online or learn in person: With Citrix Education, the choice is yours.

    Learn More About: IBM DB2 Information Management

    FREE Download: Powerful Windows and UNIX Batch Job Scheduling

    Enter Crypto Challenge VII and win a Mac Mini: Brought to you by thawte

    Cert Tracks MCDST, MCSA, MCSE: Only at TechMentor: April 4-8

    FREE MCSE: Register to win free admission to our MCSE Boot Camp

    New: Microsoft® Visual Studio® .NET 2003 Professional Special Edition

    KEEP IT COMING: Renew Redmond magazine in Print or PDF

    Free HP White Papers: for the IT Manager Download NOW!




    Home | Subscribe/Renew | About Us | Contributors | 2004 Media Kit | Tech Library | RSS Feeds  RSS Feeds from MCPmag.com
    Issue Archive | Certification/Careers | Chats | Columns | Current Issue | Exam Guide | Events | Features | Forums
    MCP Database | MCP Radio | News | Poll | Tech Portals | Press Releases | Reviews | Salary Surveys | Search | Site Map
    For more information, e-mail editor@mcpmag.com.
    Application Development Trends | Campus Technology | CertCities.com | The Data Warehousing Institute | E-Gov | ENT News
    Enterprise Systems | Federal Computer Week | IT Compliance Institute | JavaSPEKTRUM | MCP TechMentor Conferences
    MCPmag.com | OBJEKTspektrum | Recharger | Redmond magazine | SIGS-DATACOM | TCPmag.com
    Copyright 1996-2005 101communications. See our Privacy Policy.
    101communications
    .