Microsoft SQL 2005 Reporting Services - Virtual
Who Needs to Attend
This course is vital for database designers and developers, analysts, database administrators, or those interested in generating business data reports with a full web-based, secure deployment. Intended for those who are looking to augment SQL Server 2000 or 2005 by leveraging the power of Reporting Services.
Prerequisites
Experience using SQL Server and an understanding of relational database concepts.
Follow-On Courses
There are no follow-ons for this course.
Discover how to install, build, customize, and deploy in just 5 days.
This course is not currently offered by Global Knowledge. Information here is provided for reference only.
SQL Server 2005 Reporting Services extends the Microsoft business intelligence vision by making it convenient to get information to the right people, at the right time, in any business environment. Microsoft's SQL 2005 Reporting Services is a fully scalable, server-based platform for creating, managing, and delivering traditional and interactive reports.
The SQL 2005 Reporting Services course will introduce you to this break-through server-based reporting platform you can use to create valuable reports containing information from relational and multi-dimensional data sources. The reports you create can be viewed and managed over a Web-based interface.
Discover the advantages of Microsoft SQL 2005 Reporting Services and learn how to build a reporting environment for your organization.
Course Outline
1. Business Intelligence and SQL Reporting Services
- Reporting Life Cycle
- New Features
- Editions
- System Requirements
- Installation
- Post-installation Steps
2. Examining the Reporting Services Architecture
- Reporting Services Overview
- Development Environment
- Report Manager
- Sample Reports
- Report Wizard
3. Database Access Basics
- SQL Server Management Studio
- Business Intelligence Development Studio for Data Access
- SQL Select Statements
- Complex Join Operations
- Aggregate Functions
4. Report Development
- Business Intelligence Development Studio
- Report Designer
- Report Formatting
- Calculated Fields and Values in Reports
5. Report Rendering Formats
- Export and Printing of Reports
- Presentation Formats
- Export Formats
- Rendering Options
6. Report Deployment Techniques
- Deployment Tools
- Report Manager
- Subscriptions
- Data Driven Subscriptions
- NET Assemblies to generate RDL
7. Securing Report Access
- Reporting Services Security
- Web Host Security
- Role-based Security
- Role Definitions
- Tasks and Permissions
- Role Assignments
- Custom Security Extension
8. Report Builder
- Report Builder Architecture
- Report Models
- Report Builder
9. Advanced Reporting Techniques
- Dynamic Reports
- Advanced Parameter Usage
- Advanced Grouping
- Combining Reports
- Charts
- Pre-Defined Reporting Services Packages
10. Troubleshooting and Maintenance of the Reporting Services Architecture
- Backup and Restore of Reporting Services
- Common Installation Errors
- Database Connection Errors
- Credential Errors
- Report Errors
- Data Access Errors
Hands-On Labs
Lab 1: Install SQL Server 2005 Reporting Services
Lab 2: Set Up and Use Reporting Services
Lab 3: Database Access Basics
Lab 4: Report Development
Lab 5: Report Rendering Formats
Lab 6: Report Deployment Techniques
Lab 7: Securing Report Access
Lab 8: Report Builder
Lab 9: Advanced Reporting Techniques
Lab 10: Troubleshooting and Maintenance of Reporting Services
To request a location or date, use our By Request service.
Course Code: 6357
Registration Information
$2395 USD
5 Day Course
RSS