SQL Server Reporting Services Core Skills (1 day)


SQL Server Reporting Services is Microsoft's premier reporting tool. This course is designed to take you through the most important components of SSRS, with just the right amount of depth, within a single day.

The course is most suitable for developers that need to learn to work with the Microsoft BI platform or for existing SQL Server developers and DBAs that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

In the course, you'll see how to create rich server-based reports using SQL Server Reporting Services, see how to create dynamic reports with parameters and interactivity, and how to manage the reports in terms of security and scheduling. You'll also see how end-users can build their own reports using Report Builder.

While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us


DAY 1 RS201 INTRODUCING SERVER-BASED REPORTING SERVICES
Server-based Reporting Fundamentals
Creating Reports
Common Report Items
Deploying Reports
LAB: Creating and Deploying Reports
DAY 1 RS202 WORKING WITH COMMON REPORT ELEMENTS AND CREATING DYNAMIC REPORTS
Additional Common Report Elements
Creating Dynamic Reports Using Parameters
Creating Dynamic Reports Through Links and Document Maps
LAB: Creating Dynamic Reports
DAY 1 RS203 MANAGING REPORT EXECUTION AND SECURITY
Extending Reports with Custom Logic
Reporting from Analysis Services
Optimising Report Execution
Securing Report Server Items and Data
Delivering Reports with Subscriptions
LAB: Managing Report Execution and Security
DAY 1 RS204 END-USER REPORTING WITH REPORT BUILDER
Introduction to Report Builder
Creating Map-Based Reports
Data-Feeds as Data Sources
LAB: Report Builder Self-service Reporting