London and UK Wide

Face to face / Online closed & onsite training. Restaurant lunch included at STL venues.

1 day Instructor-led

Who is this course for?

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

Prerequisites

Before attending this course, delegates must have:

Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.
Experience with Windows services (starting and stopping)
Experience with SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
Experience with SQL Server accounts (users and permissions)

Benefits

The objectives of the course are:

Describe SQL Server Reporting Services and its components
Create a Reporting Services report
Create and manipulate data sets
Configure report publishing and execution settings
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 do I get on the day?"

Arguably, the most experienced and highest motivated trainers.

Face-to-face training

Training is held in our modern, comfortable, air-conditioned suites.

Lunch, breaks and timing

A hot lunch is provided at local restaurants near our venues:

Bloomsbury
Limehouse

Courses start at 9:30am.

Please aim to be with us for 9:15am.

Browse the sample menus and view joining information (how to get to our venues).

Refreshments

Available throughout the day:

Hot beverages
Clean, filtered water
Biscuits

Online training

Regular breaks throughout the day.

Learning tools

In-course handbook

Contains unit objectives, exercises and space to write notes

24 months access to trainers

Your questions answered on our support forum.

Training Formats & Services

Training formats available

On-site at your company office UK wide
Closed group at one of our London training venues
Near-site at a location close to you
Bespoke one-to-one basis
Tailored training courses to your requirements
Executive coaching & mentoring

Get On-site/Closed quote

Loading content...

TrustPilot

Excellent

Citigroup
Vice President
D.P.

Top-quality training by friendly instructors in good venues

"I've done several courses with these guys, including Advanced Excel and PowerPoint. The days are well organised and they lay on a great lunch, too. Their tutors are always lively and engaged with attendees. I thoroughly recommend their services."

Resources

Blog

Tutorials and discussions on MS Office

Hints & Tips

MS Office tips to save you time

Cheat sheets

MS Office shortcut keys for all versions

Infographics

Handy info on industry trends

Subscribe

Promotions

Last minute courses

Latest Feedback

98.70% customer recommendation
99.18% training objectives met
226,984 delegates trained
14,573 organisations trained

Latest X / Tweet

Boost Productivity & Profitability with STL Training! 💼 💯 No course cancellations 🖥️ Virtual or in-person in London 🍽️ Lunch included + 2 yrs support ✨ Featured: Project Intermediate—resources, schedustl-training.co.uk/order/pricing_…t.co/QSQqMqKBvW

TrustScore 4.9 / 5 2394 reviews

Implementing SQL Server 2005 Reporting Services