MCDBA: Microsoft Certified Database Administrator
Definition & Purpose

The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server.

The MCDBA on SQL Server 2000 Certification Is Appropriate For:

• Database administrators
• Database analysts
• Database developers

By earning the premier MCDBA on SQL Server 2000 credential, individuals are demonstrating that they have the skills necessary to lead organizations in the successful design, implementation, and administration of SQL Server databases.

Course Outline

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

• SQL Server Overview
• Planning to Install SQL Server
• Managing Database Files
• Managing Security
• Performing Administrative Tasks
• Backing Up Databases
• Restoring Databases
• Monitoring SQL Server for Performance
• Transferring Data
• Maintaining High Availability
• Introducing Replication

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

• Overview of Programming SQL Server
• Creating and Managing Databases
• Creating Data Types and Tables
• Implementing Data Integrity
• Planning Indexes
• Creating and Maintaining Indexes
• Implementing Views
• Implementing Stored Procedures
• Implementing User-Defined Functions
• Implementing Triggers
• Programming Across Multiple Servers
• Optimizing Query Performance
• Performing Advanced Query Analysis
• Managing Transactions and Locks

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

• Introduction to Administering Accounts and Resources
• Managing User and Computer Accounts
• Managing Groups
• Managing Access to Resources
• Managing Access to Objects in Organizational Units
• Implementing Group Policy
• Managing the User Environment by Using Group Policy
• Implementing Administrative Templates and Audit Policy
• Preparing to Administer a Server
• Preparing to Monitor Server Performance
• Managing Data Storage
• Managing Disaster Recovery
• Software Maintenance Using Windows Server Update Services
• Securing Windows Server 2003

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

• Reviewing the Suite of TCP/IP Protocols
• Allocating IP Addressing by Using Dynamic Host Configuration Protocol (DHCP)
• Managing and Monitoring Dynamic Host Configuration Protocol (DHCP)
• Assigning IP Addresses in a Multiple Subnet Network
• Configuring a Client IP Address
• Resolving Names
• Resolving Host Names by Using Domain Name System (DNS)
• Managing and Monitoring Domain Name System (DNS)
• Configuring a Client for Name Resolution
• Integrating Domain Name System and Active Directory
• Resolving NetBIOS Names by Using Windows Internet Name Service (WINS)
• Configuring Routing by Using Routing and Remote Access
• Securing Network Traffic by Using IPSec and Certificates
• Configuring Network Access
• Managing and Monitoring Network Access
• Isolating Common Connectivity Issues