Grootste online IT opleider

Beste klantenservice

Award winning e-learning

Na betaling, direct starten

Training: SSRS 2014 Advanced

€ 199,00
€ 240,79 Incl. BTW

Duur: 28 uur |

Taal: Engels (US) |

Online toegang: 90 dagen |

In Onbeperkt Leren

Gegevens

In deze SSRS 2014 cursus leert u de belangrijkste geavanceerde functionaliteiten van Reporting Services kennen. Zo weet u hoe SSRS kunt inzetten en optimaal kunt gebruiken in uw dagelijkse werkzaamheden. Ook de Report Builder en Report Manager komen uitgebreid aan bod.

Resultaat

Na het volgen van deze cursus bent u bekend met de belangrijkste geavanceerde functionaliteiten van SQL Server Reporting Services 2014.

Voorkennis

U heeft bij voorkeur MCSA SQL Server 2012 behaald of vergelijkbare kennis.

Doelgroep

Databasebeheerders

Inhoud

SSRS 2014 Advanced

28 uur

SSRS 2014: Introduction and Report Builder

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer. Next you’ll get a solid introduction to Report Builder, and learn how to install either the standalone version or the ClickOnce version accessible from Report Manager. I’ll walk you through a tour of the Report Builder user interface. Then I’ll show you how to build a simple report, point out more of Report Builder’s features and learn about preview performance. Finally, you’ll learn about shared datasets as a way to make data access easier for end users.

SSRS 2014: Creating Reports

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer.

SSRS 2014: Tablix Report Type

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer. Next you’ll get a solid introduction to Report Builder, and learn how to install either the standalone version or the ClickOnce version accessible from Report Manager. I’ll walk you through a tour of the Report Builder user interface. Then I’ll show you how to build a simple report, point out more of Report Builder’s features and learn about preview performance. Finally, you’ll learn about shared datasets as a way to make data access easier for end users.

SSRS 2014: Expressions and Functions

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer. Next you’ll get a solid introduction to Report Builder, and learn how to install either the standalone version or the ClickOnce version accessible from Report Manager. I’ll walk you through a tour of the Report Builder user interface. Then I’ll show you how to build a simple report, point out more of Report Builder’s features and learn about preview performance. Finally, you’ll learn about shared datasets as a way to make data access easier for end users.

SSRS 2014: Layout, Parameters, and Visualizing

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer. Next you’ll get a solid introduction to Report Builder, and learn how to install either the standalone version or the ClickOnce version accessible from Report Manager. I’ll walk you through a tour of the Report Builder user interface. Then I’ll show you how to build a simple report, point out more of Report Builder’s features and learn about preview performance. Finally, you’ll learn about shared datasets as a way to make data access easier for end users.

SSRS 2014: Accessing and Subscribing to Reports

In this course, you’ll learn about some of the issues you’re likely to face starting Report Manager and connecting to a report server. Then you’ll learn about some of the cool features from a report user’s perspective to find reports, view them, and access a report’s document map. Next you’ll learn about the My Reports folder. An admin has to enable this feature before users can use it, but then it provides a location for each user to save links to reports they use often as well as their own reports. Then the course explores the various export formats supported by Reporting Services. You’ll learn about soft and hard page-break renderers, as well as the data exchange formats that can export the raw data from a report.

SSRS 2014: Programming Report Access

There are five major APIs that you can use to program report server access, and this course will cover two of them. First, we’ll look at accessing reports using a custom URL, which is the same way Report Manager provides access, although you can use a shorthand version of the URLs for easier programming. You’ll learn the structure of the URL, and see various ways to build the URLs and some of the many options available as querystring parameters. Then you’ll learn about the ReportViewer control that is available in both Web and Windows Forms .NET applications. You’ll learn how to use the control with both server and local reports, which are reports you build directly in Visual Studio for that application.

SSRS 2014: Web Service Programming

