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 2008 Reporting Services (SSRS)
Training Course UK

Dates and full course list

SQL Server 2008 Reporting Services (SSRS) Training Course Overview

Course Code:	SQL0210
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 2008 Reporting Services (SSRS) steps in, with Report Server Database and .NET-based web-interface management components .

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

Course Content

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

Introduction to 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

Interactive reports

Sub reports
Drilldown
Parameterised reports

Scheduling automatic report delivery

Using SMTP email
Using Windows file share

Deploying and accessing reports

Using URLs
Using Report Viewer in WinForms and WebForms
To Report Manager
To SharePoint – WSS
To SharePoint – MOSS
To PerformancePoint - PPS

 

 

Associated Courses

Microsoft Business Intelligence Training Course: SQL Server 2008 / 2008 Analysis and Integration Services (SSAS / SSIS)
Advanced SQL Server Analysis Services Training Course
SQL Server 2008 / 2008 Reporting Services Training Course
Advanced Microsoft Business Intelligence with SSAS & PerformancePoint Server 2007 Training
Microsoft Performance Point 2007 Training Course - Visualising Business Intelligence

SQL Server 2008 Upgrade Training Course for existing SQL Server 2000 / SQL Server 2008 users

SQL Server 2008 Applications Development training course
SQL Server 2008 Database Administration Training Course
SQL Server 2008 Comprehensive Upgrade Training Course for existing SQL Server 2000 / Oracle / MySQL users

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