Microsoft Certified IT Professional (MCITP): Database Administrator

ICT Curriculum Roadmap for Database Administrator

Updated: June 27, 2007



Microsoft products

The Microsoft Certified IT Professional(MCITP):Database Administrator credential applies to these products:

  • Microsoft SQL Server 2005

  • Windows Server 2003

  • Windows XP or Windows Vista

Step 1. Assess your foundational knowledge

Before beginning the MCITP:Database Administrator curriculum, view the following table and move through each prerequisite in the order presented. Assess your knowledge against this list to determine your starting point. If you have knowledge gaps, use the learning and assessment resources to learn more. In some cases, a certification exam is available to validate your knowledge.

Prerequisites skills and knowledge —Self-assess checklistClassroom trainingE-LearningRelated study Assessment resources Certification exam

Fundamental understanding of computers, the Internet, and personal productivity programs: Digital literacy curriculum.

Microsoft Digital Literacy*

Microsoft Digital Literacy*

 

Microsoft Digital Literacy certificate test*

 

Knowledge of computer hardware and components as in the CompTIA A+ Essentials Certification: Download file from Comptia.org (PDF, 164 KB)

Microsoft Official Academic Course (MOAC): ALS A+ Certification Package, Third Edition (Wiley.com)

 

Faster Smarter A+ Certification

 

CompTIA A+ Certification (Comptia.org)

Knowledge of computer networking and components as in the CompTIA Network+ Certification: Download file from Comptia.org (PDF, 60 KB)

MOAC: ALS Network+ Certification Package, Fourth Edition (Wiley.com)

 

Faster Smarter Network + Certification

 

CompTIA Network+ Certification (Comptia.org)

Knowledge of desktop operating systems, such as Windows XP (may substitute Windows Vista-roadmap below)

Microsoft Official Courseware (MOC) Course 2272*: Implementing and Supporting Microsoft Windows XP Professional

or

MOC Course 2285*: Installing, Configuring, and Administering Microsoft Windows XP Professional

or

MOAC: 70-270 Installing, Configuring, and Administering Microsoft Windows XP Professional Package, Second Edition

(Wiley.com)

Courses 4119 and 4122: Core Training and What's New in Microsoft Windows XP Professional Service Pack 2

or

Course 2285*: Installing, Configuring, and Administering Microsoft Windows XP Professional Service Pack 2

Microsoft Windows XP Step by Step Deluxe, Second Edition

Assessment tools for Course 2285*: Installing, Configuring, and Administering Microsoft Windows XP Professional Service Pack 2

MCP Exam 70-270: Installing, Configuring, and Administering Microsoft Windows XP Professional (Exam 70-270 is available at an academic discount)

Experience with database design

Beginning Database Design (Wiley.com)

Collection 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

 

Assessment tools for Course 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

 

Knowledge of relational databases and Transact-SQL

 

Collection 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

A Visual Introduction to SQL, Second Edition (Wiley.com)

Beginning Transact-SQL with SQL Server 2000 and 2005 (Wiley.com)

Beginning SQL (Wiley.com)

Assessment tools for Course 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

 

*Available to Microsoft IT Academy members

Step 2. Gain and apply skills

To begin the MCITP: Database Administrator curriculum, use the suggested pathway in the following tables.

Note You must complete the requirements for MCTS: SQL Server 2005 before you begin the MCITP: Database Administration SQL Server 2005 curriculum.

MCTS: SQL Server 2005—Learning outcomesClassroom trainingE-LearningRelated study Assessment resources Certification exam

Implementing and maintaining SQL Server 2005

MOC Course 2779*: Implementing a Microsoft SQL Server 2005 Database

and

MOC Course 2780*: Maintaining a Microsoft SQL Server 2005 Database

Course 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

MCTS Self–Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005—Implementation and Maintenance

Microsoft SQL Server 2005: Applied Techniques Step by Step

