Implementing SQL Server 2005 Reporting Services

2 Day Training Course London and UK Wide

Training formats available

• on-site at your company office UK wide (60 second quote)
• closed group at one of our London training venues (60 second quote)
• near-site at a location close to you
• bespoke one-to-one basis
• tailored training courses to your requirements

Who is this training course suitable for?

This course is intended for information technology professionals and developers who need to implement reporting solutions by using SQL Server 2005 Reporting Services.

Benefits

The objectives of the course are:

1. Describe SQL Server Reporting Services and its components
   
2. Create a Reporting Services report
   
3. Create and manipulate data sets
   
4. Configure report publishing and execution settings
   
5. Administer Reporting Services
   

Course Syllabus

Introduction to Microsoft SQL Server Reporting Services Describe the features of SQL Server Reporting Services Install Reporting Services Describe the Reporting Services tools Authoring Basic Reports Creating a Basic Table Report Formatting Report Pages Calculating Values Enhancing Basic Reports Create reports with interactive navigation Display data in various formats Manipulating Data Sets Defining Report Data Using Parameters and Filters Using Parameter Lists

Publishing and Executing Reports Publishing Reports Executing Reports Creating Cached Instances Creating Snapshots and Report History Administering Reporting Services Server Administration Performance and Reliability Monitoring Administering Report Server Databases Security Administration Programming Reporting Services Query server information by using a Web service. Automate report management Render reports Create custom code

What is Microsoft SQL Server?

SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handling, row processing, and declared variables.