Microsoft Certified IT Professional (MCITP): Database Administrator

Computer certification programs are setting the standards for the information technology (IT) industry worldwide. Although most careers in the IT and communications fields are lucrative and lead to rapid advancement, you can move ahead even more rapidly if you have been certified. In fact, you often can earn a salary increase of 20% or more once you become certified. Nowadays, having a degree in computer science just isn't enough. Companies are demanding that their IT professionals be certified as a way to measure their skills as well as to guarantee that they can perform their jobs successfully. In short, certification will help a computer professional get a good job and stay competitive in what is now a highly demanding IT environment.

This training would be beneficial for individuals looking for IT job positions such as: Database Administrator, Microsoft Database Administrator or a Database Manager.

Microsoft Certified IT Professional (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.

Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-sized to large organizations.

Some of the responsibilities of a Microsoft SQL Server database administrator:

  • Install or configure, and manage or maintain databases
  • Multidimensional databases
  • User accounts
  • Database availability, recovery, and reporting
  • Design or implement security or server automation
  • Monitor and troubleshoot SQL Server activity

Exam 70-431: Microsoft SQL Server 2005: Implementation and Maintenance

This course provides students with the knowledge to:

  • Install and configure SQL Server
  • Set up tables, indexes, columns, and constraints
  • Use Transact-SQL to implement functions, stored procedures, and triggers
  • Work with relational and XML data
  • Monitor, troubleshoot, and tune queries
  • Maintain database availability with log shipping, mirroring, and replication
  • Prepare a backup strategy and restore a database

Exam 70-443: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

This course provides students with the knowledge to:

  • Install, consolidate, and configure multiple database instances
  • Design tables, file groups, and indexes for a physical database
  • Develop and implement security policies at the server, database, and object levels
  • Design, implement, and configure clustering, log shipping, mirroring, and replication
  • Develop plans for data archiving, backups, and disaster recovery

Exam 70-444: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

This course provides students with the knowledge to:

  • Monitor and troubleshoot queries, databases, and servers
  • Manage security strategies and perform audits
  • Help defend against attacks, worms, and viruses
  • Detect and resolve data conflicts
  • Diagnose faults and recover from database failures and disasters
  • Optimize availability with failover clustering, mirroring, log shipping, and replication
  • Customize maintenance and automate routine tasks
  • Build, debug, and deploy SQL Server Integration Services packages

Site Code:
JOBS