MOC 10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2

    

Summary:
This ILT course focuses on the new features SQL Server 2008 R2 for BI specialists.

Duration:
2 Days/Lecture & Lab

Audience:
The primary audience for this course is BI Professionals who have 3-4 years of experience with SQL Server. The audience has an understanding of how to use SQL Server 2008 BI tools to implement a BI infrastructure and solution.

Topics:

• Overview of SQL Server 2008 R2
• Implementing Self-Service BI with PowerPivot
• SQL Server 2008 R2 Reporting Services Tool and API
• SQL Server 2008 R2 Report Authoring Enhancements
• Building Complex Event Processing Solutions with
• Master Data Services
• Introduction to SQL
• Managing SQL Server 2008

Prerequisites:
Before attending this course, students must have:-Three to four years of experience using SQL Server 2008 BI components-Knowledge of relational and multi-dimensional database schemas-Experience creating and deploying SQL Server Reporting Services (SSRS) reports- Experience debugging, monitoring, and troubleshooting BI solutions-Experience working with the Microsoft .NET Framework-Experience in using the following tools:-Microsoft SQL Server 2008 BI Development Studio-Microsoft SQL Server 2008 Management Studio-Report Builder and Report Manager-Possible experience in using Microsoft Visual Studio

Last Update: May 22, 2012