Microsoft Certified IT Professional (MCITP)

The Microsoft Certified IT Professional (MCITP) credential lets you highlight your field of expertise. Now you can distinguish yourself as an IT professional with the current skills and proven ob-role capabilities to work effectively with a comprehensive set of Microsoft technologies.

•     IT Professional: Business Intelligence Developer
•     IT Professional: Consumer Support Technician
•     IT Professional: Database Developer
•     IT Professional: Database Administrator
•     IT Professional: Enterprise Messaging Administrator
•     IT Professional: Enterprise Project Management with Microsoft Office Project Server 2007
•     IT Professional: Enterprise Support Technician

MCITP: Business Intelligence Developer

Microsoft Certified IT Professional: Business Intelligence Developer certification demonstrates that you can design analysis solutions, data transformations, and reports. Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use Multidimensional Expressions (MDX), customer transforms, and custom reporting solutions. Business intelligence developers are typically employed by mid- to large-sized organizations.

The new generation of Microsoft certifications

The MCITP: Business Intelligence Developer credential is part of the new generation of Microsoft certifications, which separates validation of technology and professional skills, providing a more relevant, flexible, and cost-effective way to validate core technical, professional, and architectural skills.

How to earn your MCITP: Business Intelligence Developer certification

To achieve this certification, you must successfully complete two exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and one Professional Series exam. This certification requires a periodic update to demonstrate that your knowledge of technology and best practices is current.

Prerequisite MCTS certification
Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance

Professional Series exams   
Exam 70-446: PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005

MCITP: Consumer Support Technician

Professionals with Microsoft certification not only thrive on the continuing challenges of the IT field, but they also take the initiative to develop and hone their skills so that they stay a step ahead. When you become Microsoft certified, you will:

• Stand out. Prove your specific, real-world technology skills.
• Be productive. Help increase customer satisfaction, reduce network downtime, and push service to a higher level.
• Achieve success. Each Microsoft certification takes you further along the path to professional recognition.

The Microsoft Certified IT Professional: Consumer Support Technician (MCITP: Consumer Support Technician) credential is the premier certification to highlight and validate your expertise and skill set in a job role supporting a broad range of consumer desktop operating systems, desktop applications, mobile devices, networking, and hardware support issues related to the Windows Vista operating system. This certification is the right option for you if your interest lies in home user support or consumer retail support.

How to earn your MCITP: Consumer Support Technician

To achieve this certification, you must successfully complete two exams: one Microsoft Certified Technology Specialist (MCTS) Windows Vista prerequisite exam and one Professional Series exam.

Prerequisite MCTS certification      
Exam 70-620: TS: Microsoft Windows Vista, Configuring

Professional Series exams
Exam 70-623: PRO: Supporting and Troubleshooting
Applications on a Windows Vista Client for Consumer Support Technicians

MCITP: Database Developer Certification

Microsoft Certified IT Professional: Database Developer certification 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.

The new generation of Microsoft Certifications

The MCITP: Database Developer credential is part of the new generation of Microsoft Certifications, which emphasizes primary skill sets and job roles, providing a more relevant, flexible, and cost-effective way to validate core technical, professional, and architectural skills.

How to earn your MCITP: Database Developer

To achieve this certification, you must pass three exams: one MCTS prerequisite exam and two Professional Series exams.
This certification will require a periodic update to demonstrate your continued currency in technology and best practices.

Prerequisite MCTS certification

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

Professional Series exams

Exam 70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005

Exam 70–442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

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.

Candidate profile

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.

How to earn your MCITP: Database Administrator

To earn this certification, you must pass three exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and two Professional Series exams.
There is a transition path of only two exams for a Microsoft Certified Database Administrator (MCDBA).

This certification requires a periodic update so that you can demonstrate your continued expertise in the latest technology and best practices.

Prerequisite MCTS exam

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

Professional Series exams

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

MCITP: Enterprise Messaging Administrator

The Microsoft Certified IT Professional: Enterprise Messaging Administrator (MCITP: Enterprise Messaging Administrator) is the premier certification to highlight a professional’s area of expertise. This certification validates the knowledge and skills associated with performing as the lead engineer for messaging solutions within an enterprise organization, as well as the ability to design and deploy messaging solutions with Microsoft Exchange Server 2007.

The MCITP: Enterprise Messaging Administrator credential is part of the new generation of Microsoft certifications, which emphasizes primary skill sets and job roles, providing a more relevant, flexible, and cost-effective way to validate core technical, professional, and architectural skills.

This certification requires a periodic update to demonstrate that your knowledge of technology and best practices is current.

How to earn your MCITP: Enterprise Messaging Administrator

To achieve this certification, you must successfully complete three exams: one Microsoft Certified Technology Specialist (MCTS) Microsoft Exchange Server 2007 prerequisite exam and two Professional Series exams.

Prerequisite MCTS certification
Exam 70-236: TS: Exchange Server 2007, Configuring
Professional Series exams   
Exam 70-237: PRO: Designing Messaging Solutions with Microsoft Exchange Server 2007
Exam 70-238: PRO: Deploying Messaging Solutions with Microsoft Exchange Server 2007

MCITP: Enterprise Project Management with Microsoft Office Project Server 2007

The Microsoft Certified IT Professional (MCITP) credential lets you highlight your specific area of expertise. Now you can easily distinguish yourself as an expert in database administration, database development, business intelligence, support, or project management. More than a product certification, the new Microsoft Office Project 2007 certification family is designed specifically to help project managers apply the leading project management best practices and methodologies as established by the Project Management Institute (PMI), resulting in better project outcomes, greater efficiency, and optimal resource management.

Candidate profile

The Microsoft Certified IT Professional credential for Microsoft Office Project Server 2007 provides industry recognition to project managers and other professionals who use Microsoft Office Project Professional 2007 and Office Project Server 2007 to manage and support projects in an enterprise project management (EPM) environment. Candidates for this certification manage projects in an EPM environment and are able to manage project and non-project efforts, risks, issues, documents, task progress, and timesheets. Candidates should have in-depth knowledge of key project management concepts and terminology found in the Project Management Institute's "A Guide to the Project Management Book of Knowledge" (PMBOK Guide).

How to earn your MCITP: Enterprise Project Management with Microsoft Office Project Server 2007

To earn this certification, you must pass three exams: two Microsoft Certified Technology Specialist (MCTS) prerequisite exams and one Professional Series exam. This certification requires a periodic update so that you can demonstrate your continued expertise in the latest technology and best practices.
Prerequisite MCTS
Exam 70-632: TS: Microsoft Office Project 2007, Managing Projects
Exam 70-633: TS: Microsoft Office Project Server 2007, Managing Projects
Professional Series
Exam 70-634: PRO: Microsoft Office Project Server 2007, Managing Projects and Programs

MCITP: Enterprise Support Technician

The Microsoft Certified IT Professional: Enterprise Support Technician credential validates the knowledge and skills required to deploy and support the Windows Vista operating system.