Loading Course Schedule...
PT7733
Training Summary
This ILT course focuses on the new features SQL Server 2008 R2 for BI specialists.
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
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.
Course 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