[CLOSED] SSRS in Real World

Name: [CLOSED] SSRS in Real World
Rating: 4.4 (44 reviews)

Learn how to Master SQL Server Reporting Services (SSRS) in a Real Business Context

Created byAndrea Sabatino

Last updated 8/2023

English

What you'll learn

Install and configure Modern tools like SQL Server Express 2017, SSMS, SSRS 2017, VisualStudio 2019 to start Reporting from scratch
Create and customize Charts, use Parameters, Variables, Pagination, Sorting, Sub-Report and so on
Design Professional Reports with Real World techniques
Use SSRS in a Real Business Context, transforming a customer's request into a clean report delivery in 7 phases
Ensure Report Quality by an accurate and automated Testing Phase

Course content

6 sections • 61 lectures • 2h 17m total length

Course Introduction3:04
General introduction to the course: author, ideal target, course object, course outline

Introduction0:43
Installation general overview
Install SQL Server Express1:54
Install SSMS (Sql Server Management Studio)2:36
How to install SSMS for managing and browsing SQL Server Express.
Install AdventureWorks Sample Database3:24
How to install tha AdventureWorx database, to have a test database with some data in it-
Install SSDT on Visual Studio 20192:30
How to install SSDT (Sql Server Data Tools) on Visual Studio 2019. It's an integration bridge between your IDE and the database.
Install SSRS1:37
How to install SSRS, the Reporting backend database used under the hood by reporting functionality itself.
Configure SSRS5:05
How to configure SSRS and access reports from a browser.
Key Points0:17
Let's highlight key points of this section.

Introduction0:36
Let's highlight key points of this section.
Create a Datasource2:27
How to create a Datasource
Create a Dataset4:02
How to create a Dataset linked to a Stored Procedure
Create a Report Object1:49
How to create a Report object
Report Under The Hood1:33
Undestand what is a Report under the hood
First Report Design2:55
Create your first Hello World Report!
Visualize Data3:16
Visualize data with Tablix, use Labels and text styles
SQL Resources1:23
Overview of external resources to learn SQL language in deep
Report Deploy4:31
Deploy the report to the web server
Quiz Time!
Key Points0:34
Let's highlight key points of this section.

Introduction0:37
Let's highlight key points of this section.
Create Report Parameters1:45
How to create Report Parameters
Use Report Parameters as Stored Procedure input1:55
How to use Report Parameters as Stored Procedure's input
Use Report Parameters as Drop Down List3:40
How to use Report Parameters as Drop Down List
Expressions3:53
Understand Expression and how to use them
Header & Footer5:23
How to create Header and Footer in a Report
Report Link & Recursion3:39
How to create links between Reports and exploit Recursion
Filtering2:16
How to filter a Dataset
Sorting1:04
How to sort a Dataset
Interactive Sorting1:40
How to enable user to sort Tablix columns by himself
Subreports3:07
Why, how and when to use Subreports
Charts2:50
How to create Charts
Charts Customization2:47
How to perform advanced charts customization
Quiz Time!
Key Points0:32
Let's highlight key points of this section.

Introduction - 7 phases2:11
Let's highlight key points of this section: 7 phase to deliver a report to your customer
Overall Time Estimation1:12
How to estimate the amount of work to deliver a Report Set
Phase 1: Understand - Functional Requirements3:30
Understand functional requirements from a quick mail
Phase 1: Understand - Non Functional Requirements0:49
Understand non-functional requirements from a quick mail
Phase 2: Design - Report Input and Ouput5:26
How to design report input and output that meet the requirements
Phase 2: Design - Report Implementation1:00
How to design the implementation path
Phase 3: Ask1:17
How to ask efficiently to customer and collegues
Phase 4: Implement - Data Formatting Models3:47
Where to format data and why
Phase 4: Implement - Stored Procedure - Homework0:45
Coding exercise assignment: create the report backend as a Stored Procedure
Phase 4: Implement - Stored Procedure - Solution2:27
Coding exercise solution: Calendar Stored Procedure
Phase 4: Implement - Stored Procedure - Fat SP & Multiple Resultsets2:44
"Fat" Stored Procedure mode, how to handle multiple Resultsets
Phase 4: Implement - FrontEnd - Homework0:31
Report FrontEnd implementation assignment
Phase 4: Implement - FrontEnd - Solution2:16
Report FrontEnd solution
Phase 4: Implement - FrontEnd - Layout By Table2:40
Implement FrontEnd efficiently: layout by table
Phase 5: Test - Targets1:06
Understand what to test after implementation
Phase 5: Test - Test Book1:17
Learn what is a Test Book and its importance for Quality
Phase 5: Test - Test Automation with Selenium (Part 1)5:44
Learn how to automate report test with Selenium IDE
Phase 5: Test - Test Automation with Selenium (Part 2)4:43
Learn how to automate report test with Selenium IDE
Phase 6: Improve - Performance4:14
How to check report performance
Phase 6: Improve - Report Variables2:25
How to define Variables in a Report, and why
Phase 6: Improve - Report Shared Variables0:59
How to defined Variables shared between Reports, and why
Phase 6: Improve - Report Shared Graphics0:41
What graphic elements to share in a Report Set, and why
Phase 7: Maintenance0:37
How to keep your report healthy after the delivery
Quiz Time!
Key points0:32
Let's highlight key points of this section.

Requirements

A minimal base of SQL language could help, but is optional
A minimal base of SQL Server could help, but is optional

Description

[CLOSED]

Welcome to SSRS in Real World!

As You can imagine, teaching SSRS Reporting today cannot be a flat enumeration of functionalities, Real World is different.

In a Company, You often start from a quick specification e-mail written by your customer, where 40% of requirements is missing and you have to fight to define them properly. Moreover, you have to think to non-functional requirements, like Performance and Usability. Customer never asks for them, but always needs them.

SSRS in Real World covers both technical functionalities and their practical application, leveraging on transversal best practices and approaches, covering the entire lifecycle of a Report.

In this intensive course I'm not going to cover any functionality of SSRS. I will focus on a specific list of most used functionalities, step by step, enabling you to build the 80% of Reports You will be asked for.

At the beginning, You will learn how to create your first Hello World Report from scratch. After, You will enhance it with several additional features.

Then, I will introduce you to Real World aspects, like Report Requirements Analysis, Effort Estimation, Mockup Definition, Team Interactions, Practical Implementation Strategies, Quality Control and Performance Checking.

After this course, You will be able to transform any Report request in a Successful Delivery!

Let's start!

Who this course is for:

Developers interested in learning how to Reporting with SSRS at work

[CLOSED] SSRS in Real World

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Installation8 lectures • 18min

IDE4 lectures • 5min

Your First Report10 lectures • 23min

Report Design14 lectures • 35min

Report Design in Real World24 lectures • 53min

Requirements

Description

Who this course is for: