Blog Post

SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update 2)

,

SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update 2)

  • 15 Presentation 
  • 24 Demo
  • 13 Hands-on Labs
  • 35 Videos

The training kit includes the following content:

  • Presentations (15)
    • SQL Server 2008 R2 Update for Developers Overview Part I - SQL

      Server 2008 Review

    • SQL Server 2008 R2 Update for Developers Overview Part II -

      Introducing SQL Server 2008 R2

    • SQL Server 2008: Filestream
    • SQL Server 2008: Spatial
    • SQL Server 2008: T-SQL
    • SQL Server 2008: Date and Time Types
    • SQL Server 2008: SQLCLR
    • SQL Server 2008: Reporting Services
    • SQL Server 2008 R2: Introducing Application and Multi-Server

      Management with SQL Server 2008 R2 and Visual Studio 2010

    • SQL Server 2008 R2: Working with Data Tier Application Projects in

      Visual Studio 2010

    • SQL Server 2008 R2: Managing Change in Data Tier Application

      Projects with Visual Studio 2010 and SQL Server 2008 R2

    • SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2

      StreamInsight

    • SQL Server 2008 R2: Designing SQL Server 2008 R2 StreamInsight Event

      Models and Adapters

    • SQL Server 2008 R2: Installing, Deploying and Maintaining the SQL

      Server 2008 R2 StreamInsight Runtime Engine

  • Demos (24)
    • SQL Server 2008: AdventureWorks Racing All-Up Demo
    • SQL Server 2008: Spatial Demo
    • SQL Server 2008: Spatial Types
    • SQL Server 2008: Introduction to Filestream
    • SQL Server 2008: SQL CLR Nullable Types
    • SQL Server 2008: Programming with Filestream
    • SQL Server 2008: Reporting Services Web Application Integration
    • SQL Server 2008: T-SQL Date and Time Support
    • SQL Server 2008: T-SQL Table-Valued Parameters
    • SQL Server 2008: T-SQL Row Constructors
    • SQL Server 2008: T-SQL Grouping Sets
    • SQL Server 2008: T-SQL Merge
    • SQL Server 2008 R2: Creating a Utility Control Point
    • SQL Server 2008 R2: Enrolling a Managed Instance
    • SQL Server 2008 R2: Creating Data-Tier Applications
    • SQL Server 2008 R2: Data-Tier Application Deployment
    • SQL Server 2008 R2: Managing Change in Data Tier Application

      Projects in Visual Studio 2010

    • SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2

      StreamInsight

    • SQL Server 2008 R2: Advanced SQL Server 2008 R2 StreamInsight Event

      Queries

    • SQL Server 2008 R2: Working with SQL Server 2008 R2 StreamInsight

      CTI Events and Advance Time Settings

    • SQL Server 2008 R2: Creating a SQL Server 2008 R2 StreamInsight

      Input Adpater

    • SQL Server 2008 R2: Choosing a SQL Server 2008 R2 StreamInsight

      Development Model

    • SQL Server 2008 R2: Using the SQL Server 2008 R2 StreamInsight Event

      Flow Debugger

  • Hands-on Labs (13)
    • SQL Server 2008: How to build your first Web Application with SQL

      Server and ASP.NET

    • SQL Server 2008: Using Spatial Data in TSQL
    • SQL Server 2008: Using Spatial Data in Managed Code
    • SQL Server 2008: Using SQL CLR in SQL Server 2008
    • SQL Server 2008 R2: Introduction to PowerPivot
    • SQL Server 2008 R2: Introduction to Reporting Services Improvements
    • SQL Server 2008 R2: Introduction to StreamInsight and Complex Event

      Processing

    • SQL Server 2008 R2: Introduction to Data-tier Applications
    • SQL Server 2008 R2: Creating and Deploying a Data-Tier Application
    • SQL Server 2008 R2: Managing Change in Data-Tier Application

      Projects in Visual Studio 2010

    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2

      StreamInsight using LINQ

    • SQL Server 2008 R2: Working with the SQL Server 2008 R2

      StreamInsight Samples

    • SQL Server 2008 R2: Working with the SQL Server 2008 R2

      StreamInsight Event Flow Debugger

  • Videos (35)
    • SQL Server 2008 R2 Update for Developers Overview Part I - SQL

      Server 2008 Review

    • SQL Server 2008 R2 Update for Developers Overview Part II -

      Introducing SQL Server 2008 R2

    • Introducing SQL Server 2008 R2 StreamInsight
    • Demo: Real Time Analytics with SQL Server 2008 R2 StreamInsight
    • Introducing SQL Server 2008 R2 Application and Multi-Server

      Management

    • Introducing SQL Server 2008 R2 Reporting Services
    • Introduction To SQL Server 2008 R2 StreamInsight and Complex Event

      Processing

    • Introducing PowerPivot for Excel 2010 and SharePoint 2010
    • Presentation: Introducing Application and Multi-Server Management

      with SQL Server 2008 R2 and Visual Studio 2010

    • Demo: Creating a Utility Control Point
    • Demo: Enrolling a Managed Instance
    • Presentation: Working with Data Tier Application Projects in Visual

      Studio 2010

    • Demo: Creating Data-Tier Applications
    • Demo: Data-Tier Application Deployment
    • Presentation: Managing Change in Data Tier Application Projects with

      Visual Studio 2010 and SQL Server 2008 R2 (Part I)

    • Presentation: Managing Change in Data Tier Application Projects with

      Visual Studio 2010 and SQL Server 2008 R2 (Part II)

    • Demo: Managing Change in Data Tier Application Projects in Visual

      Studio 2010

    • Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part I)
    • Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part II)
    • Demo: Introducing SQL Server 2008 R2 StreamInsight
    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight

      (Part I)

    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight

      (Part II)

    • Demo: Querying SQL Server 2008 R2 StreamInsight Using LINQ
    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight

      (Part III)

    • Demo: Advanced SQL Server 2008 R2 StreamInsight Event Queries
    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event

      Models and Adapters (Part I)

    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event

      Models and Adapters (Part II)

    • Demo: Working with SQL Server 2008 R2 StreamInsight CTI Events and

      Advance Time Settings

    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event

      Models and Adapters (Part III)

    • Demo: Creating a SQL Server 2008 R2 StreamInsight Input Adapter
    • Presentation: Installing, Deploying and Maintaining the SQL Server

      2008 R2 StreamInsight Runtime Engine (Part I)

    • Presentation: Installing, Deploying and Maintaining the SQL Server

      2008 R2 StreamInsight Runtime Engine (Part II)

    • Demo: Choosing a SQL Server 2008 R2 StreamInsight Development Model
    • Presentation: Installing, Deploying and Maintaining the SQL Server

      2008 R2 StreamInsight Runtime Engine (Part III)

    • Demo: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger

Once again a lot of stuff included for SQL Server 2008 R2.

System Requirements

  • Supported

    Operating Systems: Windows 7; Windows Server 2008 R2.

  • Microsoft SQL Server 2008 R2 November CTP.
  • Microsoft Visual Studio 2010 Ultimate 2010 Beta 2.
  • AdventureWorks 2008 R2 Sample Databases.

For more info and download you can check here.

Stay Tuned!

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating