Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-size to large organizations.
MCITP candidates must first complete the requirements for the MCTS: SQL Server 2005 certification (one exam). After earning this certification, candidates earn their MCITP: Database Administrator by passing two required exams.
If you are a Microsoft Certified Database Administrator (MCDBA), you may upgrade to the MCITP: Database Administrator certification by taking one upgrade exam instead of the two required exams. MCDBAs must still obtain the MCTS: SQL Server 2005 certification as a prerequisite.
The following table provides a complete list of exams and related training resources
Exam 70–443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Exam 70–444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
Exam 70–447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries. Database developers are typically employed by mid-sized to large-sized organizations.
MCITP candidates must first complete the requirements for the MCTS: SQL Server 2005 credential (one exam). After earning this credential, candidates earn their MCITP: Database Developer by passing two required exams. The following table provides a complete list of exams and related training resources
Exam 70–441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 Open License 6.0
Exam 70–442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance
 |
|
|
|
 |
 |
 |
|
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
