SQL Server 2008 R2 Update for Developers Training Kit January 2011 Update Now Available

  • Article

 

This update includes a rich new set of content designed for developers who want to learn how to build their first Microsoft Business Intelligence solution with SQL Server 2008 R2.   Microsoft BI solutions leverage your existing technology investments in .NET, SQL Server and Office to develop rich integrated reporting and analytics experiences that empower users to gain access to accurate, up-to-date information for better, more relevant decision making. This content is a complete training course that contains eleven units covering all the key aspects of Microsoft BI solution development. 

Download it here: https://go.microsoft.com/?linkid=9710868

Here is a summary of what’s included:

  • 31 presentations (PowerPoint slides, videos and transcripts included)
  • 7 demos (installer scripts, videos and transcripts included)
  • 12 hands on labs (installer scripts included)

Here is a breakdown of each unit and its associated content:

clip_image002[6]

Build Your First Microsoft BI Solution with SQL Server 2008 R2

  • Presentation: Understanding Business Intelligence
  • Demo: Delivering Information to Decision Makers with a Microsoft BI Solution
  • Presentation: Introducing Microsoft BI Solution Development
  • Demo: Introducing the Microsoft BI Development Toolset

clip_image004

Introduction to BI Modeling Techniques

  • Presentation: Designing Data Models for Microsoft BI Solutions
  • Demo: Exploring a Sample Dimensional Data Model
  • Presentation: Designing Semantic Models for Microsoft BI Solutions
  • Demo: Creating a Data Model with the Microsoft Entity Framework
  • Hands On Lab: Your First Look at the SQL Server 2008 R2 Sample Databases
  • Hands On Lab: Building Your First Semantic Model with the ADO.NET Entity Framework

clip_image006

Introduction to SQL Server 2008 R2 Integration Services

  • Presentation: Introducing ETL Processing with SQL Server 2008 R2 Integration Services
  • Presentation: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package
  • Demo: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package
  • Presentation: Implementing Data Flow Tasks in a SQL Server 2008 R2 Integration Services Package
  • Presentation: Loading Fact and Dimension Tables in a SQL Server 2008 R2 Integration Services Package
  • Demo: Implementing Data Flow in a SQL Server 2008 R2 Integration Services Package
  • Hands On Lab: Building Your First Extract-Transform-Load Process with SQL Server 2008 R2 Integration Services

clip_image008

Introduction to SQL Server 2008 R2 Reporting Services

  • Presentation: Reporting Fundamentals with SQL Server 2008 R2 Reporting Services
  • Presentation: SQL Server 2008 R2 Reporting Services Report Design Basics
  • Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with a Relational Data Source
  • Presentation: Adding interactivity to a SQL Server 2008 R2 Reporting Services Report
  • Demo: Adding Interactivity to a SQL Server 2008 R2 Reporting Services Report
  • Presentation: Extending SQL Server 2008 R2 Reporting Services Reports with Custom Logic
  • Hands On Lab: Building Your First Relational Report with SQL Server 2008 R2 Reporting Services

clip_image010

Publishing and Accessing SQL Server 2008 R2 Reporting Services Reports

  • Presentation: Publishing SQL Server 2008 R2 Reporting Services Reports
  • Demo: Publishing SQL Server 2008 R2 Reporting Services Reports
  • Presentation: Enabling Self-Service Reporting with SQL Server 2008 R2 Shared Components
  • Demo: Enabling Self-Service Reporting by Publishing SQL Server 2008 R2 Reporting Services Shared Components
  • Presentation: Accessing SQL Server 2008 R2 Reporting Services Reports Programmatically
  • Demo: Developing Embedded SQL Server 2008 R2 Reporting Services Applications
  • Hands On Lab: Building Your First Reporting Application with the Visual Studio 2010 ReportViewer Control

clip_image012

