SQL Server 2005: Business Intelligence: Reporting Services (SSRS)

Course Overview

Well designed data-entry applications should allow fast data manipulation for production databases. Actions such as inserts, updates and deletes use locks to protect data integrity, but these can slow down or even prevent the reporting process. This is obviously a problem with in large enterprises, where intensive database activity is the norm. This is where Microsoft SQL Server 2005 Reporting Services (SSRS) steps in, with Report Server Database and .NET-based web-interface management components .

This course has been created to cover all the main aspects SQL Server Reporting Services 2005. Reporting Services can be used to generate reports against most databases, for example Oracle, as well as SQL Server and Analysis Services. Available as a public or closed course at our London training centre, or can be tailored to your team's requirements and delivered onsite as a bespoke, customised training course.

Audience

Developers and analysts who need to design and build reports. Administrators who wish to deploy and manage reports.

Prerequisites

Delegates should have some basic knowledge of SQL language queries.

Course Outline

Introduction

Architecture

• Reporting Services
• Report Server
• Report Server databases
• Report Designer
• Report Manager
• Report Models
• Report Builder
• Report Viewer

Designing a simple report

• Report wizards
• Report Designer
• Basic formatting
• Using templates
• Previewing
• Deploying

Working with data

• SQL queries
• Query Builder
• MDX queries
• DSV (data source views)
• Grouping

Advanced reports

• Formatting
• Using expressions
• Page breaks
• Matrices
• Headers
• Graphics

Interactive reports

• Parameters

Report Builder

• Tables and matrices
• Adding clickthrough
• Sorting and filtering

Administration

• Report Manager
• Configuration Manager

Management areas

• Managing Report Server
• Managing security
• Managing subscriptions
• Managing access
• Managing deployment

Follow On Courses

• SQL Server 2008 Comprehensive Upgrade Training Course for existing SQL Server 2005 & 2000 / Oracle / MySQL users
• SQL Server 2005 Applications Development training course
• SQL Server 2005 Database Administration Training Course
• SQL Server 2005 Comprehensive Upgrade Training Course for existing SQL Server 2000 / Oracle / MySQL users
• SQL Server 2005 Business Intelligence Training Course: SSAS & SSIS Analysis and Integration Services Training Course
• SQL Server 2005 Business Intelligence Training Course: SSRS Reporting Services Training Course
• SQL Server 2000 Applications Development training
• SQL Server 2000 Database Administration
• SQL Server Performance Tuning
• SQL Server OLAP, DTS & Cubes Training
• SQL Design and Information Retrieval

SQL Server 2005: Business Intelligence: Reporting Services (SSRS) / SQL0070