MOC 6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

PROKODA Gmbh
In Hamburg, München, Berlin und an 7 weiteren Standorten

1.350 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

Beschreibung

MOC 6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services: About this Course. This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and..
Gerichtet an: About this Course. This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution._x000D_. Audience Profile. This course is intended for information technology (IT) professionals and...

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Berlin
Zimmerstr. 79/80, 10117, Berlin, Deutschland
Plan ansehen
auf Anfrage
Essen
Heinrich-Held-Str. 16, 45133, Nordrhein-Westfalen, NRW, Deutschland
Plan ansehen
auf Anfrage
Frankfurt A. M.
Alexanderstr. 59, 60489, Hessen, Deutschland
Plan ansehen
auf Anfrage
Hamburg
Nagelsweg 55, 20097, Hamburg, Deutschland
Plan ansehen
auf Anfrage
Hannover
Pelikanstrasse 13, 30177, Niedersachsen, Deutschland
Plan ansehen
Alle ansehen (11)

Häufig gestellte Fragen

· Voraussetzungen

Before attending this course, students must have:_x000D_
Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports. _x000D_
Conceptual understanding of the push and pull distribution/subscription paradigm. _x000D_
Experience navigating the Microsoft Windows Server environment. _x000D_
Experience with Windows...

Was lernen Sie in diesem Kurs?

Server

Themenkreis

KURSZIEL
MOC 6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services: About this Course_x000D_

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution._x000D_

_x000D_

Audience Profile_x000D_

This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services._x000D_

_x000D_

At Course Completion_x000D_