Microsoft SQL Server 2005: Database Essentials Step by Step

Inside Microsoft SQL Server 2005: The Storage Engine

Programming Microsoft SQL Server 2005

Microsoft SQL Server 2005 Administrator's Pocket Consultant

Microsoft SQL Server 2005 Administrator's Companion

Assessment tools for Course 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance (Exam 70-431 is available at an academic discount)

*Available to Microsoft IT Academy members

Note You must complete the requirements for MCTS: SQL Server 2005 before you begin the MCITP: Database Administration SQL Server 2005 curriculum.

MCITP: Database Administration—Learning outcomesClassroom trainingE-LearningRelated study Assessment resources Certification exam

Designing a database server infrastructure by using Microsoft SQL Server 2005

MOC Course 2786*: Designing a Microsoft SQL Server 2005 Infrastructure

and

MOC Course 2787*: Designing Security for Microsoft SQL Server 2005

and

MOC Course 2788*: Designing High Availability Database Solutions Using Microsoft SQL Server 2005

Collection 2786: Designing a Microsoft SQL Server 2005 Infrastructure

and

Collection 2787: Designing Security for Microsoft SQL Server 2005

and

Collection 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005

MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005

Inside Microsoft SQL Server 2005: The Storage Engine

Inside Microsoft SQL Server 2005: T-SQL Querying

Inside Microsoft SQL Server 2005: T-SQL Programming

Inside Microsoft SQL Server 2005: Query Tuning and Optimization

Programming Microsoft SQL Server 2005

Microsoft SQL Server 2005 Administrator's Pocket Consultant

Microsoft SQL Server 2005 Administrator's Companion

Assessment tools for Collection 2786: Designing a Microsoft SQL Server 2005 Infrastructure

and

Assessment tools for Collection 2787: Designing Security for Microsoft SQL Server 2005

and

Assessment tools for Collection 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005

Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

Optimizing and maintaining a database administration solution by using Microsoft SQL Server 2005

MOC Course 2787*: Designing Security for Microsoft SQL Server 2005

and

MOC Course 2789*: Administering and Automating Microsoft SQL Server 2005 Databases and Servers

and

MOC Course 2790*: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

Collection 2787: Designing Security for Microsoft SQL Server 2005

and

Collection 2789*: Administering and Automating Microsoft SQL Server 2005 Databases and Servers

and

Collection 2790*: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005

Inside Microsoft SQL Server 2005: The Storage Engine

Inside Microsoft SQL Server 2005: T-SQL Querying

Inside Microsoft SQL Server 2005: T-SQL Programming

Inside Microsoft SQL Server 2005: Query Tuning and Optimization

Programming Microsoft SQL Server 2005

Microsoft SQL Server 2005 Administrator's Pocket Consultant

Microsoft SQL Server 2005 Administrator's Companion

 

Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

*Available to Microsoft IT Academy members

Desktop option:—Windows Vista—Skill outcomesClassroom trainingE-LearningRelated study Assessment resources Certification exam

Knowledge of desktop operating systems, such as Windows Vista

MOC Course 5115*: Installing and Configuring the Windows Vista Operating System

and

MOC Course 5116*: Configuring Windows Vista Mobile Computing and Applications

and

MOC Course 5117*: Microsoft Windows Vista Mobile Computing

or

Microsoft Official Academic Course in development. (For more information, visit Wiley.com)

Collection 5347: Installing and Configuring Windows Vista

and

Collection 5354: Configuring Windows Vista Applications and Devices

MCTS Self-Paced Training Kit (Exam 70-620): Configuring Microsoft Windows Vista Client

 

Exam 70-620 TS: Microsoft Windows Vista, Configuring (Exam 70-620 is available at an academic discount)

*Available to Microsoft IT Academy members

**

Related Links

•Visit the ICT home page
•Visit the database administrator overview page
•Learn more about MCTS:SQL Server 2005
•Learn more about MCITP:Database Administrator
**