SQL Server 2005 / SQL Server 2008 Reporting Services (SSRS)
Training Course UK

SQL Server 2005 / SQL Server 2008 Reporting Services (SSRS) Training Course Overview

Course Code:	SQL0070
Price:	£995
Duration:	2 Days - custom / on-site options available - please call.
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 Reporting Services (SSRS) steps in, with Report Server Database and .NET-based web-interface management components .

Because of the similarities in architecture and functionality between SQL Server 2005 and SQL Server 2008, demonstrations and course labs will be on SQL Server 2008 R2 with any specific differences over SQL Server 2005 being demonstrated upon request (usually in a short session at the end of each session).

Save money with our full 5-day Business Intelligence with SQL Server 2005 / SQL Server 2008 training course which incorporates:
SQL Server 2005 / 2008 Reporting Services (SSRS) - 2 Days, £995+vat
SQL Server 2005 / 2008 Analysis Services (SSAS) & Integration Services (SSIS) - 3 Days, £1395+vat

Course Content

This course has been created to cover all the main aspects SQL Server Reporting Services. 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 / SQL Server 2008 Reporting Services Training Course Outline

Introduction to SQL Server 2005 / SQL Server 2008 Reporting Services

Architecture

SSRS – Reporting Services
Report Server
Report Designer
Report Manager
Report Viewer
Report Models
Report Builder

Designing a simple report

Report Wizard
Introduction to Report Designer
Using templates
Basic formatting
Previewing reports
Introduction to deploying reports
Exporting reports to Excel and PDFs

Working with Data / Information / Intelligence

Third normal form relational databases in SQL Server/Oracle/DB2
Star schema relational databases in SQL Server/Oracle/DB2
SSAS Cubes
SSAS data mining
SQL queries and stored procedures
MDX queries
DMX queries

Advanced report design

Tables
Matrices
Charts
Grouping
Conditional formatting with SSRS Expression
Language
Conditional formatting with VB.NET (or C# - SQL Server 2008 only)
Creating KPIs