"Their trainers and facilities are top-notch, making the entire training experience better than any other I've attended. At CTE Solutions, customer care comes first. They are the ideal partner for all  IT training and development."

Bob Legendre

Consultant

 

 
 

> MICROSOFT CERTIFIED DATABASE ADMINISTRATOR - MCDBA

The Microsoft Certified Database Administrator (MCDBA) credential is the premier certification for professionals who can successfully implement and administer Microsoft SQL Server 2000 databases.

MCDBA at a glance

Target audience:

  • IT professionals who implement and administer Microsoft SQL Server databases.

Typical job titles for MCDBA:

  • Database Administrator Database Analyst Database Developer

Experience:

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

 

Exam requirements:

 

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.

Elevate your status as a database administrator.
Professional certification 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 Microsoft SQL Server.

 

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.


Exam requirements:

Core exams (3 required)

1

SQL Server Administration

(1 required)

Exam 70-228:  Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Course 2072: Administering a Microsoft SQL Server 2000 Database (5 days)

2

SQL Server Design

(1 required)

Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Course 2073: Programming a Microsoft SQL Server 2000 Database (5 days)  

Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (2 days)

3

Networking Systems

(1 required)

Exam 70-215* Installing, Configuring, and Administering Microsoft Windows 2000 Server

Course 2151: Microsoft Windows 2000 Network and Operating System Essentials
(3 days)
Course 2152: Implementing Microsoft Windows 2000 Professional and Server
(5 days)

Course 1560: Updating Support Skills from Microsoft Windows NT® 4.0 to Microsoft Windows 2000 (5 days)

Exam 70-290:  Managing and Maintaining a Microsoft Windows Server™ 2003 Environment

 

Course 2274: Managing a Microsoft Windows Server 2003 Environment (5 days) 

Course 2275: Maintaining a Microsoft Windows Server 2003 Environment (3 days)

OR

Course 2208: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 (3 days

Exam 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

Course 2276: Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts (2 days)

Course 2277: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services (5 days)

OR

Course 2208: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 (3 days)

Elective Exams

 

(1 required)

Exam 70-216: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure

Course 2153: Implementing a Microsoft Windows 2000 Network Infrastructure
(5 days)

Course 1560: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows 2000 (5 days)

Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

 

Course 2278: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure (5 days)

Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

 

Course 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET (5 days)

Course 2373: Programming with Visual Basic .NET (5 days)

Course 2389: Programming with ADO.NET (3 days)

Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

 

Course 2565: Developing Microsoft .NET Applications for Windows (Visual Basic .NET) (5 days)

Course 2373: Programming with Visual Basic .NET (5 days)

Course 2389: Programming with ADO.NET (3 days)

Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework

 

Course 2389: Programming with ADO.NET (3 days)
Course 2524: Developing XML Web Services Using Microsoft ASP.NET (3 days)

Course 2557: Building COM+ Applications Using Microsoft .NET Enterprise Services
(5 days)

Course 2663: Programming with XML in the Microsoft .NET Framework (3 days)

Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

 

Course 2124: Programming with C#
(5 days)
Course 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET (5 days)
Course 2389: Programming with ADO.NET (3 days)

Exam 70-316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual
Studio .NET 

 

Course 2555: Developing Microsoft .NET Applications for Windows (Visual C# .NET) (5 days)
Course 2124: Programming with C#
(5 days)

Course 2389: Programming with ADO.NET (3 days)

Exam 70-320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework

 

Course 2524: Developing XML Web Services Using Microsoft ASP.NET (3 days)

Course 2557:  Building COM+ Applications Using Microsoft .NET Enterprise Services
(5 days)

Course 2389: Programming with ADO.NET (3 days)

Exam 70–015: Designing and Implementing Distributed Applications with Microsoft Visual C++® 6.0 Course 1015: Mastering MFC Developing using Microsoft Visual C++ 6.0 (5 days)
Exam 70–019: Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0 Course 1502: Designing and Implementing a Data Warehouse using Microsoft SQL Server 7.0 (5 days)
Course 2074: Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 (5 days)
Exam 70–155: Designing and Implementing Distributed Applications with Microsoft Visual FoxPro® 6.0 Currently, corresponding Official Microsoft Learning Products are not available.
Exam 70–175: Designing and Implementing Distributed Applications with Microsoft Visual Basic® 6.0 Course 1016: Mastering Enterprise Development Using Microsoft Visual Basic 6.0 (5 days)
Course 1298: Mastering Distributed Application Design and Development Using Microsoft Visual Studio 6.0 (3 days)

Candidates who passed both Windows NT 4.0 Exams 70–067 and 70–068 fulfilled the networking system core exam requirement (these exams are no longer available)

For complete details please go to www.microsoft.com/learning
 


  v22

About CTE | Services | Contact Us | Careers | Privacy Statement | Site Map
Course Finder | Schedule | Online Registration | Certification Tracks | Promos | Volume Pricing