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