MCTS: SQL Server 2005 Certification Requirements
The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.
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.
Microsoft Skills Assessments for SQL Server 2005 help database administrators, database developers, and business intelligence developers focus their exam preparation training and find learning resources.
| • | Take a Microsoft Skills Assessment |
| • | New Generation of Certification FAQ |
How to earn your MCTS: SQL Server 2005
MCTS candidates must pass one exam that focuses on the implementation and maintenance of SQL Server 2005. The following table lists Official Microsoft Learning Products and Microsoft Press books that are designed to help you prepare for the required exams. See the individual exam preparation guides for exam availability.
| Required exams for MCTS: SQL Server 2005 (one exam required) | Classroom training | Microsoft Official Distance Learning | Microsoft E-Learning | Microsoft Press books |
Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance | Course 2779: Implementing a Microsoft SQL Server 2005 Database Course 2780: Maintaining a Microsoft SQL Server 2005 Database | Course 2785: Implementing and Maintaining Microsoft SQL Server 2005 | Collection 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL (18-hour series) | MCTS Self–Paced Training Kit (Exam 70–431): Implementing and Maintaining Microsoft SQL Server 2005 Microsoft SQL Server 2005: Applied Techniques Step by Step Inside Microsoft SQL Server 2005: The Storage Engine Programming Microsoft SQL Server 2005 |
