What Is Being Tested

By Author: fiona
Total Articles: 190
Comment this article

A variety of skills will be tested in the following modules:

1. Database implementation and maintenance:
This module focuses on your ability to install and configure Microsoft's very own MCITP certification exams, implement high availability and disaster recovery so as to protect your database, support data consumers, maintain databases, create and implement database objects, as well as assessing monitoring and troubleshooting SQL server performance. This will all be tested by an exam.

After completing this module, you will gain a certificate known as the Microsoft Certified Technology Specialist: SQL Server 2005. This acts as one credit towards the MCITP database administrator certification - you must complete the other two modules before you can gain this certificate.

2. Designing a Database Server Infrastructure:
The central aim of this second module is to teach you how to optimise the performance of database servers and databases. It focuses mainly on design elements, which will enhance your databases' efficiency and security. You will be taught how ...
... to design a database server infrastructure, design security solutions - enabling you to make the best choice of security; design the database so that you can improve performance, efficiency and choose the most appropriate view. Further testing includes: designing a database solution for high availability, data recovery and a structure for data archiving. As before, this is tested by an exam.

3. Optimising and maintaining a database
This module continues to study database performance optimisation and maintenance using online MCITP certification. It will analyse the performance of the database, the server and queries. One of the main focuses of this module will be - the implementation of a database recovery plan, so as to protect the database from any disasters. This module will then continue to analyse in depth strategies to maintain and monitor a database solution, which includes content management; will cultivate the ability to design a strategy to manage data, as well as security.

The MCITP certification will enable you to utilise the skills you need to optimise the database's performance and security, which will in turn improve your company's performance and effectiveness.

AICT has recently upgraded it's IT Training to the new Microsoft Certified IT Professional Certification Track, the MCITP is Microsoft's newest certification track and has been designed to replace the MCSA and MCSE certifications. MCITP is the only certification available on MS Windows Server 2008.

The major differences between the new MCITP track and the old MCSA/MCSE track is that under the old system, you earned certifications getting your MCP certification first, then your MCSA, after which you finally earn your MCSE. Previously, you could not earn your MCSE without completing the requirements for the MCSA. Now under the new system, these certifications have their own separate tests.

Microsoft states that the reasoning behind this is to show that the certifications are meant for different jobs a focuses on
free Microsoft questions operations and management while an should be more of the architect and designer of the entire system.