Microsoft Certified IT Professional (MCITP)

About the Microsoft Certified IT Professional (MCITP) Certification

The Microsoft Certified IT Professional (MCITP) credential demonstrates comprehensive skills in deploying, supporting and optimizing IT infrastructures. The MCITP validates that an individual has the comprehensive set of skills necessary to perform a role such as database administrator or enterprise messaging administrator. It builds on the technical proficiency measured in the Microsoft Certified Technology Specialist (MCTS) certifications. By completing MCITP exams, you will earn one more MCTS certification toward earning an MCITP certification.

About the MCITP Exam

ElementK offers two MCITP Database certification paths through American Sentinel, with separate exams required for each:

  1. MCITP: Database Developer (3 Exams)
    • PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 Open License 6.0
    • PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
  2. MCITP: Database Administrator (4 Exams)
    • PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
    • PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

Benefits

The MCITP credential validates your professional experience and knowledge using Microsoft products and solutions. MCITP certification shows employers that you are capable of deploying, building, designing, optimizing and operating technologies and making design and technology decisions necessary to ensure successful technology implementation projects.

With your MCITP credential, you gain access to exclusive Microsoft Certified Professional resources and benefits, including access to a global network of other Microsoft Certified Professionals. No matter where you are in your career, pursuing certification demonstrates your commitment to advancing your skills and taking on greater challenges.

Registration

To register for either of the above MCITP exams, simply complete an American Sentinel application. Students who choose to pursue American Sentinel bachelor’s degree programs can receive transfer credits for the MCITP certification.

MCITP Database Developer (3 Exams):

  • Exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 Open License 6.0
    • Selecting Microsoft® SQL Server™ 2005 Services to Support Business Needs
    • Designing a Security Strategy for a Microsoft® SQL Server™ 2005 Database Solution
    • Designing a Data Model Strategy for a Microsoft® SQL Server™ 2005 Solution
    • Designing a Transaction Strategy for a Microsoft® SQL Server™ 2005 Solution
    • Designing a Notification Services Solution Using SQL Server™ 2005 Notification Services
    • Designing Asynchronous, Queued Operations Using SQL Server™ 2005 Service Broker
    • Planning for Source Control, Unit Testing, and Deployment Using SQL Server™ 2005
    • Applying Advanced Query Techniques in Microsoft® SQL Server™ 2005
    • Approaching Database Design Systematically with Microsoft® SQL Server™ 2005
    • Modeling a Database at the Logical Level with Microsoft® SQL Server™ 2005
    • Modeling a Database at the Physical Level with Microsoft® SQL Server™ 2005
    • Designing Databases for Performance with Microsoft® SQL Server™ 2005
    • Designing a Database Access Strategy with Microsoft® SQL Server™ 2005
    • Modeling Database Dependencies with Microsoft® SQL Server™ 2005
  • Exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server 2005
    • Selecting Microsoft® SQL Server™ 2005 Services to Support Business Needs
    • Designing a Security Strategy for a Microsoft® SQL Server™ 2005 Database Solution
    • Designing a Data Model Strategy for a Microsoft® SQL Server™ 2005 Solution
    • Designing a Transaction Strategy for a Microsoft® SQL Server™ 2005 Solution
    • Designing a Notification Services Solution Using SQL Server™ 2005 Notification Services
    • Designing Asynchronous, Queued Operations Using SQL Server™ 2005 Service Broker
    • Planning for Source Control, Unit Testing, and Deployment Using SQL Server™ 2005
    • Applying Advanced Query Techniques in Microsoft® SQL Server™ 2005
    • Choosing Data Access Technologies and an Object Model for Microsoft® SQL Server™ 2005
    • Designing an Exception Handling Strategy for Microsoft® SQL Server™ 2005
    • Choosing a Cursor Strategy for Microsoft® SQL Server™ 2005
    • Designing Query Strategies Using Multiple Active Result Sets in Microsoft® SQL Server™ 2005
    • Designing Caching Strategies for Microsoft® SQL Server™ 2005 Database Applications
    • Designing a Scalable Data Tier for Microsoft® SQL Server™ 2005 Database Applications
    • Measuring Database Performance by Using Microsoft® SQL Server™ 2005
    • Optimizing Physical Database Design by Using Microsoft® SQL Server™ 2005
    • Optimizing Queries for Performance by Using Microsoft® SQL Server™ 2005
    • Refactoring Cursors into Queries by Using Microsoft® SQL Server™ 2005
    • Optimizing an Indexing Strategy by Using Microsoft® SQL Server™ 2005
    • Managing Concurrency by Using Microsoft® SQL Server™ 2005
  • Exam 70-431 TS: Microsoft SQL Server 2005 - Implementation and Maintenance
    • Getting Started with Databases and Transact-SQL in Microsoft® SQL Server™ 2005
    • Performing Basic Queries in Microsoft® SQL Server™ 2005
    • Grouping and Summarizing Data in Microsoft® SQL Server™ 2005
    • Joining Data from Multiple Tables in Microsoft® SQL Server™ 2005
    • Working with Subqueries in Microsoft® SQL Server™ 2005
    • Modifying Data in Microsoft® SQL Server™ 2005
    • Querying Metadata, XML, and Full-Text Indexes in Microsoft® SQL Server™ 2005
    • Using Programming Objects for Data Retrieval in Microsoft® SQL Server™ 2005
    • Using Advanced Querying Techniques in Microsoft® SQL Server™ 2005

