In-Depth

MCDBA

Premier title for SQL Server database administrators.

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.

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/.

Featured