The Microsoft Certified IT Professional (MCITP) certification specializing in Database Administration verifies your skills in installing and configuring SQL Server.
You'll be able to manage and maintain databases, user accounts, database availability, recovery, and reporting. You'll also be able to design and implement security and server automation.
Our training is delivered through our On-line 24/7 training platform.
MCITP Database Administration Certification Outline
You must pass THREE Microsoft Exams to be awarded this MCITP
MCTS Exam 70-431 - Microsoft SQL Server - Implementation and Maintenance (Prerequisite)
Course Outline:
- Installing and Configuring SQL Server
- Creating Databases
- Working with Table and Programmability
- Implementing Database Objects
- Supporting the XML Framework
- Enhancing data consumption and throughput
- Managing and Backing Up Databases
- Monitoring Performance
- Troubleshooting and Optimizing
- Implementing High Availability
MCITP Exam 70-443 - Designing a Database Server Infrastructure by Using Microsoft SQL Server
Course Outline:
- Designing the Hardware and Software Infrastructure
- Designing Physical Storage
- Designing a Consolidation Strategy
- Designing Database-Level Security
- Designing Windows Server-Level Security Processes
- Designing SQL Server Service-Level Security
- Designing SQL Server Object-Level Security
- Designing a Physical Database
- Creating Database Conventions and Standards
- Designing a SQL Server Solution for High Availability
- Designing a Data Recovery Solution for a Database
- Designing a Data-Archiving Solution
MCITP Exam 70-444 - Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server
Course Outline:
- Optimizing the Performance of Databases and Database
- Optimizing the Performance of Queries
- Optimizing and Implementing a Data Recovery Plan for a Database
- Designing a Strategy to Monitor a Database Solution
- Designing a Strategy to Maintain a Database Solution
- Designing and Managing SSIS Packages
- Designing a Database Data Management Strategy
- Designing a Strategy to Manage Replication
- Protecting Your SQL Server from Attack
- Designing a Strategy to Manage and Maintain Database Security
We are so confident that you will pass your exam we guarantee it!
Other Training Benefits
- Specialised Teacher Support - You will have support for all your questions
- Hands on skills - Software simulations in real world scenarios
- Exam preparation - We don't send you to the exam unless we know you will get a high mark.
- Cost effective - You don't have to break your budget to get started
- Flexibility - You don't have to take time off work or disrupt your schedule
Take the next step now!
Register for more information and receive FREE of charge our e-book
"11 Breakthrough strategies for Interview Success"