MCTS: SQL Server 2005

The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge of and expertise in the technologies with which they work.

Microsoft Certified Technology Specialists in 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 navigate the user interface. Technology Specialists are typically pursuing careers as a database administrator, database developer, or business intelligence developer. They may also be individuals such as developers and systems administrators who do not work with SQL Server on a daily basis but wish to show their breadth of technology experience.

MCTS candidates must pass one exam focusing on the implementation and maintenance of SQL Server 2005.

Required Exams

^{Exam
70–431:TS: Microsoft SQL Server

2005 - Implementation and Maintenance}

^{Writing Queries Using Microsoft SQL Server

2005 Transact-SQL (M2778)}

^{Implementing a Microsoft SQL Server 2005

Database
(M2779)}

^{Maintaining a Microsoft SQL Server 2005

Database
(M2780)}