SQL - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services 6236
Course Type
Scheduled:
| Date |
Location |
Duration |
Cost |
16 Jul 2012 (Mon)
17 Jul 2012 (Tue)
18 Jul 2012 (Wed) | Sunderland | 3 | £ 1195 |
| All prices exclude VAT |
|
Private
:
| This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice. |
Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.
You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.
We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.
Please contact us to discuss this further on 0191 377 8377.
Course Overview
This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.
Prerequisites
- Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.
- Conceptual understanding of the push and pull distribution/subscription paradigm.
- Experience navigating the Microsoft Windows Server environment.
- Experience with Windows services (starting and stopping) Experience creating service accounts and permissions
- Experience with Microsoft SQL Server, including:
- SQL Server Agent.
- SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
- SQL Server System tables.
- SQL Server accounts (users and permissions).
Objectives
Course Content
Introduction to Microsoft SQL Server Reporting Services
Overview of SQL Server Reporting Services
Installing Reporting Services
Reporting Services Tools
Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Enhancing Basic Reports
Interactive Navigation
Displaying Data
Manipulating Data Sets
Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Using Report Models
Creating Report Models
Using Report Builder
Publishing and Executing Reports
Publishing Reports
Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Using Subscriptions to Distribute Reports
Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions
Administering Reporting Services
Reporting Server Administration
Performance and Reliability Monitoring
Administering Report Server Databases
Security Administration
Upgrading to Reporting Services 2008
Programming Reporting Services
Querying for Server Information Using a Web Service
Automating Report Management
Rendering Reports
Creating Custom Code
Training Options
- Scheduled public courses at one of our training venues
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- For further information please contact us on 0191 377 8377
What's Included
- 1 delegate per computer
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
SQL 6236 Training Courses in the North East of England including Newcastle, Durham, Washington, Gateshead, Darlington, Sunderland- Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
Accessibility: 
Enquire Online 
Special Offers 
| Join us on Facebook or
| 
FAQs
