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.

MCTS candidates must pass one exam that focuses on the implementation and maintenance of SQL Server 2005.

Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence—Implementation and Maintenance

None

There are three courses each of 3 days duration. For distance learning and E-Learning courses please refer to the Microsoft Learning web site.

MS2791 Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services [3 days]

AND

MS2792 Implementing and Maintaining Microsoft SQL Server 2005 Integration Services [3 days]

AND

MS2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services [3 days]

THEN

EXAM 70-445: TS: Microsoft SQL Server 2005 Business Intelligence—Implementation and Maintenance