MCTS: SQL Server 2005 Business Intelligence

Updated: June 19, 2008
**
**

The Microsoft Certified Technology Specialist (MCTS) 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. 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.


MCTS exam 

Exam 70-445

Review the preparation guide for Exam 70-445: TS: Microsoft SQL Server 2005 – Implementation and Maintenance


Top of pageTop of page