Microsoft Certified Professional (MCP)
Microsoft Certified Technology Specialist (MCTS)
Microsoft Certified IT Professional (MCITP)
Microsoft Certified Professional Developer (MCPD)
Microsoft Certified Systems Administrator (MCSA)
Microsoft Certified Systems Engineer (MCSE)
Microsoft Certified Application Developer (MCAD)
Microsoft Certified Solution Developer (MCSD)
Microsoft Certified Database Administrator (MCDBA)
Microsoft Certified Desktop Support Technician (MCDST)
Microsoft Office Specialist (MOS)
Description
The new 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, or business intelligence.
The four IT Professional certifications currently available at New Horizons are as follows:
- IT Professional: Database Developer
- IT Professional: Database Administrator
- IT Professional: Business Intelligence Developer
- IT Professional: Enterprise Support
Technician
The Microsoft Information Technology Professional: Database Developer
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.
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
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. For exam dates and specific areas of focus, see individual Exam Preparation Guides as the exams become available.
MCITP: Database Developer Certification Paths
| Required Exams for MCITP: Database Developer (Two Exams) | Courses |
| Exam 70–441: Designing Database Solutions by Using Microsoft SQL Server 2005 |
Course 2781: Designing
Microsoft SQL Server 2005 Server-Side Solutions (3
days)
Course 2782: Designing Microsoft SQL Server 2005 Databases (2 days) |
The Microsoft Certified Information Technology Professional: 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.
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 Skills Assessments for Microsoft SQL Server 2005 help database administrators focus their exam preparation training and find learning resources.
How to Earn Your MCITP: Database Administrator
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 in place 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.
MCITP: Database Administrator Certification Paths
| Required Exams for MCITP: Database Administrator (Two Exams) | Courses |
| Exam 70–443: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 |
Course 2786: Designing a Microsoft SQL Server 2005
Infrastructure (2 days)
Course 2787: Designing Security for Microsoft SQL Server 2005 (2 days) Course 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (3 days) |
The Microsoft Certified Information Technology Professional: Business Intelligence Developer
Microsoft Certified IT Professional: Business Intelligence Developer (MCITP: Business Intelligence Developer) is the premier certification for business intelligence system designers and developers. This certification demonstrates that you can design 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-sized to large-sized organizations.
Microsoft Skills Assessments for Microsoft SQL Server 2005 help business intelligence developers focus their exam preparation training and find learning resources
How to Earn Your MCITP: Business Intelligence Developer
MCITP: Business Intelligence Developer candidates must first complete the requirements for the MCTS: SQL Server 2005 Business Intelligence certification (one exam). After achieving this Technology Specialist certification, candidates earn their MCITP: Business Intelligence Developer by passing one required exam. 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.
MCITP: Business Intelligence Developer Certification Tracks
| Required Exams for MCITP: Business Intelligence Developer (One Exam) | Courses |
| Exam 70-446: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2005 | Course 2794: Designing a Business Intelligence Solution Architecture for the Enterprise Using Microsoft SQL Server 2005 (2 days) |
| Required Exams for MCTS: SQL Server 2005 Business Intelligence (One Exam) | Courses |
| Exam 70-445: Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance | TBD |
The Microsoft Information Technology Professional: Enterprise Support Technician
The Microsoft Certified IT Professional: Enterprise Support Technician is a premier certification that highlights your area of expertise and validates the knowledge and skills required to deploy and support the Windows Vista operating system. If you have the MCITP: Enterprise Support Technician credential, you have expertise in deploying Windows Vista, managing security, and troubleshooting network issues, and you have three years of experience as a tier 2 or lead desktop support technician
How to Earn Your MCITP: Enterprise Support Technician
MCITP candidates with the MCTS prerequisite must pass one exam focusing on responding to issues assigned or escalated from tier 1 support.
Here are the skills required for the MCITP: Enterprise Support Technician certification:
- Manage workflow.
- Install and configure desktop operating systems and applications.
- Troubleshoot the desktop operating system, desktop applications, and desktop networking and connectivity.
- Install and configure hardware devices and drivers (including mobile and personal devices).
- Troubleshoot hardware devices and drivers (including mobile and personal devices).
- Escalate complex issues to the appropriate administrator (for example, server administrator, network administrator, or desktop configuration administrator).
- Install and test department-specific and line-of-business (LOB) applications on end-user computers.
- Change desktop configurations as needed.
- Re-image desktops as needed
For exam dates and specific areas of focus, see individual Exam Preparation Guides as the exams become available.
MCITP: Enterprise Support Technician Certification Paths
| Required Exams for MCITP: Enterprise Support Technician (One Exam plus MCTS Prerequisite) | Courses |
| Exam 70-622: Microsoft Desktop Support – Enterprise |
Course 5118: Maintaining and Troubleshooting Windows
Vista Computers (3 days)
Course 5119: Supporting the Windows Vista Operating System and Applications (2 days) |
Authorized Centers
New Horizons has the largest network of Microsoft Certified Partners for Learning Solutions (CPLSs) in the computer training industry.
For more information on the MCPD credential go to http://www.microsoft.com/learning/default.mspx.
