Microsoft SQL Server 2008 Reporting Services Course


6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services Course


In this course, you will learn how to use SQL Server 2008 Reporting Services, explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You’ll then explore tabular and list reports that employ datasets and data regions. As you progress you’ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities.

You’ll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you’ll be building Matrix reports and charts then explore the use of Reporting Services gauges. The Deployment of Reporting Services projects follow using a variety of formats and client-side printing. You’ll gain knowledge of SSRS Security in managing of user roles and accounts. You’ll also discover how to view reports using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you’ll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.

 

6236 : Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services Course

  1. Introduction to Microsoft SQL Server Reporting Services
    1. Describe the features of SQL Server Reporting Services.
    2. Install Reporting Services.
    3. Describe the Reporting Services tools.
  2. Authoring Basic Reports
    1. Create a basic table report.
    2. Format report pages.
    3. Calculate values for a report.
  3. Enhancing Basic Reports
    1. Create reports with interactive navigation.
    2. Display data in various formats
  4. Manipulating Data Sets
    1. Define report data.
    2. Use parameters and filters.
    3. Use parameter lists
  5. Using Report Models
    1. Create Report Models.
    2. Use Report Builder.
  6. Publishing and Executing Reports
    1. Publish reports.
    2. Execute reports.
    3. Create cached instances.
    4. Create snapshots and report history.
  7. Using Subscriptions to Distribute Reports
    1. Describe report subscriptions.
    2. Create report subscriptions.
    3. Manage report subscriptions
  8. Administering Reporting Services
    1. Administer the reporting server.
    2. Monitor performance and reliability.
    3. Administer the Report Server databases.
    4. Administer security.
    5. Upgrade to Reporting Services 2008.
  9. Programming Reporting Services
    1. Query server information using a Web service.
    2. Automate report management.
    3. Render reports.
    4. Create custom code.

Technology Partners


"Our Gold Certified Partner designation demonstrates to both prospective and existing clients that our organization has demonstrated the highest level of competence and expertise with Microsoft technologies. Having such a close working relationship with Microsoft allows us to further enhance the level of service we deliver to our clients."

Customer Testimonials

2011 Information Data Systems Inc. All Rights Reserved.Home | Sitemap | Contact Us