Microsoft's professional qualification
MCITP
Database Administrator 2008
- Contact UsView Certifications
- The cornerstone for Microsoft Certified Solutions Expert certifications.
Would you like us to send you information on this certification and be informed of any future updates and retirements?
Certification summary
The Microsoft Certified IT Professional (MCITP): Database Administrator 2008 certification training course gives you the skills to install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. In addition MCITP : Database Administrators 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.
Exams summary
To get a MCITP: Database Administrator 2008 certification you need to complete these two exams:
Exam 432: SQL Server 2008 - Implementation and Maintenance
Exam 450: SQL Server 2008 - Designing, Optimizing and Maintaining a Database Administrative Solution
A closer look...
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.
Career & Job Opportunities
The Microsoft Certified IT Professional (MCITP) is a globally recognised qualification across the IT, Finance and Telecoms industry. A variety of government organisations, training institutions and corporations around the UK recommend or require MCITP certifications for their staff or channel partners. These includes Amazon, Dell, HP, BT and the Cabinet Office. As of 2015, the average salary of a Microsoft MCITP Professional is £39,800pa with more than 89% being offered a salary of more than £26,000pa. The average salary for a MCITP graduate is estimated to be £24,500pa. After graduation, you can find work in roles such as Support Engineer and Infrastructure Technician with relative ease.
Start the MCTIP Database Administrator 2008 with a trial
We are offering a trial of this course for free with no purchase necessary, just sign up below to instantly receive your login details.
We will work with you to ensure that you can find work in IT after completing your Microsoft course
Working with JobcentrePlus and our Recruitment Partners across the UK, we will work with you to ensure that you can find work in IT (an not in any job) through job interviews and applications. We aim to get you in an IT job role on completion of your MCITP. If you have no qualification or background in IT, we will provide you with the necessary training for the experience required. For existing MCITP professionals, we can upgrade your qualifications and improve your career prospects. Do not allow your lack of experience or self-confidence deny you from a career in I.T - it is a lot easier (and enjoyable too) than most people think, once you learn the basics.
- ↘ Take on a new adventure with the MCITP interactive video demos
- ↘ Contact us about our Microsoft student placement service
Promotions. Gain access to the MCITP and Microsoft course library for 10 days.
If your aim is employment/career advancements through IT training, see how you can achieve this together with your tutor.
89.0%
The two exams
The MCITP Database Administrator 2008 Training is the latest generation in Microsoft server technology and as such there is no current retirement plan for its exams. Below is a breakdown of the exams for this certification and how they are made up.
Exam 432
This exam measures your ability to accomplish the technical tasks listed:
- Installing and configuring SQL Server 2008.
- Maintaining SQL Server instances.
- Managing SQL Server security.
- Maintaining a SQL Server database.
- Performing data management tasks.
- Monitoring and troubleshooting SQL Server.
- Optimising SQL Server performance.
- Implementing high availability.
Exam 432
This exam measures your ability to accomplish the technical tasks listed: Installing and configuring SQL Server 2008, Maintaining SQL Server instances, Managing SQL Server security, Maintaining a SQL Server database, Performing data management tasks, Monitoring and troubleshooting SQL Server, Optimising SQL Server performance, Implementing high availability. Here are the percentages that make up the final mark for this exam:
- Installing and configuring SQL Server 2008 (11%)
- Install SQL Server 2008 and related services
- Configure SQL Server instances
- Migrate user profiles
- Configure SQL Server services
- Configure additional SQL Server components
- Implement database mail
- Configure full-text indexing
- Maintaining SQL Server instances (9%)
- Manage SQL Server Agent jobs
- Manage SQL Server Agent alerts
- Manage SQL Server Agent operators
- Implement the declarative management framework (DMF)
- Back up a SQL Server environment
- Managing SQL Server security (18%)
- Manage logins and server roles
- Manage users and database roles
- Manage SQL Server instance permissions
- Manage database permissions
- Manage schema permissions and object permissions
- Audit SQL Server instances
- Manage transparent data encryption (TDE)
- Configure surface area
- Maintaining a SQL Server database (17%)
- Back up databases
- Restore databases
- Back up databases
- Manage and configure databases
- Manage database snapshots
- Maintain database integrity
- Maintain a database by using maintenance plans
- Performing data management tasks (10%)
- Import and export data
- Manage data partitions
- Implement data compression
- Maintain indexes
- Manage collations
- Monitoring and troubleshooting SQL Server (14%)
- Identify SQL Server service problems
- Identify concurrency problems
- Identify SQL Agent job execution problems
- Locate error information
- Optimising SQL Server performance (12%)
- Implement Resource Governor
- Use the Database Engine Tuning Advisor
- Collect trace data by using SQL Server Profiler
- Collect performance data by using Dynamic Management Views
- Collect performance data by using System Monitor
- Use Performance Studio
- Implementing high availability (9%)
- Implement database mirroring
- Implement an SQL Server clustered instance
- Implement log shipping
- Implement replication
Try this course online, login via providing some basic student details below
Exam 450
This exam measures your ability to accomplish the technical tasks listed:
- Design a SQL Server instance and a database solution.
- Design a database server security solution.
- Design a database solution for high availability.
- Design a backup and recovery solution.
- Design a monitoring strategy.
- Design a strategy to maintain and manage databases.
- Design a strategy for data distribution.
Exam 450
This exam measures your ability to accomplish the technical tasks listed: Design a SQL Server instance and a database solution, Design a database server security solution, Design a database solution for high availability, Design a backup and recovery solution, Design a monitoring strategy, Design a strategy to maintain and manage databases, Design a strategy for data distribution. Here are the percentages that make up the final mark for this exam:
- Design a SQL Server instance and a database solution (14%)
- Design for CPU, memory and storage capacity requirements
- Design SQL Server instances
- Design physical database and object placement
- Design a migration, consolidation and upgrade strategy
- Design a database server security solution (15%)
- Design instance authentication
- Design instance-level security configurations
- Design database, schema and object security parameters
- Design a security policy and an audit plan
- Design an encryption strategy
- Design a database solution for high availability (15%)
- Design a failover clustering solution
- Design database mirroring
- Design a high-availability solution that is based on replication
- Design a high-availability solution that is based on log shipping
- Select high-availability technologies based on business requirements
- Design a backup and recovery solution (20%)
- Design a backup strategy
- Design a recovery strategy
- Design a recovery test plan
- Design a monitoring strategy (13%)
- Design a monitoring solution at the operating system level
- Install SQL Server and related services
- Design a monitoring solution at the instance level
- Design a solution to monitor performance and concurrency
- Design a strategy to maintain and manage databases (14%)
- Design a maintenance strategy for database servers
- Design a solution to govern resources
- Design policies by using Policy-Based Management
- Design a data compression strategy
- Design a management automation strategy
- Design a strategy for data distribution (9%)
- Administer SQL Server Integration Services (SSIS) packages
- Design a strategy to use linked servers
- Design a replication strategy for data distribution
Try this course online, login via providing some basic student details below
This course is suitable for...
School leavers
A fun and enjoyable way to build a fresh career
Teachers & IT professionals
A prestigious qualification which will distinguish you from the crowd of 21st century geeks
Anyone else...
Looking to start a healthy, rewarding & lucrative career in I.T
But is this course right for you?
Will it provide you with the skills that you need, or the career you'd like to explore? If you are not 100% sure that it's correct for you then we highly recommend that you experience our trial courses and assessments to get an accurate insight to the MCITP certification. You can sign up for this below or use it to ask our lecturers some questions. You can also call us on 0800 622 69 69 and speak to one of our course advisers and they will help you choose the perfect certification tailored to your needs.
More Information
Request more info on the MCITP: Database Administrator 2008 course
Exam tips and syllabus
Get the MCITP: Database Administrator 2008 exam syllabus aswell as helpful tips
What our students say
See what our students have to say about the MCITP: Database Administrator 2008