Microsoft Training - April-September 2009 - (Page 41) SQL Server 2005 for Reporting Services Discover how to install, build, customize, and deploy in just 5 days. Course 6065 Enhanced Course OMLP-based & Global Knowledge enhanced Lab 1: Using Reporting Services Tools • Exploring Report Designer • Exploring Report Manager Lab 2: Creating a Simple Report • Creating a Basic Table Report • Formatting Report Pages • Adding Calculated Values Lab 3: Enhancing a Report • Using Dynamic Visibility • Using Document Maps • Initiating Actions • Using a List Data Region • Exporting Reports Lab 4: Manipulating Data Sets • Using Parameters to Restrict Query Results • Using Parameters to Filter Report Data • Creating Dynamic Parameter Lists • Using Parameters with a Stored Procedure • Using Advanced Grouping • Combining Reports • Creating and Using Charts Lab 5: Working with Report Models • Creating a Report Model • Using Report Builder to Create a Report Hands-On Labs Course Description In this instructor-led course, you’ll learn to implement a Reporting Services solution in an organization. Learn to use the Reporting Services development tools to create reports and use the Reporting Services management and administrative tools to manage a Reporting Services solution. Supplemental content and our enhanced labs add additional hands-on experience. This course incorporates material from the Official Microsoft Learning Product (OMLP): • ourse 2793: Implementing and Maintaining Microsoft SQL Server C 2005 Reporting Services Lab 6: Publishing and Executing Reports • Publishing Reports • Executing a Report On Demand • Configuring and Viewing a Cached Report • Configuring and Viewing a Snapshot Report Lab 7: Implementing Subscriptions • Creating a Standard Subscription • Creating a Data-Driven Subscription Lab 8: Administering Reporting Services • Using Reporting Services Configuration Manager • Securing a Reporting Services Site • Securing Items Lab 9: Programming Reporting Services • Using URL Access to Display a Report • Building a Reporting Services Web Service Client • Using the Report Viewer Control Lab 10: Troubleshooting and Maintenance of Reporting Services • Backing up Reporting Services • Restoring Reporting Services Lab 11: Supplemental Project • Applying Your Knowledge in a Report Project What You’ll Learn in Class • • • • • • • • • SQL Server Reporting Services and its components Create a Reporting Services report Enhance a Reporting Services report Create and manipulate data sets Use report models to implement reporting for business users Configure report publishing and execution settings Implement subscriptions for reports Administer Reporting Services Implement custom Reporting Services applications Who Needs To Attend Course Content Information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2005 Reporting Services. Prerequisites: • • • • • 1. Introduction to Microsoft SQL Server Reporting Services • Overview of SQL Server Reporting Services • Installing Reporting Services • Reporting Services Tools 2. Authoring Basic Reports • Creating a Basic Table Report • Formatting Report Pages • Calculating Values 3. Enhancing Basic Reports • Interactive Navigation • Displaying Data • Exporting and Printing Reports • Export Formats 4. Manipulating Data Sets • Defining Report Data • Using Parameters and Filters • Using Parameter Lists • If Time Permits: Displaying All Categories In A Parameter List • Advanced Grouping • Combining Reports • Charts • Pre-Defined Reporting Services Packages 5. Using Report Models • Creating Report Models • Using Report Builder 6. Publishing and Executing Reports • Publishing Reports • Executing Reports • Creating Cached Instances • Creating Snapshots and Report History 7. Using Subscriptions to Distribute Reports • Introduction to Report Subscriptions • Creating Report Subscriptions • Managing Report Subscriptions 8. Administering Reporting Services • Server Administration • Performance and Reliability Monitoring • Administering Report Server Databases • Security Administration Reporting Services Security • Web Host Security • Role-Based Security, Role Definitions, Role Assignments • Tasks and Permissions • Custom Security Extension 9. Programming Reporting Services • Querying for Server Information Using a Web Service • Automating Report Management • Rendering Reports • Creating Custom Code • Deployment Tools • NET Assemblies to generate RDL 10. Troubleshooting and Maintenance of the Reporting Services Architecture • Backup and Restore Reporting Services • Common Installation Errors • Database Connection Errors • Credential Errors • Report Errors • Data Access Errors Conceptual understanding of OLAP solutions 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) Buy get one Buy 1 course, get 1 half off. Buy 2 courses, get 3rd free. www.globalknowledge.com/bogo Classroom Learning 5 days $2,995 Classroom Learning CA San Jose Jun 1-5 DC Washington Apr 6-10 DC Washington Jul 6-10 GA Atlanta Mar 30-Apr 3 GA IL IL NC NC Atlanta Chicago Chicago Raleigh Raleigh Virtual Classroom e-Learning 5, 8-hour sessions, $2,495 Aug 3-7 Apr 13-17 Aug 10-14 Apr 20-24 Aug 17-21 NJ NY NY TX TX Morristown New York New York Dallas Dallas On-Site Learning Call for info. Jun 22-26 May 11-15 Sep 21-25 Apr 27-May 1 Jul 27-31 Virtual Classroom e-Learning Jul 6-10 REGISTER NOW 1-800-COURSES www.globalknowledge.com/microsoft 41 http://www.globalknowledge.com/bogo http://www.globalknowledge.com/training/olm/go.asp?find=MIC6065&country=United+States http://www.globalknowledge.com/microsoft
For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.