MCTS: SQL Server 2008, Business Intelligence Development and Maintenance

Overview

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

The MCTS Business Intelligence certification allows you to demonstrate your expertise with SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.

SQL2008

Learn More

Find Your Local Center

Key Courses

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

Outline	2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Outline	6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Outline	6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
Outline	6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Who's It For?

The MCTS SQL Server 2008 Business Intelligence is for individuals who work with the business intelligence features of Microsoft SQL Server 2008. 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 2008 Business Intelligence certification candidate must pass a single exam.