SQL Server 2008

Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2
(Microsoft Training Course: 10337) - 3 days - £1425 exc VAT

> Target Audience
This course focuses on the new features of SQL Server 2008 R2 for BI specialists. It is intended for is BI Professionals who have 3-4 years of experience with SQL Server and have an understanding of how to use SQL Server 2008 BI tools to implement a BI infrastructure and solution.
> Course outline
  1. SQL Server 2008 R2 for BI Professionals
  2. Implementing Self-Service BI with PowerPivot
  3. SQL Server 2008 R2 Reporting Services Tool and API Enhancements
  4. SQL Server 2008 R2 Report Authoring Enhancements
  5. Building Complex Event Processing Solutions with StreamInsight
  6. Master Data Services
  7. Enterprise Data Warehousing
  8. Introduction to SQL Azure

Module 1: SQL Server 2008 R2 for BI Professionals
  • This module introduces the new features of SQL Server 2008 R2 and explains why they are important for developers and administrators of SQL Server-based BI solutions.
  • 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
  • Lab : Managing SQL Server 2008 R2
  • Identify the key features and scenarios addressed by SQL Server 2008 R2.
  • Describe the ways in which SQL Server 2008 R2 and SharePoint 2010 can be integrated to create a comprehensive self-service BI platform.
  • Use SQL Server SysyPrep to provision database and reporting servers.
  • Use data-tier applications to manage BI databases.
  • Use Utility Control Points to manage BI database server resource utilization.
Module 2: Implementing Self-Service BI with PowerPivot
  • This module helps BI professionals to understand the benefits of PowerPivot technologies and explains how to use them to improve the provision of BI services and support business processes.
  • Introduction to PowerPivot
  • Power Pivot for Excel 2010
  • Data Analysis Expressions (DAX)
  • Power Pivot for SharePoint 2010
  • Lab: Implementing Self-Service BI with PowerPivot
  • Install and configure PowerPivot for Excel and PowerPivot for SharePoint.
  • Use PowerPivot for Excel to create a PowerPivot workbook.
  • Use Data Analysis Expressions to build formulas in PowerPivot.
  • Use PowerPivot for SharePoint to manage PowerPivot workbooks.
Module 3: SQL Server 2008 R2 Reporting Services Tool and API Enhancements
  • This module discusses the tools and application programming interfaces (APIs) that you can use to manage and develop Microsoft SQL Server Reporting Services solutions.
  • Deploying and Managing Reporting Services
  • Reporting Services Authoring Tool Enhancements
  • Enabling Self-Service BI Through Item Re-Use
  • Developing Custom Reporting Services Solutions
  • Lab: Working with Reporting Services
  • Use the enhanced Reporting Services management tools.
  • Use the enhanced Reporting Services authoring tools.
  • Collaborate with other report developers by using shared datasets and report parts.
  • Use the enhanced Reporting Services development APIs.
Module 4: SQL Server 2008 R2 Report Authoring Enhancements
  • This module describes the enhancements for report authors in Microsoft SQL Server 2008 R2.
  • Overview of Report Authoring Enhancements
  • Visualizing Data
  • Visualizing Spatial Data with Maps
  • Lab: Authoring Reports
  • Use new features to create reports that include rotated text boxes, linked data from multiple datasets, include rollup aggregations, and custom pagination behavior.
  • Create reports that include graphic visualizations of data with Sparklines, Data Bars, and Indicators.
  • Create reports that include visualizations of spatial data.
Module 5: Building Complex Event Processing Solutions with StreamInsight
  • This module provides an introduction to Microsoft SQL Server StreamInsight, which is a powerful platform for implementing complex event processing (CEP) solutions.
  • Introduction to StreamInsight
  • StreamInsight Core Concepts
  • Developing a StreamInsight Solution
  • Lab: Building a StreamInsight Solution
  • Describe scenarios where Complex Event Processing can be used effectively.
  • Describe the core concepts related to Microsoft StreamInsight.
  • Create a basic StreamInsight application.
Module 6: Master Data Services
  • This module explains the value of Master Data Services to modern organizations and outlines the key benefits and scenarios for its use.
  • Introduction to MDS
  • Key Concepts in Master Data Services
  • Importing and Browsing Data
  • Business Rules
  • Exporting Data to Subscribing Systems
  • Securing Master Data Services
  • Lab: Working with Master Data Services
  • Describe the key scenarios and benefits of MDS.
  • Describe core MDS concepts.
  • Import data into MDS.
  • Implement MDS Business Rules.
  • Export MDS data.
  • Secure MDS.
Module 7: Enterprise Data Warehousing
  • This module explains the Microsoft SQL Server 2008 R2 features and technologies that you can use to build and maintain a high-performance data warehouse.
  • SQL Server 2008 R2 Data Warehousing
  • Overview of Parallel Data Warehouse
  • Describe the options available for data warehousing with SQL Server.
  • Describe the key features and functionality of Parallel Data Warehouse.
Module 8: Introduction to SQL Azure
  • This module describes SQL Azure, and discusses how you can use it to create cloud-based databases for BI applications. The module also introduces Microsoft “Dallas”, an online source of commercial data that you can use to extend the value of your BI solutions.
  • Overview of SQL Azure and Cloud Services
  • Using SQL Azure
  • Introduction to “Dallas”
  • Describe the key features of SQL Azure.
  • Describe how to use SQL Azure to implement a database for a BI application.
  • Describe how to use Microsoft “Dallas” to augment BI application data.
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • 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.
> Purpose
After completing this course, students will be able to describe the new features of SQL Server 2008 R2, and use them to manage BI applications; use SQL Server PowerPivot to create self-service BI solutions; use new and enhanced Reporting Services tools to create and manage self-service reporting solutions; use new report features to create compelling reports; use StreamInsight to create an application that captures and analyzes streams of event data; use Master Data Services to enable data consistency across the enterprise to help increase the accuracy of BI solutions; describe the options available for implementing large-scale data warehousing solutions built on SQL Server 2008 R2; integrate data from SQL Azure into a SQL Server BI solution.