Training

Maintaining, Troubleshooting and Developing Solutions with Microsoft SQL Server 2008 Reporting Services

Description: 

Prerequisites

  • Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports
  • Conceptual understanding of the push and pull distribution/subscription paradigm
  • Experience navigating the Microsoft Windows Server environment
  • Experience with Windows services (starting and stopping)
  • Experience creating service accounts and permissions
  • Experience with Microsoft SQL Server, including:
    • SQL Server Agent
    • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
    • SQL Server System tables
    • SQL Server accounts (users and permissions)
  • Course 6182: Implementing and Managing SQL Server 2008


Course Brief

1. Introduction to Microsoft SQL Server Reporting Services

  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools

2. Authoring Basic Reports

  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values

3A. Enhancing Basic Reports

  • Interactive Navigation
  • Displaying Data
  • Expressions
  • Using Parameters as Content
  • Changing Report Structure with Parameters

3B. Exclusive - Dynamic Reports

  • More with expressions
  • Displaying Parameters
  • Dynamic Report Structure

4. Manipulating Data Sets

  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists

5. Using Report Models

  • Creating Report Models
  • Using Report Builder

6. Publishing and Executing Reports

  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History

7. Using Subscriptions to Distribute Reports

  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions

8. Administering Reporting Services

  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008

9A. Programming Reporting Services

  • Adding Code to Reports
  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code

9B. Exclusive - Adding Custom Code to a Report

  • Adding Code to a Report
  • Using a Custom Code Assembly

10. Exclusive - External Data

  • Accessing Remote SQL Server Data
  • Connecting to Other Data Sources
  • Implementing Analysis Services

11. Exclusive - Optimizing and Troubleshooting

  • Optimizing the SSRS environment
  • Troubleshooting the SSRS environment

12. Exclusive - Integrating with Microsoft Office SharePoint Server 2007

  • Introduction to SharePoint 2007
  • SharePoint Integrated Mode
  • Configuring SharePoint for Reporting Services
  • Deploying Reports to SharePoint
  • Managing and Viewing Reports
  • Integrating Reports into Dashboards

 

 

Course Outline

 

  Subsidiaries of Totheburn Trading