Microsoft Certified Database Administrator - MCDBA

Overview & Objectives:
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 Duration:
72 Hours (Part-time or Fulltime available)

Who should attend:
student has Experience using the Microsoft Windows Server 2003 operating system, understanding of basic relational database conceepts, including logical and physical database design, and knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements). Ideally be familiarity with the role of the database administrator.

Course modules:

70-290 Managing and Maintaining a Microsoft Windows Server 2003 Environment --- 18 Hours
Module 1: Introduction to Administering Accounts and Resources
Module 2: Managing User and Computer Accounts
Module 3: Managing Groups
Module 4: Managing Access to Resources
Module 5: Implementing Printing
Module 6: Managing Printing
Module 7: Preparing to Monitor Server Performance
Module 8: Monitoring Server Performance
Module 9: Maintaining Device Drivers
Module 10: Managing Disks
Module 11: Managing Data Storage
Module 12: Managing Disaster Recovery
Module 13: Maintaining Software by Using Microsoft Software Update Services

70-293 Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure --- 18 Hours
Module 1: Introducing Windows Server 2003 Network Infrastructure Planning, Tools, and Documentation
Module 2: Planning and Optimizing a TCP/IP Physical and Logical Network
Module 3: Planning and Troubleshooting Routing
Module 4: Planning a DHCP Strategy
Module 5: Optimizing and Troubleshooting DHCP
Module 6: Planning a DNS Strategy
Module 7: Optimizing and Troubleshooting DNS
Module 8: Planning and Optimizing WINS
Module 9: Planning and Troubleshooting IPSec
Module 10: Planning Network Access
Module 11: Troubleshooting Network Access
Module 12: Preparing for the Course Lab

70-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Module 1: Overview of Programming SQL Server
Module 2: Creating and Managing Database
Module 3: Creating Data Types And Tables
Module 4: Implementing Data Integrity
Module 5: Planning Indexes
Module 6: Creating and Maintaining Indexes
Module 7: Implementing Views
Module 8: Implementing Stored Procedures
Module 9: Implementing User-Defined Functions
Module 10: Implementing Triggers
Module 11: Programming Across Multiple Servers
Module 12: Optimizing Query Performance
Module 13: Performing Advance Query Analysis
Module 14: Managing Transactions and locks

70-228 Installing, Configuring, and Administering Microsoft SQL Server 200 Enterprise Edition --- 18 Hours
Module 1: SQL Server Overview
Module 2: Planning to Install SQL Server
Module 3: Managing Database Files
Module 4: Managing Security
Module 5: Performing Administrative Tasks
Module 6: Backing Up Databases
Module 7: Restoring Databases
Module 8: Monitoring SQL Server for Performance
Module 9: Transferring Data
Module 10: Maintaining High Availability
Module 11: Introducing Replication

MORE INFORMATION...