| Been working as a database administrator for two | | | | certificate known as the Microsoft Certified |
| years or more? Yet, you want to achieve more in | | | | Technology Specialist: SQL Server 2005. This acts as |
| the work place? An MCITP certification in database | | | | one credit towards the MCITP database |
| administration could be for you... | | | | administrator certification - you must complete the |
| The Microsoft Certified Information Technology | | | | other two modules before you can gain this |
| Professional certificate will grant you a professional | | | | certificate. |
| qualification, which reinforces your I.T skills to your | | | | 2. Designing a Database Server Infrastructure: |
| employer and other future employers. It validates | | | | The central aim of this second module is to teach |
| your knowledge as a trained and experienced | | | | you how to optimise the performance of database |
| professional. Furthermore, it allows to get to grips, | | | | servers and databases. It focuses mainly on design |
| out of the work place, with the ever advancing | | | | elements, which will enhance your databases' |
| Microsoft technologies that are available - enabling | | | | efficiency and security. You will be taught how to |
| you to advance your skills in the work place, and | | | | design a database server infrastructure, design |
| hopefully get that much needed promotion! An | | | | security solutions - enabling you to make the best |
| MCITP course also helps to suggest your | | | | choice of security; design the database so that you |
| commitment to the profession to your employers | | | | can improve performance, efficiency and choose the |
| and clients, which is extremely important in the | | | | most appropriate view. Further testing includes: |
| increasingly tougher job market. | | | | designing a database solution for high availability, data |
| The Lowdown - Database Administration (SQL | | | | recovery and a structure for data archiving. As |
| Server 2005): | | | | before, this is tested by an exam. |
| What is being tested? | | | | 3. Optimising and maintaining a database |
| A variety of skills will be tested in the following | | | | This module continues to study database |
| modules: | | | | performance optimisation and maintenance using SQL |
| 1. Database implementation and maintenance: | | | | Server 2005. It will analyse the performance of the |
| This module focuses on your ability to install and | | | | database, the server and queries. One of the main |
| configure Microsoft's very own SQL server 2005, | | | | focuses of this module will be - the implementation of |
| implement high availability and disaster recovery so as | | | | a database recovery plan, so as to protect the |
| to protect your database, support data consumers, | | | | database from any disasters. This module will then |
| maintain databases, create and implement database | | | | continue to analyse in depth strategies to maintain |
| objects, as well as assessing monitoring and | | | | and monitor a database solution, which includes |
| troubleshooting SQL server performance. This will all | | | | content management; will cultivate the ability to |
| be tested by an exam. | | | | design a strategy to manage data, as well as |
| After completing this module, you will gain a | | | | security. |