SQL Server Training / SQL Server 2008 Training
New Features for SQL Server 2008 R2 for Developers
Accelebrate's New Features for SQL Server 2008 R2 for Developers training course teaches experienced SQL Server 2008 developers the new features in SQL Server 2008 R2.
Location and Pricing
Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.
SQL Server 2008 R2 Training Objectives
SQL Server 2008 R2 Training Outline
Introduction to SQL Server 2008 R2
What is the R2 Release?
Feature Only a DBZ Could Love
Multi-Server and Application Management
Data-Tier Applications (DAC)
Working with DAC's
Business Intelligence for the Power User
PowerPivot for Excel and SharePoint
Working with the PowerPivot Excel Add-In
Querying Real Time Data Streams
Introduction to StreamInsight
Working with StreamInsight Data
Querying a Data Stream
Reporting Services in R2
Reporting Services Enhancements
Lookup Functions to Join Datasets
Aggregates of Aggregates
Control Output Formatting with RenderFormat
Report as a Data Source
New Data Visualization Features in R2
Data Bars and Sparklines
Report Manager and Viewer in R2
Making Reporting Services More Widely Usable
Report Builder 3.0
Creating and Using Report Models
Saving and Deploying Reports
All attendees should have prior development experience with the original release of SQL Server 2008.
All students will receive comprehensive courseware plus Sams Publishing's Microsoft SQL Server 2008 R2 Unleashed.
Software needed for each student PC: