Microsoft SQL Server 2008 R2: In-Depth Training for Developers

Microsoft SQL Server 2008 R2: In-Depth Training for Developers

Released March 2011
Publisher(s): Microsoft Corporation
ISBN: 01201000048TG

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

The goal of the SQL Server 2008 R2 Update for Developers Training Course is to provide information about the improvements introduced in SQL Server 2008 and the new features added in SQL Server 2008 R2. Its primary audience is solution architects and developers who are familiar with SQL Server, and also developers who are new to SQL Server and want to learn the basics. The content focuses on development aspects and illustrates how to design more effective database applications that take advantage of improved capabilities in SQL Server. This version of the training course is designed to work best with the SQL Server 2008 R2.

Table of contents

  1. Lesson 1: SQL Server 2008 R2 - Overview
    1. SQL ​Server 2008 ​R2 Update ​for ​Developers ​Overview ​Part II - ​Introducing ​SQL Server ​2008 R2 00:22:54
    2. Introducing SQL Server 2008 R2 Application and Multi-Server Management
    3. Introducing ​SQL Server ​2008 R2 ​Stream​Insight
    4. Introducing SQL Server 2008 R2 Reporting Services
    5. Introducing ​SharePoint ​2010 ​Performance​Point​Services
  2. Lesson 2: SQL Server 2008 R2 - Application and Multi-Server Management
    1. Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
    2. Creating a Utility Control Point
  3. Lesson 3: SQL Server ​2008 R2 - ​Stream​Insight
    1. Real ​Time ​Analytics ​with SQL ​Server 2008 ​R2 Stream​Insight
    2. Demo: Introducing ​SQL Server ​2008 R2 ​Stream​Insight
    3. Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight​(Part I)
    4. Demo: ​Querying ​SQL Server ​2008 R2 ​Stream​Insight​Using LINQ
    5. Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight​(Part II)
    6. Advanced ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Queries
    7. Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part I)
    8. Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part II)
    9. Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part III)
    10. Working ​with SQL ​Server 2008 ​R2 Stream​InsightCTI ​Events and ​Advance ​Time ​Settings
    11. Demo: ​Creating a ​SQL Server ​2008 R2 ​Stream​Insight​Input ​Adapter
    12. Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part I)
    13. Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part II)
    14. Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part III)
    15. Demo: ​Choosing a ​SQL Server ​2008 R2 ​Stream​Insight​Development ​Model
    16. Demo: ​Using the ​SQL Server ​2008 R2 ​Stream​Insight​Event Flow ​Debugger
  4. Lesson 4: SQL Server 2008 R2 - Reporting Services
    1. What's ​New in SQL ​Server 2008 ​R2 ​Reporting ​Services
    2. Developing ​Reports ​with the ​New ​Features of ​SQL Server ​2008 R2 ​Reporting ​Services
    3. Demo: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services
    4. Visualizing ​Data with ​Maps in SQL ​Server 2008 ​R2 ​Reporting ​Services
    5. Demo: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    6. Working ​with Shared ​Components ​in SQL ​Server 2008 ​R2 ​Reporting ​Services
    7. Demo: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services
    8. Working ​with ATOM ​Data Feeds ​in SQL ​Server 2008 ​R2 ​Reporting ​Services
    9. Demo: Using SQL Server 2008 R2 Reporting Services Report Feeds
    10. Embedded ​Reporting ​in ​Applications
    11. Developing ​with the ​Microsoft ​Chart ​Controls in ​Visual ​Studio 2010
  5. Lesson 5: Excel 2010 and SQL Server
    1. What's ​New in the ​Excel 2010 ​Client
    2. Demo: What's New in the Excel 2010 Client
    3. Loading ​and ​Preparing ​Data for ​Analysis in ​SQL Server ​PowerPivot ​for Excel ​2010
    4. Demo: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
    5. Creating ​Reports ​with SQL ​Server ​PowerPivot ​for Excel ​2010
    6. Demo: Creating Reports with SQL Server PowerPivot for Excel 2010
    7. Defining ​DAX ​Calculations ​with ​PowerPivot ​for Excel ​2010
    8. Demo: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010
  6. Lesson 6: SharePoint 2010 Insights and SQL Server
    1. Introducing ​SharePoint ​2010 ​Insights
    2. Demo: Introducing SharePoint 2010 Insights
    3. What's ​New in ​SharePoint ​2010 Excel ​Services
    4. Demo: What's New in SharePoint 2010 Excel Services
    5. What's ​New in ​SharePoint ​2010 ​Performance​Point​Services
    6. Demo: ​What's New ​in ​SharePoint ​2010 ​Performance​Point​Services
    7. Developing ​KPI's and ​Scorecards ​with ​SharePoint ​2010 ​Performance​Point​Services
    8. Demo: ​Developing ​KPI's and ​Scorecards ​with ​SharePoint ​2010 ​Performance​Point​Services
    9. Developing ​Reports and ​Dashboards ​with ​SharePoint ​2010 ​Performance​Point​Services
    10. Demo: ​Developing ​Reports and ​Dashboards ​with ​SharePoint ​2010 ​Performance​Point​Services
    11. Managing ​Excel 2010 ​PowerPivot ​Solutions ​in ​SharePoint ​2010
    12. Demo: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010

Product information

  • Title: Microsoft SQL Server 2008 R2: In-Depth Training for Developers
  • Author(s):
  • Release date: March 2011
  • Publisher(s): Microsoft Corporation
  • ISBN: 01201000048TG