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