Microsoft Certified Technology Specialist: 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.

How to Earn Your MCTS: SQL Server 2005

MCTS candidates must pass one exam focusing on the implementation and maintenance of SQL Server 2005. See the table below for related training resources.

 

Microsoft Official Curriculum Course Name	Days	Exams
2779: Implementing a Microsoft SQL Server 2005 Database	3	70–431
2780: Maintaining a Microsoft SQL Server 2005 Database	3
or 2785AL Managing and Maintaining Microsoft SQL Server 2005 Free 90 days live lab access Free eLarning access to Collection 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL (18-hour series) Free MS Press Training Kit (Exam 70–431): Implementing and Maintaining Microsoft SQL Server 2005 Free Microsoft Official Distance Learning (MODL) 2785 manual	10 Evenings	70–431

* Evening class meets 2 evenings per week from 7:00 PM - 9:00 PM.  Daytime class is available by taking individual course.