As a database administrator, your specialized training in database maintenance and optimization puts you in charge of an organization's important data solutions. You ensure that database security, availability, and performance satisfy business requirements. To do this, your expertise must span archival, data distribution, and the design of high-availability solutions.

Possible Job Titles

• Data storage manager
• Database analyst
• Database designer

Skills

General

• Manage and maintain databases
• Create and implement database objects
• Support consumer data

Beginner

• Design database servers
• Optimize data

Intermediate

• Design data distribution and archiving solutions
• Design Microsoft SQL Server solutions
• Design database security
• Configure and maintain Active Directory

Expert

• Deploy and monitor database servers
• Plan application and data provisioning

Responsibility Scope

• 60 percent operations
• 20 percent engineering
• 20 percent support tasks

MCITP: Database Administrator 2008

• Microsoft Exam 70-432 TS: Microsoft SQL Server 2008, Installation and Maintenance
• Microsoft Exam 70-450 PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008.

Total Number of Training Days: 18 Days

Course 6231A (5 days)

Maintaining a Microsoft SQL Server 2008 Database.

Course 6232A (5 days)

Implementing a Microsoft SQL Server 2008 Database.

Course 2778A (3 days)

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

Prep 70-432

Test prep for exam 70-432: TS: Microsoft SQL Server 2008, Installation and Maintenance.

Course 50400 (5 days)

Designing, Optimizing, and Maintaining a Database Admin Solution for SQL Server 2008.

Prep 70-450

Test prep for exam 70-450 PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008.