CTE Solutions chair
Quick Search:  
Savings
Got A Question?
Talk to an Educational Consultant and get the answers you need.

By Phone
Ottawa: 613-798-5353
Toronto: 416-284-2700
Toll Free: 866-635-5353

right arrow Ask your question online

MCDBA - Microsoft Certified Database Administrator

The Microsoft Certified Database Administrator (MCDBA) credential is the premier certification for professionals who can successfully implement and administer Microsoft SQL Server 2000 databases. The MCDBA credential designates you as a top-tier database administrator. The MCDBA certification is appropriate for individuals who perform the following job tasks:

  • Develop logical data models
  • Derive physical database designs
  • Create physical databases
  • Write queries using Transact-SQL
  • Install and configure Microsoft SQL Server
  • Configure and manage security
  • Manage and maintain databases
  • Monitor and optimize databases

MCDBA candidates typically have at least one year of experience working with SQL Server.

The comprehensive technology solution for mission-critical applications

SQL Server 2000 is a complete, Web-enabled database and data analysis package that facilitates the fast development of a new generation of enterprise-class business applications that can give your company a critical competitive advantage. SQL Server provides support for XML, querying across the Internet, and beyond the firewall.

The value of MCDBA certification

The MCDBA credential is one of the most widely recognized technical certifications in the industry. By earning the premier MCDBA credential, you will demonstrate that you have the skills necessary to lead organizations in the successful design, implementation, and administration of Microsoft SQL Server databases.

The value of MCDBA certification to IT professionals

The MCDBA credential formally recognizes your database administrator skills and enhances your status as a professional. The MCDBA credential formally communicates your technical skills to clients and employers. The MCDBA credential helps to pinpoint specific areas where knowledge gaps exist.

The value of MCDBA certification to hiring managers and organizations

  • The MCDBA credential provides a reliable benchmark for hiring and promotions by accurately assessing technical skills
  • The MCDBA credential helps to ensure that an organization is built on top-quality technical talent
  • The MCDBA credential maximizes training investments through validation of skills

Choose your path for MCDBA certification

MCDBA candidates will be required to pass three core exams and one elective exam. There are two core exams relating to SQL Server that are required, and a choice of one of the three Networking System exams to make up the final of the three required core exams.
Finally, pass one elective exam to complete the certification.


Core Exams (3 Exams Required)

To fulfill the core certification requirements, pass both SQL Server Adminstration and SQL Server Design.

  • Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
  • Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Then, pass one of the Networking System exams.

  • Exam 70-215: Installing, Configuring, and Administering Microsoft Windows 2000 Server
  • Exam 70-290: Managing and Maintaining a Microsoft Windows Server™ 2003 Environment
  • Exam 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

Elective Exams (1 Exams Required)

You must also pass one elective exam that provides proof of expertise with a specific Microsoft product.

  • Exam 70-216: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
  • Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
  • Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
  • Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
  • Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
  • Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
  • Exam 70-316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
  • Exam 70-320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework
  • Exam 70-015: Designing and Implementing Distributed Applications with Microsoft Visual C++® 6.0
  • Exam 70-019: Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0
  • Exam 70-155: Designing and Implementing Distributed Applications with Microsoft Visual FoxPro® 6.0
  • Exam 70-175: Designing and Implementing Distributed Applications with Microsoft Visual Basic® 6.0