Microsoft Certified IT Professional (MCITP): Database Administrator

As a Microsoft Certified IT Professional, you'll have an internationally recognised qualification that demonstrates your advanced technical expertise to current and future employers. This course concentrates on the administration of databases, and gives you the knowledge you need to confidently lead the way in their installation, configuration and maintenance.

 

What will I study?

SQL Server 2005:

  • Install and configure SQL Server 2005
  • Implement high availability and disaster recovery
  • Support data consumers
  • Maintain databases
  • Monitor and troubleshoot SQL Server performance
  • Create and implement database objects

Database Design

  • Design a database server infrastructure
  • Design security for a database server solution
  • Design a physical database
  • Design a database solution for high availability
  • Design a data recovery solution for a database
  • Design a strategy for data archiving

Database Optimisation and Maintenance

  • Optimise the performance of database servers and databases
  • Optimise and implement a data recovery plan for a database
  • Design a strategy to monitor and maintain a database solution
  • Design a database data-management strategy
  • Design a strategy to manage and maintain database security

Study with ICS in association with Hays

International Correspondence Schools Ltd (ICS) is the world's largest and most experienced distance learning organisation.  ICS is a pioneer in teaching skills by home study, presenting the opportunity to learn while earning and to relate study to everyday work. ICS-Hays-logos.jpg
Join the ICS Student Community

Create a guest account on the student community for free and communicate wwith current students on this course.