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
-
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
- Introducing SQL Server 2008 R2 StreamInsight
- Introducing SQL Server 2008 R2 Reporting Services
- Introducing SharePoint 2010 PerformancePointServices
- Lesson 2: SQL Server 2008 R2 - Application and Multi-Server Management
-
Lesson 3: SQL Server 2008 R2 - StreamInsight
- Real Time Analytics with SQL Server 2008 R2 StreamInsight
- Demo: Introducing SQL Server 2008 R2 StreamInsight
- Querying Events in SQL Server 2008 R2 StreamInsight(Part I)
- Demo: Querying SQL Server 2008 R2 StreamInsightUsing LINQ
- Querying Events in SQL Server 2008 R2 StreamInsight(Part II)
- Advanced SQL Server 2008 R2 StreamInsightEvent Queries
- Designing SQL Server 2008 R2 StreamInsightEvent Models and Adapters (Part I)
- Designing SQL Server 2008 R2 StreamInsightEvent Models and Adapters (Part II)
- Designing SQL Server 2008 R2 StreamInsightEvent Models and Adapters (Part III)
- Working with SQL Server 2008 R2 StreamInsightCTI Events and Advance Time Settings
- Demo: Creating a SQL Server 2008 R2 StreamInsightInput Adapter
- Installing, Deploying and Maintaining SQL Server 2008 R2 StreamInsight(Part I)
- Installing, Deploying and Maintaining SQL Server 2008 R2 StreamInsight(Part II)
- Installing, Deploying and Maintaining SQL Server 2008 R2 StreamInsight(Part III)
- Demo: Choosing a SQL Server 2008 R2 StreamInsightDevelopment Model
- Demo: Using the SQL Server 2008 R2 StreamInsightEvent Flow Debugger
-
Lesson 4: SQL Server 2008 R2 - Reporting Services
- What's New in SQL Server 2008 R2 Reporting Services
- Developing Reports with the New Features of SQL Server 2008 R2 Reporting Services
- Demo: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services
- Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
- Demo: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
- Working with Shared Components in SQL Server 2008 R2 Reporting Services
- Demo: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services
- Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
- Demo: Using SQL Server 2008 R2 Reporting Services Report Feeds
- Embedded Reporting in Applications
- Developing with the Microsoft Chart Controls in Visual Studio 2010
-
Lesson 5: Excel 2010 and SQL Server
- What's New in the Excel 2010 Client
- Demo: What's New in the Excel 2010 Client
- Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
- Demo: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
- Creating Reports with SQL Server PowerPivot for Excel 2010
- Demo: Creating Reports with SQL Server PowerPivot for Excel 2010
- Defining DAX Calculations with PowerPivot for Excel 2010
- Demo: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010
-
Lesson 6: SharePoint 2010 Insights and SQL Server
- Introducing SharePoint 2010 Insights
- Demo: Introducing SharePoint 2010 Insights
- What's New in SharePoint 2010 Excel Services
- Demo: What's New in SharePoint 2010 Excel Services
- What's New in SharePoint 2010 PerformancePointServices
- Demo: What's New in SharePoint 2010 PerformancePointServices
- Developing KPI's and Scorecards with SharePoint 2010 PerformancePointServices
- Demo: Developing KPI's and Scorecards with SharePoint 2010 PerformancePointServices
- Developing Reports and Dashboards with SharePoint 2010 PerformancePointServices
- Demo: Developing Reports and Dashboards with SharePoint 2010 PerformancePointServices
- Managing Excel 2010 PowerPivot Solutions in SharePoint 2010
- 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
You might also like
video
Up and Running with Microsoft SQL Server
In this Up and Running with Microsoft SQL Server training course, expert author Wes Higbee will …
video
MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014
Lesson Files: http://www.informit.com/content/images/9780789753984/downloads/Code_70-461.zip More than 12 hours of video instruction on Querying Microsoft SQL Server 2012 …
video
Microsoft SQL Server 2012 Certification Training - Exam 70-462
In this SQL Server 70-462 exam training course, expert author Denny Cherry teaches you everything you …
video
Microsoft PolyBase Concepts and Configuration: Binding SQL Server and Other Platforms into a Single Data Source
This video provides an overview of PolyBase, Microsoft's technology for data virtualization. Modern data platform environments …