After completing this course, students will be able to:_x000D_

  • Describe SQL Server Reporting Services and its components.
  • _x000D_

  • Create a Reporting Services report.
  • _x000D_

  • Enhance a Reporting Services report.
  • _x000D_

  • Create and manipulate data sets.
  • _x000D_

  • Use report models to implement reporting for business users.
  • _x000D_

  • Configure report publishing and execution settings.
  • _x000D_

  • Implement subscriptions for reports.
  • _x000D_

  • Administer Reporting Services.
  • _x000D_

  • Implement custom Reporting Services applications.


  • ZIELGRUPPE
    About this Course_x000D_

    This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution._x000D_

    _x000D_

    Audience Profile_x000D_

    This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services._x000D_

    _x000D_

    At Course Completion_x000D_

    After completing this course, students will be able to:_x000D_

  • Describe SQL Server Reporting Services and its components.
  • _x000D_

  • Create a Reporting Services report.
  • _x000D_

  • Enhance a Reporting Services report.
  • _x000D_

  • Create and manipulate data sets.
  • _x000D_

  • Use report models to implement reporting for business users.
  • _x000D_

  • Configure report publishing and execution settings.
  • _x000D_

  • Implement subscriptions for reports.
  • _x000D_

  • Administer Reporting Services.
  • _x000D_

  • Implement custom Reporting Services applications.


  • KURSINHALT
    Course Outline_x000D_

    _x000D_

    Module 1: Introduction to Microsoft SQL Server Reporting Services_x000D_

    The students will be introduced to the role that Reporting Services plays in an organization's reporting life cycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture._x000D_

    _x000D_

    Lessons_x000D_

    _x000D_

    o Lesson 1: Overview of SQL Server Reporting Services_x000D_

    o Lesson 2: Installing Reporting Services_x000D_

    o Lesson 3: Reporting Services Tools_x000D_

    _x000D_

    Lab: Introduction to Microsoft SQL Server Reporting Services_x000D_

    o Exercise 1: (Level 200) Exploring Report Designer_x000D_

    o Exercise 2: (Level 200) Exploring Report Manager_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Describe the features of SQL Server Reporting Services._x000D_

    o Install Reporting Services._x000D_

    o Describe the Reporting Services tools._x000D_

    _x000D_

    Module 2: Authoring Basic Reports_x000D_

    The students will learn the fundamentals of report authoring, including configuring data sources and data sets, creating tabular reports, summarizing data, and applying basic formatting._x000D_

    _x000D_

    Lessons_x000D_

    o Lesson 1: Creating a Basic Table Report_x000D_

    o Lesson 2: Formatting Report Pages_x000D_

    o Lesson 3: Calculating Values_x000D_

    _x000D_

    Lab: Authoring Basic Reports_x000D_

    o Exercise 1 (Level 200): Creating a Basic Table Report_x000D_

    o Exercise 2 (Level 200): Formatting Report Pages_x000D_

    o Exercise 3 (Level 200): Adding Calculated Values_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Create a basic table report._x000D_

    o Format report pages._x000D_

    o Calculate values for a report._x000D_

    _x000D_

    Module 3: Enhancing Basic Reports_x000D_

    The students will learn about navigational controls and some additional types of data regions, and how to use them to enhance a basic report._x000D_

    _x000D_

    Lessons_x000D_

    o Lesson 1: Interactive Navigation_x000D_

    o Lesson 2: Displaying Data_x000D_

    _x000D_

    Lab: Enhancing Basic Reports_x000D_

    o Exercise 1: (Level 200) Using Dynamic Visibility_x000D_

    o Exercise 2: (Level 200) Using Document Maps_x000D_

    o Exercise 3: (Level 200) Initiating Actions_x000D_

    o Exercise 4: (Level 200) Using a List Data Region_x000D_

    o Exercise 5: (Level 200) Creating a Tablix Report_x000D_

    o Exercise 6: (Level 200) Adding Chart Subreport to Parent Report_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Create reports with interactive navigation._x000D_

    o Display data in various formats._x000D_

    _x000D_

    Module 4: Manipulating Data Sets_x000D_

    The students will explore data sets to a greater depth, including the use of alternative data sources and interacting with a data set through the use of parameters. Students will learn how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query, as well as will learn to use best practices to implement static and dynamic parameter lists when interacting with queries and stored procedures._x000D_

    _x000D_

    Lessons_x000D_

    o Lesson 1: Defining Report Data_x000D_

    o Lesson 2: Using Parameters and Filters_x000D_

    o Lesson 3: Using Parameter Lists_x000D_

    _x000D_

    Lab: Manipulating Data Sets_x000D_

    o Exercise 1: (Level 200) Using Parameters to Restrict Query Results_x000D_

    o Exercise 2: (Level 200) Using Parameters to Filter Report Data_x000D_

    o Exercise 3: (Level 200) Creating Dynamic Parameter Lists_x000D_

    o Exercise 4: (Level 200) Using Parameters with a Stored Procedure_x000D_

    o Exercise 5: (Level 200) Displaying All Categories in a Parameter List_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Define report data._x000D_

    o Use parameters and filters._x000D_

    o Use parameter lists._x000D_

    _x000D_

    _x000D_

    Module 5: Using Report Models_x000D_

    The students will learn how to create a report model so that business users can create their own reports without using the full Report Designer development environment. Students will also learn how to use Report Builder to create a report from a report model._x000D_

    _x000D_

    Lessons_x000D_

    o Lesson 1: Creating Report Models_x000D_

    o Lesson 2: Using Report Builder_x000D_

    _x000D_

    Lab: Using Report Models_x000D_

    o Exercise 1: (Level 200) Creating a Report Model_x000D_

    o Exercise 2: (Level 200) Using Report Builder to Create a Report_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Create Report Models._x000D_

    o Use Report Builder._x000D_

    _x000D_

    _x000D_

    Module 6: Publishing and Executing Reports_x000D_

    The students will learn the various options you can use to publish reports to the report server and execute them._x000D_

    _x000D_

    Lessons_x000D_

    o Lesson 1: Publishing Reports_x000D_

    o Lesson 2: Executing Reports_x000D_

    o Lesson 3: Creating Cached Instances_x000D_

    o Lesson 4: Creating Snapshots and Report History_x000D_

    _x000D_

    Lab: Publishing and Executing Reports_x000D_

    o Exercise 1: (Level 200) Publishing Reports_x000D_

    o Exercise 2: (Level 200) Executing Reports_x000D_

    o Exercise 3: (Level 200) Configuring and Viewing a Cached Report_x000D_

    o Exercise 4: (Level 200) Configuring and Viewing a Snapshot Report_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Publish reports._x000D_

    o Execute reports._x000D_

    o Create cached instances._x000D_

    o Create snapshots and report history._x000D_

    _x000D_

    Module 7: Using Subscriptions to Distribute Reports_x000D_

    The students will learn how to implement subscriptions so that you can distribute reports either automatically by e-mail or by publishing reports to a shared folder._x000D_

    _x000D_

    Lessons_x000D_

    o Lesson 1: Introduction to Report Subscriptions_x000D_

    o Lesson 2: Creating Report Subscriptions_x000D_

    o Lesson 3: Managing Report Subscriptions_x000D_

    _x000D_

    Lab: Using Subscriptions to Distribute Reports_x000D_

    o Exercise 1: (Level 200) Creating a Standard Subscription_x000D_

    o Exercise 2: (Level 200) Creating a Data-Driven Subscription_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Describe report subscriptions._x000D_

    o Create report subscriptions._x000D_

    o Manage report subscriptions._x000D_

    _x000D_

    _x000D_

    Module 8: Administering Reporting Services_x000D_

    The students will learn how to administer the Reporting Services server, how to monitor and optimize the performance of the report server, how to maintain the Reporting Services databases, and how to keep the system secure._x000D_

    _x000D_

    Lessons_x000D_

    o Lesson 1: Reporting Server Administration_x000D_

    o Lesson 2: Performance and Reliability Monitoring_x000D_

    o Lesson 3: Administering Report Server Databases_x000D_

    o Lesson 4: Security Administration_x000D_

    o Lesson: 5 Upgrading to Reporting Services 2008_x000D_

    _x000D_

    _x000D_

    Lab: Administering Reporting Services_x000D_

    o Exercise 1: (Level 200) Using Reporting Services Configuration Manager_x000D_

    o Exercise 2: (Level 200) Securing a Reporting Services Site_x000D_

    o Exercise 3: (Level 200) Securing Items_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Administer the reporting server._x000D_

    o Monitor performance and reliability._x000D_

    o Administer the Report Server databases._x000D_

    o Administer security._x000D_

    o Upgrade to Reporting Services 2008._x000D_

    _x000D_

    Module 9: Programming Reporting Services_x000D_

    The students will learn how to query Reporting Services information programmatically and how to automate report management tasks. Students will also learn how to render reports without relying on Report Manager, and how to extend the feature set of a report server by creating custom code._x000D_

    _x000D_

    Lessons_x000D_

    o Lesson 1: Querying for Server Information Using a Web Service_x000D_

    o Lesson 2: Automating Report Management_x000D_

    o Lesson 3: Rendering Reports_x000D_

    o Lesson 4: Creating Custom Code_x000D_

    _x000D_

    Lab: Programming Reporting Services_x000D_

    o Exercise 1: (Level 200) Using URL Access to Display a Report_x000D_

    o Exercise 2: (Level 200) Building a Reporting Services Web Service Client_x000D_

    o Exercise 3: (Level 200) Using the Report Viewer Control_x000D_

    _x000D_

    After completing this module, students will be able to:_x000D_

    o Query server information using a Web service._x000D_

    o Automate report management._x000D_

    o Render reports._x000D_

    o Create custom code._x000D_

    VORRAUSSETZUNG
    Before attending this course, students must have:_x000D_

  • Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.
  • _x000D_

  • Conceptual understanding of the push and pull distribution/subscription paradigm.
  • _x000D_

  • Experience navigating the Microsoft Windows Server environment.
  • _x000D_

  • Experience with Windows services (starting and stopping)
  • _x000D_

  • Experience creating service accounts and permissions
  • _x000D_

  • Experience with Microsoft SQL Server, including:_x000D_

    - SQL Server Agent._x000D_

    - SQL Server query language (SELECT, UPDATE, INSERT, and DELETE). _x000D_

    - SQL Server System tables._x000D_

    -SQL Server accounts (users and permissions).
  • _x000D_

    _x000D_

    _x000D_

    _x000D_

    Special Offer:_x000D_

    Free SQL Server 2008 Software Offer_x000D_

    Enroll now and attend any one of eight featured SQL Server 2008 training classes before June 30, 2009, and you will receive (while supplies last) a fully licensed copy of SQL Server 2008 Standard Edition with one client access license (CAL)_x000D_

    _x000D_


    Vergleichen Sie diesen Kurs mit ähnlichen Kursen
    Mehr ansehen