MS6236

Ladda ner som PDF

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Denna utbildning  lär dig att implementera en Reporting Services-lösning. Du får lära dig att skapa rapporter, att jobba effektivt med data och även att effektivt administrera en sådan lösning.

 This course can be paid with SA Vouchers  SA Voucher

Målgrupp:

Tekniker och utvecklare med ansvar för att bygga en BI-lösning med hjälp av Microsoft SQL Server Reporting Services.

Du får lära dig:

  • Describe 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.

Innehåll:

Module 1: Introduction to Microsoft SQL Server Reporting Services

  • Lesson 1: Overview of SQL Server Reporting Services
  • Lesson 2: Installing Reporting Services
  • Lesson 3: Reporting Services Tools

Module 2: Authoring Basic Reports

  • Lesson 1: Creating a Basic Table Report
  • Lesson 2: Formatting Report Pages
  • Lesson 3: Calculating Values

Module 3: Enhancing Basic Reports

  • Lesson 1: Interactive Navigation
  • Lesson 2: Displaying Data

Module 4: Manipulating Data Sets

  • Lesson 1: Defining Report Data
  • Lesson 2: Using Parameters and Filters
  • Lesson 3: Using Parameter Lists

Module 5: Using Report Models

  • Lesson 1: Creating Report Models
  • Lesson 2: Using Report Builder

Module 6: Publishing and Executing Reports

  • Lesson 1: Publishing Reports
  • Lesson 2: Executing Reports
  • Lesson 3: Creating Cached Instances
  • Lesson 4: Creating Snapshots and Report History

Module 7: Using Subscriptions to Distribute Reports

  • Lesson 1: Introduction to Report Subscriptions
  • Lesson 2: Creating Report Subscriptions
  • Lesson 3: Managing Report Subscriptions

Module 8: Administering Reporting Services

  • Lesson 1: Reporting Server Administration
  • Lesson 2: Performance and Reliability Monitoring
  • Lesson 3: Administering Report Server Databases
  • Lesson 4: Security Administration
  • Lesson: 5 Upgrading to Reporting Services 2008

Module 9: Programming Reporting Services

  • Lesson 1: Querying for Server Information Using a Web Service
  • Lesson 2: Automating Report Management
  • Lesson 3: Rendering Reports
  • Lesson 4: Creating Custom Code

Förkunskaper

  • Grundläggande förståelse för skapandet av rappoter i till exempel Microsoft Access eller annan produkt.
  • Viss erfarenhet av Windows Server och SQL server och SQL som frågespråk.

Kursmaterial

Microsofts digitala officiella kursmaterial på engelska.

Kurs-ID: MS6236
Längd: 3 dagar
Kan betalas med:
TRAINING CARD

Lämna dina kontaktuppgifter om du önskar en företagsintern utbildning.