e-academy – IT training excellence in Cardiff, Newport, Bristol and South Wales

Course details
Fee £1,145
Days 3
Code 6236
Course dates
May 
Jun11
Jul 
Aug 
Sep 
Oct 

Click on a course date to book
e-mail us
or call us on
0845 650 6500

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

The Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South WalesMicrosoft Certified Gold Partner for Learning Solutions

Overview

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Examination information

  • Exam: 070-448 Microsoft SQL Server, Business Intelligence Development and Maintenance

Prerequisites

Before attending this course, students must have:

  • 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 outline

Module 1: Introduction to Microsoft SQL Server Reporting Services

  • Overview of SQL Server Reporting Services
  • Installin Reporting Services
  • Reporting Services Tool

Module 2: Authoring Basic Reports

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

Module 3: Enhancing Basic Reports

  • Interactive Navigation
  • Displaying Data

Module 4: Manipulating Data Sets

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

Module 5: Using Report Models

  • Creating Report Models
  • Using Report Builder

Module 6: Publishing and Executing Reports

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

Module 7: Using Subscriptions to Distribute Reports

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

Module 8: Administering Reporting Services

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

Module 9: Programming Reporting Services

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