Pre-requisites

To take our MCDBA program you don't need to be a SQL Server or Windows 2000 / 2003 expert, though you should have at least a year's experience of implementing relational databases and supporting network and desktop operating systems. Unlike conventional Microsoft courses, we've built our MCDBA to cater for a wide range of different entry levels. Whatever your starting point, we'll work with you to hit your skills and certification goals.

KEY TOPICS

Exam contents covered on our MCDBA program include:
Week One
Exam 70-290:
Managing and Maintaining a Microsoft Windows Server 2003 Environment
Managing and Maintaining Physical and Logical Devices
Managing Users, Computers, and Groups
Managing and Maintaining Access to Resources
Managing and Maintaining a Server Environment
Managing and Implementing Disaster Recovery

Exam 70-293:
Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
Planning and Implementing Server Roles and Server Security
Planning, Implementing, and Maintaining a Network Infrastructure
Planning, Implementing, and Maintaining Routing and Remote Access
Planning, Implementing, and Maintaining Server Availability
Planning and Maintaining Network Security
Planning, Implementing, and Maintaining Security Infrastructure.

Week Two
Exams 70-228 and 70-229 SQL Server 2000 Administration and Implementation
SQL Server features & SQL Server installation
Installation / upgrade troubleshooting
Data Storage concepts
Planning for Data Migration
Database Object fundamentals
Windows 2000 backup & database backup
Client configuration & XML support
Security management
Distributed Data environments
Database-Level Security
Linked and Non-linked Servers
SQL Queries & data retrieval
SQL programming
Data manipulation & database optimization
Identify and incorporate business rules and constraints
Diagnose selected problems and failures