CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS10337 - Updating SQL Server 2008 BI Skills to SQL Server 2008 R2

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This 3 day ILT course focuses on the new features SQL Server 2008 R2 for BI specialists

Click here for a printer-friendly version of this page

Upcoming classes

	Number	Class Date	Location	Length	Cost	Sign up
	MS10337	Jul 09, 2012 - Jul 11, 2012	Bloomington	3 days	$1395.00	Register

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

Detailed Class Syllabus

Module 1: SQL Server 2008 R2 for BI Professionals

Introduction to SQL Server 2008 R2

SQL Server 2008 R2 and SharePoint 2010

Database Server Provisioning by Using SQL Server SysPrep

Application Management by Using Data-Tier Applications

Managing Multiple Servers by Using Utility Control Points

Module 2: Implementing Self-Service BI with PowerPivot

Introduction to PowerPivot

Power Pivot for Excel 2010

Data Analysis Expressions (DAX)

Power Pivot for SharePoint 2010

Module 3: SQL Server 2008 R2 Reporting Services Tool and API Enhancements

Deploying and Managing Reporting Services

Reporting Services Authoring Tool Enhancements

Enabling Self-Service BI Through Item Re-Use

Developing Custom Reporting Services Solutions

Module 4: SQL Server 2008 R2 Report Authoring Enhancements

Overview of Report Authoring Enhancements

Visualizing Data

Visualizing Spatial Data with Maps

Module 5: Building Complex Event Processing Solutions with StreamInsight

Introduction to StreamInsight

StreamInsight Core Concepts

Developing a StreamInsight Solution

Module 6: Master Data Services

Introduction to MDS

Key Concepts in Master Data Services

Importing and Browsing Data

Business Rules

Exporting Data to Subscribing Systems

Securing Master Data Services

Module 7: Enterprise Data Warehousing

SQL Server 2008 R2 Data Warehousing

Overview of Parallel Data Warehouse

Module 8: Introduction to SQL Azure

Overview of SQL Azure and Cloud Services

Using SQL Azure

Introduction to “Dallas”