MCTS: SQL Server 2005 Business Intelligence

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 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. This includes knowledge of database schemas, debugging, monitoring, and troubleshooting Business Intelligence solutions, and working with the Microsoft .NET Framework. They can write database queries, use 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. 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 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 Business Intelligence

MCTS candidates must pass one exam that focuses on the implementation and maintenance of SQL Server 2005. See the following table for related training resources. For exam availability dates and specific areas of focus, see the Exam Preparation Guide.