Introduction to SQL Server 2008 R2 Analysis Services

  • Presentation: Analysis Fundamentals with SQL Server 2008 R2 Analysis Services
  • Presentation: Understanding the Components of a SQL Server 2008 R2 Analysis Services Database
  • Demo: Developing a SQL Server 2008 R2 Analysis Services Database
  • Presentation: Introduction to SQL Server 2008 R2 Analysis Services Programming
  • Demo: Developing a Time Dimension with SQL Server 2008 R2 Analysis Services
  • Demo: Enhancing the End User Experience of a SQL Server 2008 R2 Analysis Services Cube
  • Hands On Lab: Building Your First Cube with SQL Server 2008 R2 Analysis Services

clip_image014

Introduction to SQL Server 2008 R2 Analysis Services Query Syntax

  • Presentation: Introduction to SQL Server 2008 R2 Analysis Services MDX
  • Presentation: Exploring SQL Server 2008 R2 Analysis Services MDX Query Techniques
  • Demo: Introducing SQL Server 2008 R2 Analysis Services MDX Query Development
  • Presentation: Exploring SQL Server 2008 R2 Analysis Services Cube Calculations
  • Demo: Enriching a SQL Server 2008 R2 Analysis Services Cube with Calculations
  • Hands On Lab: Building Your First Queries and Calculations with SQL Server 2008 R2 Analysis Services MDX

clip_image016

Accessing SQL Server 2008 R2 Analysis Services Data

  • Presentation: Developing SQL Server 2008 R2 Reporting Services Reports for Analysis Services
  • Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with an Analysis Services Cube
  • Presentation: Using Excel 2010 as an Analysis Services Client
  • Demo: Creating an Excel 2010 PivotTable Using a SQL Server 2008 R2 Analysis Services Cube
  • Presentation: Using SharePoint 2010 Excel Services with Analysis Services Data
  • Demo: Publishing and Sharing SQL Server 2008 R2 Analysis Services Cube Data with SharePoint 2010 Excel Services
  • Hands On Lab: Building Your First Multidimensional Report with SQL Server 2008 R2 Reporting Services

clip_image018

Introduction to SharePoint 2010 PerformancePoint Services

  • Presentation: Performance Management Fundamentals with SharePoint 2010 PerformancePoint Services
  • Demo: Delivering an Interactive Performance Management Dashboard with SharePoint 2010 PerformancePoint Services
  • Presentation: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
  • Demo: Developing KPIs and Scorecards with SharePoint 2010 PerformancePoint Services
  • Presentation: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
  • Demo: Developing Interactive Reports and Dashboards with SharePoint 2010 PerformancePoint Services
  • Hands On Lab: Building Your First Dashboard with SharePoint 2010 PerformancePoint Services

clip_image020

Introduction to Data Mining with SQL Server 2008 R2 Analysis Services

  • Presentation: Data Mining Fundamentals with SQL Server 2008 R2 Analysis Services
  • Demo: Developing Data Mining Models with SQL Server 2008 R2 Analysis Services
  • Presentation: Programming SQL Server 2008 R2 Analysis Services Data Mining
  • Demo: Embedding SQL Server 2008 R2 Analysis Services Data Mining in a Custom Application
  • Hands On Lab: Building Your First Data Mining Model with SQL Server 2008 R2 Analysis Services

clip_image022

Introduction to Self-Service Reporting and Analysis with SQL Server 2008 R2

  • Presentation: Self-Service Reporting Fundamentals with SQL Server 2008 R2
  • Demo: Self-Service Reporting with Report Builder 3.0
  • Presentation: Self-Service Analysis Fundamentals with SQL Server 2008 R2
  • Demo: Self-Service Analysis with SQL Server 2008 R2 PowerPivot for Excel 2010
  • Demo: Publishing and Sharing SQL Server 2008 R2 PowerPivot Workbooks with SharePoint 2010 Excel Services
  • Hands On Lab: Building and Sharing Your First Report Builder 3.0 Report
  • Hands On Lab: Building and Sharing Your First SQL Server 2008 R2 PowerPivot for Excel Workbook