Asipirity Training

Aspirity has some good courses worth looking at if you're in the U.S. or will travel.

RS200: Fast Track to Reporting Services

Overview This three-day course provides students with the skills needed to implement reporting solutions using Microsoft SQL Server 2000 Reporting Services. Reporting Services is a new enterprise-ready reporting platform that supports end-to-end report development, management, and delivery. By learning the details behind data sources, data sets, parameters, management, security, and working with the more advanced features of Reporting Services, students will achieve a complete and correct understanding of how to use Reporting Services to create and manage reports. At the end of this class, students should be able to build real-world applications for their businesses that give users useful reports and analysis information. Course Outline This three-day, instructor-led course introduces students to the full range of Reporting Services roles and capabilities. Beginning with an overview of Reporting Services, the course takes students through authoring and managing reports, deployment considerations and programming capabilities with Reporting Services: Reporting Services from 500 Feet - Begin the course with a comprehensive introduction to Microsoft Reporting Services that follows the stages of the reporting lifecycle - authoring, management, and delivery. Learn how to design reports with Report Designer and administer reports with Report Manager. Authoring Reports - Learn the basics of report design with table reports. Find out how to set up a data source and dataset. Make reports easy to navigate by adding drill down, document maps, actions. Find out how and when to create page, report, and table headers and footers. Use expressions in a variety of report design situations: aggregating data, creating conditional formatting, and adding custom fields. Exploring Data Regions - Learn how to use table, matrix, list, subreport, and chart data regions as well as the practical application of each. Manipulating Datasets - Build parameterized reports using query parameters and filters. Discover how to use stored procedures and user defined functions to build dynamic reports. Find out how to build a report that displays recursive hierarchies. Create a report from an Analysis Services cube. Managing Content - Learn how to use Report Manager to publish content to the report server for public consumption, organize content into folders, and configure data settings. Learn techniques for setting up report execution settings - on demand, cached instances and snapshots. Deliver reports via standard and data driven subscriptions using file share and email. Administering Security - Secure Reporting Services using item security, system security, and data security features. Administering Reporting Services Components - Learn how to administer and monitor report executions and subscriptions. Find out how and when to manipulate the server configuration files. Identify the key components of database administration. Programming Reporting Services - Extend the functionality of Reporting Services by understanding how to use the Reporting Services web service to build custom browsing and management applications. Learn how to automate report management using the rs utility. Find out how to access reports via a URL. Audience and Prerequisites This course is intended for all types of reporting users including server and content managers, designers, and developers who are responsible for the design, implementation, and maintenance of reporting solutions. Before attending this course, students should have: An understanding of basic relational database concepts. Experience with Microsoft Windows 2000 and Microsoft Visual Studio. Some knowledge of the following is helpful: Microsoft SQL Server 2000. Basic Transact-SQL syntax. Microsoft Visual Basic. Windows Script programming principles. Basic XML.