MCITP : Database Developer

Microsoft Certified IT Professional: Database Developer (MCITP : Database Developer) is the premier Microsoft Certification Course for database designers and developers. This credential demonstrates that you can design a secure, stale, enterprise database solution by using Microsoft SQL Server 2005.

Microsoft Certified 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. Microsoft Certified Database developers are typically employed by mid-sized to large-sized organizations.

Microsoft Skills Assessments for SQL Server 2005 help database developers focus their exam preparation training and find learning resources.

How to earn your MCITP : Database Developer

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.

Required Exams for MCITP : Database Developer (Two Exams Required)

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

Required Exams for MCTS : SQL Server 2005 (One Exam Required)

Exam 70–431 : TS: Microsoft SQL Server 2005 - Implementation and Maintenance

................................................................................................................................

MCITP : Database Administrator

Microsoft Certified IT Professional: Database Administrator (MCITP : Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week.

Microsoft Certified 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.

Microsoft Certified Microsoft Skills Assessments for SQL Server 2005 help database developers focus their exam preparation training and find learning resources.

How to earn your MCITP : Database Administrator

Candidates must first complete the requirements for the MCTS : SQL Server 2005 (One Exam Required) 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. For exam dates and specific areas of focus, see individual Exam Preparation Guides as the exams become available.

Required Exams for MCITP : Database Administrator (Two Exams Required)

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

Required Exams for MCITP : Database Administrator (Two Exam Required)

Exam 70–447 : TS: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005