Microsoft Training UK: SQL Server Certification Tracks

MCTS: SQL Server 2008, Business Intelligence Development and Maintenance, MCTS: SQL Server 2008, Database Development, MCTS: SQL Server 2008, Implementation and Maintenance

The Microsoft SQL Server 2008 certification tracks are built upon a foundation of three focused Microsoft Certified Technology Specialist (MCTS) certifications - all of which are designed to demonstrate your custom skill set and in-depth understanding of the features and functionality of key technology areas in SQL Server 2008.

An MCTS certification highlights your areas of specialty, so your expertise will stand out to hiring managers and project leads. By earning multiple MCTS certifications, you can demonstrate your breadth of knowledge of SQL Server 2008; you can also build on your MCTS certifications to earn a Professional Series credential.

The MCTS certifications also give you access to the MCP community and benefits, such as a personal profile on Microsoft.com and access to the Microsoft Knowledge Base. You are required to pass only one exam, making it possible for you to earn a meaningful certification within your time constraints and budget.

Three MCITP certification paths build on Microsoft Certified Technology Specialist (MCTS) prerequisites and align with job roles that are relevant in the marketplace.

Candidates for any of the MCTS certifications are professionals who work with SQL Server 2008, or who anticipate doing so in the near future. They should have at least one year of experience using the underlying technologies that are covered in the corresponding exam.

How to earn your MCTS certification on SQL Server 2008

To achieve any of the MCTS certifications on SQL Server 2008, you must pass a single exam, as shown in the following diagrams.



Please click on the boxes in the diagrams below to be taken to the relevant course outline.



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 implementation and maintenance of SQL Server 2005. This certification will retire when Microsoft discontinues mainstream support for the related technology.



Please click on the boxes in the diagram below to be taken to the relevant course outline.





MCTS: SQL Server 2005 Business Intelligence

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI) implement and maintain business intelligence solutions. They have thorough knowledge of the Microsoft SQL Server 2005 Business Intelligence Development tool suite.

They have knowledge of database schemas and of debugging, monitoring, and troubleshooting Business Intelligence solutions, and they know how to work with Microsoft .NET Framework. They can write database queries, use SQL Server Analysis Services (SSAS) data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages. Typically, Technology Specialists 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 Business Intelligence

MCTS candidates must pass one exam that focuses on the implementation and maintenance of SQL Server 2005. This certification will retire when Microsoft discontinues mainstream support for the related technology.



Please click on the boxes in the diagram below to be taken to the relevant course outline.