Microsoft SQL training | SSRS (2 days)

In the current business environment organisations need to be able to transform data into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will also learn how to create ad hoc reports using the Report Builder and Report Model projects.

SSRS training - Course Contents

The contents of our SSRS course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please either click on one of the content headings below and try some exercises or call or email us to talk through your options. We want you to be on the right Microsoft SQL training course as much as you do!

Using SSRS
  • Database overview
  • Report server
Designing a Simple Report
  • The report wizard
  • Starting with report designer
  • Basic formatting
  • Previewing reports
Advanced Design
  • Tables
  • Matrices
  • Charts
Calculations and Formatting
  • Calculating totals and percentages
  • Using the global collections
  • Advanced formatting
  • Conditional - SSRS Expression
Grouping and Sorting
  • Creating groups
  • Sorting results
  • Aggregation
Interactive Reports
  • Sub-Reports
  • Parameters
  • Creating drop-down parameters
  • Multi-valued parameters
Managing Reporting Services
  • Using SSRS Manager
  • Exporting Reports
  • Printing
Ad-Hoc Reporting - Report Builder
  • Using the report builder
  • Creating report model projects
  • Running the report builder
Reporting Services Security (*)
  • Managing Roles
  • Data Source Security
Programming Reporting Services (*)
  • Using URL access
  • The reporting services web service
Automatic Report Delivery (*)
  • Using SMTP email
  • Scheduling report delivery

To help see if this is the right course for you, you can see and download examples of our SQL courseware. You can also look at the differences between Microsoft SQL versions and see on which SQL version we currently train.

SSRS training - Pre-requisites

You will need at least a basic knowledge of SQL to attend this course.

SSRS training - Schedule and Prices

Prices for this Microsoft SQL training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft SQL training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft SQL training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft SQL training. This allows you to create a Microsoft SQL training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft SQL which they need to learn.

Recommended sites: TechTutorials

All content copyright Wise Owl Business Solutions Ltd 2009.  All rights reserved.