MCTS: SQL Server 2005

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.

How to earn your MCTS: SQL Server 2005

MCTS candidates must pass one exam that focuses on the following:

  • Installing and Configuring SQL Server 2005
  • Implementing High Availability and Disaster Recovery
  • Supporting Data Consumers
  • Maintaining Databases
  • Monitoring and Troubleshooting SQL Server Performance
  • Creating and Implementing Database Objects