www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

SQL Server 2005 Reporting Services (SSRS)
Training Course UK

Dates and full course list

SQL Server 2005 Reporting Services (SSRS) Training Course Overview

Course Code:	SQL0070
Price:	£995
Duration:	2 days
DATE:
Who should attend:	Developers and analysts who need to design and build reports. Administrators who wish to deploy and manage reports.
Prerequisite Skills:	Delegates should have some basic knowledge of SQL language queries.

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 .

See also our full 5-day Business Intelligence with SQL Server 2005 training course which incorporates this course and our 3-day SQL Server 2005 Analysis & Integration Services (SSAS & SSIS) course (and saves you money!).

Course Content

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.

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

SQL Server 2005 Reporting Services Training 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

Associated 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