In this course you’ll learn how to use the Report Server Web Service, and see some examples of how useful it is. You’ll learn about the two endpoints that Reporting Services exposes, the management and execution endpoints, and the differences between them. You’ll also see how to build an application using the Web services to display a list of reports and render format options, both retrieved dynamically from the report server, as well as how to execute the selected report using both a custom URL and the execution Web service. As a bonus, you’ll learn how to dynamically determine whether the selected report has required parameters and one way to supply parameters to the report.

SSRS 2014: Managing Reporting Services

In this course you’ll learn about reporting tools, starting with seeing how you can use Management Studio for some tasks. Management Studio is far more limited than Report Manager for report server management, but nonetheless supports some important tasks. You’ll learn the three primary kinds of tasks you’ll need to use Management Studio for, as well as how to access those features. Then you’ll explore the management features of Report Manager. You’re likely to use Management Studio occasionally for the tasks it supports, but use Report Manager every day to do things like manage files and folders, including reports, and change and manage site settings and folder and object settings.

SSRS 2014: Reporting Services Security

In this course, you’ll learn how to work with the security features of Reporting Services. You’ll start by learning how to authorize users to perform actions at both the server and folder level, as well as how to use Management Studio to manage report server roles. Then you’ll learn how to enable Basic authentication, necessary to allow report access via non-IE browsers and outside the local network. It is generally a very bad practice to transmit credentials or data in the clear over any network, even a local network, so next you’ll see how you can enable and optionally require the use of SSL (really TLS, or Transport Layer Security) anytime a user or application accesses Reporting Services. Then you’ll learn about how report data security hooks into the data security features of the core database engine of SQL Server. You’ll see how to require different kinds of credential for any data source, both in SQL Server Data Tools and in Report Manager. You’ll also learn about the permissions required to access data for a report.

Opties bij cursus

Wij bieden, naast de training, in sommige gevallen ook diverse extra leermiddelen aan. Wanneer u zich gaat voorbereiden op een officieel examen dan raden wij aan om ook de extra leermiddelen te gebruiken die beschikbaar zijn bij deze training. Het kan voorkomen dat bij sommige cursussen alleen een examentraining en/of LiveLab beschikbaar is.

Examentraining (proefexamens)

In aanvulling op deze training kunt u een speciale examentraining aanschaffen. De examentraining bevat verschillende proefexamens die het echte examen dicht benaderen. Zowel qua vorm als qua inhoud. Dit is de ultieme manier om te testen of u klaar bent voor het examen. 

LiveLab

Als extra mogelijkheid bij deze training kunt u een LiveLab toevoegen. U voert de opdrachten uit op de echte hardware en/of software die van toepassing zijn op uw Lab. De LiveLabs worden volledig door ons gehost in de cloud. U heeft zelf dus alleen een browser nodig om gebruik te maken van de LiveLabs. In de LiveLab omgeving vindt u de opdrachten waarmee u direct kunt starten. De labomgevingen bestaan uit complete netwerken met bijvoorbeeld clients, servers, routers etc. Dit is de ultieme manier om uitgebreide praktijkervaring op te doen.

Waarom Icttrainingen.nl?

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Bestelproces

Zodra wij uw order en betaling hebben verwerkt, zetten wij uw trainingen klaar en kunt u aan de slag. Heeft u toch nog vragen over ons orderproces kunt u onderstaande button raadplegen.

lees meer over het orderproces

Wat is inbegrepen?

Certificaat van deelname ja
Voortgangsbewaking ja
Geschikt voor mobiel ja
Kennis delen Onbeperkte toegang tot onze community met IT professionals
Studieadvies Onze consultants zijn beschikbaar om je te voorzien van studieadvies
Studiemateriaal Gecertificeerde docenten met uitgebreide kennis over de onderwerpen
Service Service via chat, telefoon, e-mail (razendsnel)

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Meerdere cursussen volgen? Misschien is ons Life Long Learning concept wel wat voor u

lees meer

Neem contact op

Studieadvies nodig? Neem contact op!


Contact