O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

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 00:25:49
    3. Introducing ​SQL Server ​2008 R2 ​Stream​Insight 00:23:26
    4. Introducing SQL Server 2008 R2 Reporting Services 00:20:45
    5. Introducing ​SharePoint ​2010 ​Performance​Point​Services 00:13:00
  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 00:11:12
    2. Creating a Utility Control Point 00:08:30
  3. Lesson 3: SQL Server ​2008 R2 - ​Stream​Insight
    1. Real ​Time ​Analytics ​with SQL ​Server 2008 ​R2 Stream​Insight 00:17:26
    2. Demo: Introducing ​SQL Server ​2008 R2 ​Stream​Insight 00:04:48
    3. Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight​(Part I) 00:09:22
    4. Demo: ​Querying ​SQL Server ​2008 R2 ​Stream​Insight​Using LINQ 00:13:20
    5. Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight​(Part II) 00:07:29
    6. Advanced ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Queries 00:07:48
    7. Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part I) 00:07:14
    8. Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part II) 00:04:37
    9. Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part III) 00:05:38
    10. Working ​with SQL ​Server 2008 ​R2 Stream​InsightCTI ​Events and ​Advance ​Time ​Settings 00:05:27
    11. Demo: ​Creating a ​SQL Server ​2008 R2 ​Stream​Insight​Input ​Adapter 00:03:45
    12. Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part I) 00:04:57
    13. Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part II) 00:02:12
    14. Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part III) 00:05:07
    15. Demo: ​Choosing a ​SQL Server ​2008 R2 ​Stream​Insight​Development ​Model 00:03:58
    16. Demo: ​Using the ​SQL Server ​2008 R2 ​Stream​Insight​Event Flow ​Debugger 00:04:48
  4. Lesson 4: SQL Server 2008 R2 - Reporting Services
    1. What's ​New in SQL ​Server 2008 ​R2 ​Reporting ​Services 00:16:30
    2. Developing ​Reports ​with the ​New ​Features of ​SQL Server ​2008 R2 ​Reporting ​Services 00:16:24
    3. Demo: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services 00:16:30
    4. Visualizing ​Data with ​Maps in SQL ​Server 2008 ​R2 ​Reporting ​Services 00:15:33
    5. Demo: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services 00:14:25
    6. Working ​with Shared ​Components ​in SQL ​Server 2008 ​R2 ​Reporting ​Services 00:12:30
    7. Demo: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services 00:13:56
    8. Working ​with ATOM ​Data Feeds ​in SQL ​Server 2008 ​R2 ​Reporting ​Services 00:12:04
    9. Demo: Using SQL Server 2008 R2 Reporting Services Report Feeds 00:09:14
    10. Embedded ​Reporting ​in ​Applications 00:11:17
    11. Developing ​with the ​Microsoft ​Chart ​Controls in ​Visual ​Studio 2010 00:09:37
  5. Lesson 5: Excel 2010 and SQL Server
    1. What's ​New in the ​Excel 2010 ​Client 00:13:24
    2. Demo: What's New in the Excel 2010 Client 00:14:13
    3. Loading ​and ​Preparing ​Data for ​Analysis in ​SQL Server ​PowerPivot ​for Excel ​2010 00:17:41
    4. Demo: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010 00:17:25
    5. Creating ​Reports ​with SQL ​Server ​PowerPivot ​for Excel ​2010 00:09:15
    6. Demo: Creating Reports with SQL Server PowerPivot for Excel 2010 00:16:11
    7. Defining ​DAX ​Calculations ​with ​PowerPivot ​for Excel ​2010 00:15:25
    8. Demo: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010 00:15:23
  6. Lesson 6: SharePoint 2010 Insights and SQL Server
    1. Introducing ​SharePoint ​2010 ​Insights 00:12:51
    2. Demo: Introducing SharePoint 2010 Insights 00:24:16
    3. What's ​New in ​SharePoint ​2010 Excel ​Services 00:14:16
    4. Demo: What's New in SharePoint 2010 Excel Services 00:16:07
    5. What's ​New in ​SharePoint ​2010 ​Performance​Point​Services 00:11:21
    6. Demo: ​What's New ​in ​SharePoint ​2010 ​Performance​Point​Services 00:06:52
    7. Developing ​KPI's and ​Scorecards ​with ​SharePoint ​2010 ​Performance​Point​Services 00:30:24
    8. Demo: ​Developing ​KPI's and ​Scorecards ​with ​SharePoint ​2010 ​Performance​Point​Services 00:14:31
    9. Developing ​Reports and ​Dashboards ​with ​SharePoint ​2010 ​Performance​Point​Services 00:25:34
    10. Demo: ​Developing ​Reports and ​Dashboards ​with ​SharePoint ​2010 ​Performance​Point​Services 00:17:47
    11. Managing ​Excel 2010 ​PowerPivot ​Solutions ​in ​SharePoint ​2010 00:15:37
    12. Demo: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010 00:21:55