MCITP - Microsoft Certified IT Professional in Database AdministratorDemonstrate that you have the skills that are necessary to lead organizations in the successful design, implementation, and administration of Microsoft SQL Server 2005 databases.

Course Duration: over 100 hours (please see our faq for course durations)

Daily (up to 3 hours a day, 5 days a week) live online classroom environment

Qualification: MCITP - Microsoft Certified IT Professional Database Administrator

Books: MCITP Self Paced Training Kit: Database Administrator Core Requirements Book/DVD Package 

Online Classes Modules:

Implementation and Maintenance SQL Server 2005 (exam 070-431)

Creating Databases and Database Files
Creating Data Types and Tables
Using XML
Creating and Tuning Indexes
Implementing Data Integrity
Triggers and XML Schemas
Implementing Views
Implementing Stored Procedures
Implementing Functions
Implementing Managed Code in the Database
Managing Transactions and Locks
Using Service Broker
Using Notification Services
Installing and Configuring SQL Server 2005
Managing Databases and Files
Disaster Recovery
Managing Security
Monitoring SQL Server
Transferring Data
Automating Administrative Tasks
Introduction to Replication
Maintaining High Availability

Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (exam 070-443)

Analyzing Capacity Needs
Data Archiving
Database Server
Database Server Consolidation
Data Distribution
Designing a Database Server Infrastructure
Data Recovery
Establishing Database Conventions and Standards
Introduction to Designing SQL Server Security
Designing a SQL Server Systems Infrastructure Security Policy
Designing Security Policies for Instances and Databases
Integrating Data Encryption into a Database Security Design
Designing a Security Exceptions Policy
Designing a Response Strategy for Threats and Attacks
Selecting the Appropriate High-Availability Solution
Designing a Highly Available Database Storage Solution
Designing a Failover Clustering Solution
Designing a Log Shipping Solution
Designing a Database Mirroring Solution
Designing Replication Solutions for High Availability
Combining High-Availability Technologies
Documenting and Testing a High-Availability Strategy

Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (exam 070-444)

Introduction to Designing SQL Server Security
Designing a SQL Server Systems Infrastructure Security Policy
Designing Security Policies for Instances and Databases
Integrating Data Encryption into a Database Security Design
Designing a Security Exceptions Policy
Designing a Response Strategy for Threats and Attacks
Managing and Automating Databases and Servers
Managing SQL Server Supporting Services
Building a Monitoring Solution for SQL Server Performance Issues
Troubleshooting Database and Database Server Performance Issues
Optimizing the Query Performance Environment
Troubleshooting SQL Server Connectivity Issues
Troubleshooting SQL Server Data Issues
Troubleshooting SQL Server Concurrency Issues

NEW! Now includes the SQL Server 2008 Update (Microsoft Webcasts)