SQL Server Reporting Services (SSRS)

Explore the advanced functionality, report server administration and security issues of SSRS.

course image

Course details

ceus icon CEUs 3.2

schedule icon Schedule Weekends

location icon Location Online, North Campus

cost icon Cost

$1,065

payment plan

Registration details

SQL Server Reporting Services (SSRS)

Explore the advanced functionality, report server administration and security issues of SSRS.

What you’ll be able to do — competencies

  • Install and configure SQL Server Reporting Services (SSRS) 2012 
  • Connect the Report Designer tool to data sources 
  • Create an SSRS 2012 report 
  • Make visual enhancements to an SSRS 2012 report 
  • Create an interactive report 
  • Manage the report environment 

Course description

expand drawer icon collaspe drawer icon

This course is designed to teach the advanced functionality, report server administration and security issues of SQL Server Reporting Services. Course topics include advanced report design, integrating parameters and filters, implementing interactive reporting features, scheduling automated delivery of reports, securing Reporting Services, optimizing report performance, implementing strategies for business and support systems, and rendering reports using .NET code.  

Prerequisites

expand drawer icon collaspe drawer icon
  • T-SQL Programming or equivalent knowledge required 

Syllabus

expand drawer icon collaspe drawer icon

Session 1

Introduction to SSRS 
Chapters 1–5 

  • Report Authoring and Server Architecture  
  • Database Basics  
  • Installing Reporting Services  
  • Exploring Reporting Services Fundamentals 

Session 2

Developing Reports Part 1 of 6
Chapters 6, 7 

  • Planning your report design 
  • Working with report server projects 

Session 3

Developing Reports Part 2 of 6 
Chapters 8, 9 

  • Retrieving data for a report 
  • Designing the report layout  

Session 4

Developing Reports Part 3 of 6 
Chapters 10, 11 

  • Working with the tablix 
  • Developing Expressions   

Session 5

Developing Reports Part 4 of 6 
Chapters 12, 13 

  • Using Functions 
  • Adding interactivity 

Session 6

Developing Reports Part 5 of 6 
Chapters 14, 15 

  • Creating dynamic reports with parameters  
  • Managing the page layout  

Session 7

Developing Reports Part 6 of 6 
Chapter 16 

  • Using Analysis Services as a data source 

Session 8

Adding Data Visualization – Part 1 of 2 
Chapters 17, 18 

  • Creating Charts  
  • Working with Chart Elements  

Session 9

Adding Data Visualization – Part 2 of 2 
Chapters 19, 20 

  • Comparing values to goals with gauges 
  • Displaying performance with indicators  

Session 10

Managing the Report Server
Chapters 23–25 

  • Deploying reports to a server 
  • Securing report server content 
  • Performing administrative tasks 

Session 11

Viewing reports 
Chapters 26–28

  • Accessing reports online 
  • Subscriptions 
  • Data alerts 

Next available start dates

Online — Weekends

Registration closed expand drawer icon collaspe drawer icon
SQL Server Reporting Services (SSRS)
hours icon

Total classroom hours

32 hours

schedule icon

Schedule

Online

Weekends, 12:30 PM - 4:30 PM, 7 S - 5/16/2020 - 7/11/2020, no class 5/23 and 7/4

cost icon

Total cost

$1,065

instructor icon

Instructor: Shankar Pal

Online — Days

Registration open expand drawer icon collaspe drawer icon
SQL Server Reporting Services (SSRS)
hours icon

Total classroom hours

32 hours

schedule icon

Schedule

Online

Days, 1:00 PM - 4:15 PM, 10 S - 9/26/2020 - 12/05/2020, No class 11/28

cost icon

Total cost

$1,065

instructor icon

Instructor: Shankar Pal

Interested in custom learning solutions for your team?

Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.

Get started