SQL Server 2005: Business Intelligence: Reporting Services (SSRS) UK Classes & Lessons (Microsoft SQL Server)

About this class

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.

Who will the lesson benefit?

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

What prerequisites are required

Delegates should have some basic knowledge of SQL language queries.

Contents of this class

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

Optional follow-on classes

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