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