MCTS: SQL Server 2005 Business Intelligence

Overview

New Horizons is ready to help you prepare for your MCTS SQL Server 2005 Business Intelligence certification.

If you work with SQL Server 2005 Reporting Services, Analysis Services, and Integration Services, obtaining your MCTS SQL Server 2005 Business Intelligence certification is the ideal way to advance your SQL Server career.

SQL2005

Learn More

Find Your Local Center

Key Courses

Depending on your experience level, less or more coursework may be required.

Outline	2791 Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
Outline	2792 Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
Outline	2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

Who's It For?

The MCTS SQL Server 2005 Business Intelligence certification is for individuals who work with SQL Server Reporting Services, Analysis Services and Integration Services. With certification training at New Horizons, the student will learn:

SQL Server Analysis Services
- Analysis Services dimensions, measures, cubes and measure groups
- MDX queries
- Data mining
SQL Server Integration Services
- Designing and controlling SSIS packages
- Package error handling and security
SQL Server Reporting Services
- Designing basic and advanced reports
- Publishing, executing and subscribing to reports

Certification and Exams

The MCTS SQL Server 2005 Business Intelligence certification candidate must pass a single exam.