LOGO For Immediate Assistance Call 855-211-9361

1-3 day (9 HOUR TRAINING):

Intermediate SQL Server & reporting Services: 6 High Impact Training

Price: $1050

Call for availability 855-211-9361

This high-impact series of training webinars builds on the foundations established in the Introduction to SQL Server and Reporting Services workshop, is for anyone who wants to leverage SQL Server Reporting Services, Report Builder, SharePoint and Visual Studio's BI tools in a corporate environment. These intermediate-level sessions are for developers, database administrators, architects and managers who want to know how and (more importantly) when to leverage the power and benefits of SQL Server and Reporting Services and the report development tools used to design, create, manage and protect reports and the data they expose. While including information about the latest (R2) release of Reporting Services, these sessions contain essential content that applies to all versions of SQL Server and Reporting Services.

Course Overview

Benefits of this exclusive six-session webinar training series include:

  • Hands-on exercises distributed prior to the sessions help you understand Reporting Services and the report development tools including Report Builder
  • Up-to-date information on the latest versions of Reporting Services as well as pragmatic tips and techniques to use with all versions.
  • Personalized attention from industry-expert William Vaughn.
  • The opportunity to ask questions throughout the sessions
  • Easy-access to session recordings immediately after each webinar

Course Outline

  • SQL Foundations for Reporting

    • Understanding the SQL Server service
    • Understanding the Query Optimizer
    • Understanding the Support Tools
    • Understanding Database Security
  • Reporting Services Foundations

    • Understanding Reporting Services' Architecture and Implementation
    • Building Business Intelligence (BI) Solutions and Projects using Visual Studio
    • Understanding Reporting Services SharePoint Integration
    • Understanding Shared Data Sources, DataSets and Report Parts
    • Understanding Report Access Security
  • Report Builder Foundations

    • Installing and Configuring Report Builder
    • Building New Reports
    • Leveraging Existing Reports
    • Specifying and Capturing Parameters
    • Saving reports
  • Report Manager Alternatives

    • SQL Server's 2005-2008 "Native" Report Manager
    • SQL Server's 2008 R2 "Native" Report Manager
    • Working with SharePoint Integrated Mode
    • Building a SharePoint BI Project
    • Backing Up and Restoring the Reporting Services Catalog
  • Reporting: Advanced Topics

    • Creating and Managing Report Subscriptions and Snapshots
    • Managing Parameters and Pick Lists
    • Optimizing Report and System Performance
    • Managing Code-driven Expressions
    • Creating and Deploying SharePoint BI Projects
  • Report Viewer Control

    • Exploring the ReportViewer Class
    • Building Custom Applications with the ReportViewer
    • Managing Local and Server-side Reports
    • Handing Parameters, Exceptions and Special Requirements
    • Creating Report-Based UI Applications