MCITP: Database Administrator (4 Exams):

  • Exam 70-443 PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
    • Analyzing Capacity Needs for Microsoft® SQL Server™ 2005
    • Designing a Data Archiving Strategy for Microsoft® SQL Server™ 2005
    • Designing a Database Server Consolidation Strategy for Microsoft® SQL Server™ 2005
    • Designing a Data Distribution Strategy for Microsoft® SQL Server™ 2005
    • Designing a Microsoft® SQL Server™ 2005 Database Server Infrastructure
    • Designing a Data Recovery Strategy for Microsoft® SQL Server™ 2005
    • Establishing Database Conventions and Standards for Microsoft® SQL Server™ 2005
    • Introduction to Designing SQL Server Security for Microsoft® SQL Server™ 2005
    • Designing a SQL Server™ 2005 Security Policy to Integrate with Systems Infrastructure
    • Designing Security Policies for Microsoft® SQL Server™ 2005 Instances and Databases
    • Integrating Data Encryption into a Microsoft® SQL Server™ 2005 Database Security Design
    • Designing a Microsoft® SQL Server™ 2005 Security Exceptions Policy
    • Designing a Response Strategy for Threats and Attacks Against Microsoft® SQL Server™ 2005
    • Selecting the Appropriate High-Availability Technology Using Microsoft® SQL Server™ 2005
    • Designing a Highly Available Database Storage Solution Using Microsoft® SQL Server™ 2005
    • Designing a Clustering Solution Using Microsoft® SQL Server™ 2005
    • Designing a Log Shipping Solution Using Microsoft® SQL Server™ 2005
    • Designing a Database Mirroring Solution Using Microsoft® SQL Server™ 2005
    • Designing Replication Solutions for High Availability Using Microsoft® SQL Server™ 2005
    • Combining High-Availability Technologies Using Microsoft® SQL Server™ 2005
  • Exam 70-444 PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
    • Introduction to Designing SQL Server Security for Microsoft® SQL Server™ 2005
    • Designing a SQL Server™ 2005 Security Policy to Integrate with Systems Infrastructure
    • Designing Security Policies for Microsoft® SQL Server™ 2005 Instances and Databases
    • Integrating Data Encryption into a Microsoft® SQL Server™ 2005 Database Security Design
    • Designing a Microsoft® SQL Server™ 2005 Security Exceptions Policy
    • Designing a Response Strategy for Threats and Attacks Against Microsoft® SQL Server™ 2005
    • Managing and Automating Microsoft® SQL Server™ 2005 Databases and Servers
    • Managing Microsoft® SQL Server™ 2005 Supporting Services
    • Building a Monitoring Solution for Microsoft® SQL Server™ 2005 Performance Issues
    • Troubleshooting Microsoft® SQL Server™ 2005 Database and Database Server Performance Issues
    • Optimizing the Microsoft® SQL Server™ 2005 Query Performance Environment
    • Troubleshooting Microsoft® SQL Server™ 2005 Connectivity Issues
    • Troubleshooting Microsoft® SQL Server™ 2005 Data Issues
    • Troubleshooting Microsoft® SQL Server™ 2005 Concurrency Issues
  • Exam 70-447 UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
    • Analyzing Capacity Needs for Microsoft® SQL Server™ 2005
    • Designing a Data Archiving Strategy for Microsoft® SQL Server™ 2005
    • Designing a Database Server Consolidation Strategy for Microsoft® SQL Server™ 2005
    • Designing a Data Distribution Strategy for Microsoft® SQL Server™ 2005
    • Designing a Microsoft® SQL Server™ 2005 Database Server Infrastructure
    • Designing a Data Recovery Strategy for Microsoft® SQL Server™ 2005
    • Establishing Database Conventions and Standards for Microsoft® SQL Server™ 2005
    • Introduction to Designing SQL Server Security for Microsoft® SQL Server™ 2005
    • Designing a SQL Server™ 2005 Security Policy to Integrate with Systems Infrastructure
    • Designing Security Policies for Microsoft® SQL Server™ 2005 Instances and Databases
    • Integrating Data Encryption into a Microsoft® SQL Server™ 2005 Database Security Design
    • Designing a Microsoft® SQL Server™ 2005 Security Exceptions Policy
    • Designing a Response Strategy for Threats and Attacks Against Microsoft® SQL Server™ 2005
    • Selecting the Appropriate High-Availability Technology Using Microsoft® SQL Server™ 2005
    • Designing a Highly Available Database Storage Solution Using Microsoft® SQL Server™ 2005
    • Designing a Clustering Solution Using Microsoft® SQL Server™ 2005
    • Designing a Log Shipping Solution Using Microsoft® SQL Server™ 2005
    • Designing a Database Mirroring Solution Using Microsoft® SQL Server™ 2005
    • Designing Replication Solutions for High Availability Using Microsoft® SQL Server™ 2005
    • Combining High-Availability Technologies Using Microsoft® SQL Server™ 2005
    • Introduction to Designing SQL Server Security for Microsoft® SQL Server™ 2005
    • Designing a SQL Server™ 2005 Security Policy to Integrate with Systems Infrastructure
    • Designing Security Policies for Microsoft® SQL Server™ 2005 Instances and Databases
    • Integrating Data Encryption into a Microsoft® SQL Server™ 2005 Database Security Design
    • Designing a Microsoft® SQL Server™ 2005 Security Exceptions Policy
    • Designing a Response Strategy for Threats and Attacks Against Microsoft® SQL Server™ 2005
    • Managing and Automating Microsoft® SQL Server™ 2005 Databases and Servers
    • Managing Microsoft® SQL Server™ 2005 Supporting Services
    • Building a Monitoring Solution for Microsoft® SQL Server™ 2005 Performance Issues
    • Troubleshooting Microsoft® SQL Server™ 2005 Database and Database Server Performance Issues
    • Optimizing the Microsoft® SQL Server™ 2005 Query Performance Environment
    • Troubleshooting Microsoft® SQL Server™ 2005 Connectivity Issues
    • Troubleshooting Microsoft® SQL Server™ 2005 Data Issues
    • Troubleshooting Microsoft® SQL Server™ 2005 Concurrency Issues
    • Exam 70-431 TS: Microsoft SQL Server 2005 - Implementation and Maintenance
    • Getting Started with Databases and Transact-SQL in Microsoft® SQL Server™ 2005
    • Performing Basic Queries in Microsoft® SQL Server™ 2005
    • Grouping and Summarizing Data in Microsoft® SQL Server™ 2005
    • Joining Data from Multiple Tables in Microsoft® SQL Server™ 2005
    • Working with Subqueries in Microsoft® SQL Server™ 2005
    • Modifying Data in Microsoft® SQL Server™ 2005
    • Querying Metadata, XML, and Full-Text Indexes in Microsoft® SQL Server™ 2005
    • Using Programming Objects for Data Retrieval in Microsoft® SQL Server™ 2005
    • Using Advanced Querying Techniques in Microsoft® SQL Server™ 2005