|
|
Course Overview Reporting Services is a new product that is packaged with SQL Server 2000, although it works with all popular databases. It provides a simple drag and drop design interface for a wide range of reports that can be viewed as web pages Excel sheets or Acrobat documents. It includes a sophisticated web based Report Manager allowing a complete range of security, scheduling and report preparation options. This two-day course provides students with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services. Students should leave the course with a good understanding of how to apply reporting services to problems within a business context. The course is a practical guide to designing and deploying reports in the Reporting Services product. It is an overview of the features of the product and enables the delegate to gain the skills to create professional reports and to setup the Management of reports, controlling authority to view and to allow reports to automatically display information appropriate to the user. This course has been classified as IT Technical Training. Audience This course is intended for database administrators, database developers, IT professionals and suppliers of Business Information who have a minimum of 6 months SQL Server 2000 and SQL Server 7.0 experience and basic Microsoft Visual Studio(R) .NET navigation skills. Skills Gained This course will enable delegates to: - Understand the architecture of Microsoft Reporting Services and Office integration.
- Author reports using the Report Designer.
- Deploy and publish reports.
- Manage the lifecycle of a report including report scheduling and backup and restore.
- Understand how to apply Reporting Services to a business problem.
Prerequisites Before attending this course, students must have : a minimum of 6 months SQL Server 2000 and SQL Server 7.0 ; Exposure to Visual Studio .NET and Exposure to creating reports in Microsoft Access or third party reporting products. Course Outline Module 1: Introduction to Microsoft SQL Server Reporting Services - Key features offered by Reporting Services.
- Components that make up the Reporting Services architecture.
Module 2: Authoring Basic Reports - Creating a Basic Table Report.
- Formatting Report Pages.
- Calculating Values.
- Creating a Basic Table Report.
- Formatting Report Pages.
- Adding Calculated Values.
- Referencing Global Values.
Module 3: Enhancing Basic Reports - Interactive Navigation.
- Displaying Data.
- Using Dynamic Visibility.
- Using Document Maps.
- Initiating Actions.
- Using a List Data Region.
Module 4: Manipulating Data Sets - Defining Report Data.
- Using Parameters and Filters.
- Using Parameter Lists.
- Using Parameters to Restrict Query Results.
- Using Parameters to Filter Report Data.
- Creating Dynamic Parameter Lists.
- Using Parameters with a Stored Procedure.
- Displaying All Categories in a Parameter List.
- Simulating a Multi-select Parameter List.
Module 5: Managing Content - Publishing Content .
- Executing Reports.
- Creating Cached Instances.
- Creating Snapshots and Report History.
- Creating Report Subscriptions.
- Publishing Reports.
- Executing Reports.
- Creating Subscriptions.
Module 6: Administering Reporting Services - Server Administration.
- Performance and Reliability Monitoring.
- Database Administration.
- Security Administration.
- Deploying the Demonstration Reports.
- Securing the Site.
- Securing Items.
Module 7: Programming Reporting Services - Querying Server Information.
- Automating Report Management.
- Rendering Reports.
- Creating Custom Code.
- Viewing Report Server Management Information.
- Managing a New Report Using the Report Server Web Service.
How to make a booking for the MS2030 course
|
