08-506 668 00
Training You Can Trust®
 
 

SQL Server 2005 Reporting Services

 
Kurs: 523   Längd: 4 dagar
 
 

You Will Learn How To

  • Leverage SQL Server 2005 Reporting Services to produce sophisticated reports
  • Author robust reports that extract business intelligence out of your data
  • Extract relevant report data using parameters and filters
  • Render interactive reports with drill-down and drill-through features
  • Deploy reports to a Report Server for centralised access and administration
  • Secure reports in the Reporting Services environments

Course Benefits

The ability of an organisation to deliver business-critical reports to customers, partners, suppliers and employees is a vital component of remaining competitive. SQL Server Reporting Services augments SQL Server and other database management systems to meet these demanding requirements. In this course, you gain the knowledge and skills to write robust reports, mine important data and deliver reports for centralised access and administration.

Who Should Attend

Those designing, creating or delivering reports from a database with SQL Server 2005 Reporting Services. Previous exposure to any database system or spreadsheet data is assumed.

Hands-On Training

Throughout this course, you gain extensive experience creating and managing reports using Reporting Services. Exercises include:
  • Authoring free-form reports including images, calculated fields and groups
  • Implementing advanced navigation using drill down, drill through and document maps
  • Deploying reports manually and automatically
  • Creating cached instances, snapshots and subscriptions
  • Configuring and testing security on report items
  • Building and applying a currency converter function

Liknande kurser

  • 382 Relationsdatabaser: design, verktyg och metoder
  • 534 SQL-frågor för SQL Server
  • 535 Högpresterande SQL Server-databaser
  • 139 SQL Server Analysis Services UK course
  • 140 SQL Server 2008 Reporting Services
  • 134 SQL Server Integration Services UK course
  • 137 SQL Server 2008: omfattande introduktion
  • 2106 SQL Server 2012: BI uppdateringskurs

 
SQL Server är ett registrerat varumärke som ägs av Microsoft Corporation. 		  SQL Server 2005 Reporting Services

Kursschema

Learning Tree AnyWareDu kan gå de överstrukna kurserna i klassrummet eller live, online via Learning Tree AnyWareTM.
28 - 31 marsStockholm 
9 - 12 oktStockholm 

Storbritannien

22 - 25 majLondon 

När du ska gå en AnyWare-kurs bör du anmäla dig minst 10 dagar före kursstart.


För fler kursdatum besök www.learningtree.se
 
http://www.learningtree.se/courses/se523.htm
 
 
08-506 668 00
Training You Can Trust®
 
 

SQL Server 2005 Reporting Services

 
Kurs: 523   Längd: 4 dagar
 
 
Course Content
 

SQL Server Reporting Services (SSRS) Architecture

  • Report types and formats
  • SSRS Web Services
  • Report Server
  • Report Builder
  • Model Designer
  • Data sources: SQL Server, Oracle, OLE DB
  • Single and Web farm deployment

Authoring Reports

Creating basic reports

  • Tabular
  • List
  • Matrix
  • Chart
  • Constructing data sources and Datasets
  • Inserting a data region, fields and images

Leveraging expressions

  • Calculating fields
  • Built-in collections
  • Integrating expressions in properties
  • Applying conditional formatting
  • Best practices for adding images

Grouping and sorting data

  • Grouping to multiple levels
  • Sorting the results
  • Employing aggregate functions

Implementing Parameters and Filters

Building parameters into reports

  • Returning subsets of data with query parameters
  • Mapping report parameters to query parameters
  • Building cascading report parameters
  • Changing chart titles programmatically
  • Designing reports for the user's national language
  • Passing parameters to stored procedures
  • Exploiting multivalued parameters

Restricting report data with filters

  • Enhancing performance with filters
  • Filters vs. query parameters
  • Customising reports for different national languages

Leveraging Advanced Reporting Features

Combining data regions in one report

  • Utilising sequential and nested regions
  • Producing master/detail reports
  • Linking subreports

Presenting data with appropriate detail

  • Revealing report detail with drill down
  • Displaying related data with drill through
  • Navigating with document maps

Deploying and Delivering Reports

Deploying reports to the server

  • Preparing reports for publishing
  • Configuring project properties
  • Units of deployment: Individual reports, projects, solutions, data sources
  • Checking results with Report Manager

Selecting delivery options

  • On-demand or by subscription
  • Improving performance with cached instances and snapshots
  • Configuring snapshot history

Sending subscription reports

  • Making reports available via e-mail and fileshare
  • Delivering reports flexibly through data-driven subscriptions

Securing Reporting Services

Securing the RS environment

  • Assigning users to roles
  • Setting permissions on report items
  • Granting and revoking system-level permissions

Empowering users with ad hoc reporting

  • Architecting report models with Model Designer
  • Defining data source views
  • Creating and refining models

Creating reports with Report Builder

  • Deploying Report Builder to users
  • Dragging and dropping entities onto charts and tabular reports
  • Navigating data with infinite drill through

Programming Reporting Services

Expanding the capabilities of SSRS

  • Exploiting SSRS Web services
  • Searching for information in a report
  • Writing a Windows application with Report Viewer controls

Delivering Business Intelligence with SSRS

  • Mapping out the role of SSRS in a BI Infrastructure
  • Distinguishing SSRS technology components
 
http://www.learningtree.se/courses/se523.htm
 
 
08-506 668 00
Training You Can Trust®
 
 

SQL Server 2005 Reporting Services

 
Kurs: 523   Längd: 4 dagar
 
 
Kurspriser
22 950 krOrd. Pris
kurspriser med
rabattprogram
14 300 krMed Treklöver
12 975 krMed Fyrklöver
17 350 krMed Företagskort -
10-kort
17 360 krMed ProPack 40
Alla priser i SEK, exkl moms.

I kursavgiften ingår bl a...

  • Kursplats
  • Gruppövningar
  • Tillgång till klassrumsutrustning
  • Omfattande kursmaterial
  • Lunch
  • För- och eftermiddagsfika
  • Kursdiplom
  • Kostnadsfritt deltagande i våra specialiserade Certifieringsprogram (inkl. tillhörande examenstester)
  
 

Nyttja våra förmånliga erbjudanden och avtal

Learning Trees Två-, Tre- och Fyrklöver
  • Personligt rabattprogram med 2, 3 eller 4 valfria kurser
  • Upp till 50 % rabatt per kurs jämfört med ord. pris
  • Läs mer på www.learningtree.se/klover
Learning Trees Företagskort
  • Flexibelt och kostnadseffektivt som ger upp till 35 % rabatt kurs jämfört med ord. pris
  • Utbilda valfri medarbetare, när som helst och var som helst under 12 månader
  • Läs mer på www.learningtree.se/foretagskort

Vi garanterar att du blir nöjd

Om du inte känner dig 100 % övertygad om att Learning Tree har levererat vad du förväntat dig så tar vi inte ut någon avgift för ditt kursdeltagande. Vår kvalitetsgaranti ger den enskilde deltagaren möjlighet att efter genomförd kurs endast betala om kursen uppfyller deltagarens förväntningar.

Boka dig idag!

Vårt omfattande kursschema ger dig möjlighet att välja både datum och kursort för din utbildning. Ring 08-506 668 00 eller boka dig online.
 
http://www.learningtree.se/courses/se523.htm