SQL Server Reporting Services (SSRS) 101
4.5 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
156 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Reporting Services (SSRS) 101 to your Wishlist.

Add to Wishlist

SQL Server Reporting Services (SSRS) 101

Learn how to build professional reports using SSRS with no previous experience.
4.5 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
156 students enrolled
Created by Andy Swinford
Last updated 6/2015
English
Current price: $10 Original price: $70 Discount: 86% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Install and configure SSRS
Build professional reports using SSRS
Understand Report Manager and permissions
Understand the basics of SQL
View Curriculum
Requirements
  • Basic IT skills
  • An understanding of SQL is helpful, but not necessary
Description

SQL Server Reporting Services 101 covers everything you need to get started using SSRS. This course is designed to teach the basics of SQL Reporting thoroughly in a practical and efficient manner.

Get up to Speed Developing Professional Reports Quickly.

  • Configure SQL and SSRS
  • Learn to Write SQL Queries
  • Develop Professional Reports
  • Deploy Reports to Shareholders

Build Reports Using SQL Server Reporting Services

SSRS has been one of the top reporting platforms since its debut in 2004 and continues to be a leader in the market. Many fortune 500 companies rely on SSRS Developers to continually analyze and provide data in meaningful ways.

In this course, we will be getting you up to speed on configuring the tools and creating reports in a timely manner. We will cover everything you need to get started feeling comfortable using the software and making professional reports.

I designed this course to be accessible to anybody that is wanting to learn new skills in reporting. After taking this course, you will have all the skills you need to be able to create professional reports and deploy them to your customers.

Who is the target audience?
  • Individuals who are trying to further their understanding of SQL Reporting Services
  • Individuals who want to build professional reports in a timely manner
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 24 Lectures Collapse All 24 Lectures 01:19:14
+
Introduction
6 Lectures 13:46

Course introduction and overview of the content in this course. If you have any questions or comments during this course, please reach out and I will make sure to respond at my earliest convenience.

Preview 01:04

We will go over how to install SQL express as it will be the primary datasource in this course.

Preview 04:05

We will cover installing and configuring SSRS for first time use.

Configure SSRS
02:02

We will be using report builder for creating our reports in this course. We will go over installing report builder and configuring it to connect to SSRS.

Preview 01:14

In this lecture, we will learn about configuring report manager for first time use.

Configuring Report Manager
03:10

We will import the sample database we will be using for this course.

Import AdventureWorks Database
02:11
+
SQL Basics
7 Lectures 20:14

In this lecture, we are going to discuss what a relational database is and the main advantages of using a relational database.

Preview 03:18

We will go over how to use the SELECT statement to select data from the database.

Preview 03:50

We will cover how to use the INSERT statement to add records into a table.

Inserting Records
02:57

This video will show how to UPDATE records in a table.

Updating Records
03:04

This video will cover how to DELETE records from a table.

Deleting Records
01:15

We will cover how to use JOIN, to combine data from multiple tables.

SQL Joins
03:01

We will cover some basic aggregate functions in this lecture. Aggregate functions can be very useful in reporting as they perform a calculation on a set of values.

  • AVG() - Returns the average value.
  • COUNT() - Returns the number of rows.
  • FIRST() - Returns the first value.
  • LAST() - Returns the last value.
  • MAX() - Returns the largest value.
  • MIN() - Returns the smallest value.
  • SUM() - Returns the sum.
Aggregate Functions
02:49
+
Report Manager and Creating Data Sources
2 Lectures 06:16

In this lecture, we will cover how to import and export .rdl files using Report Manager.

Using Report Manager
04:12

In this video we will cover creating shared data sources within Report Manager.

Creating Data Sources
02:04
+
Building Your First Report
4 Lectures 22:26

In this lecture, we will cover using the new report wizard to create our first report.

Using the Matrix Wizard
05:04

In this lecture, we will go over displaying item properties and modifying them.

Properties
06:02

In this lecture, we will discuss what parameters are and go over the properties of them.

Report Parameters
04:10

In this lecture, we will cover setting up cascading parameters for our report.
Cascading Parameters
07:10
+
Charts
2 Lectures 07:54

In this lecture, we will cover adding a chart to our report and we will look at the different types of charts.

Adding a Chart
05:33

We are going to add the finishing touches to our first report. We will add a chart title as well as fix some of the headers.

Finishing Touches
02:21
+
Delivering Reports
3 Lectures 08:38

In this lecture, we will go over exporting reports and the file types available.

Exporting Reports with Report Builder
02:35

In this lecture, we will cover what the Report Viewer is and how to use it.

Using Report Viewer and URL Parameter
02:51

In this lecture, we will go over setting up subscriptions to have reports emailed to our end users.

Setting Subscriptions
03:12

Delivering Reports Quiz
2 questions
About the Instructor
Andy Swinford
4.6 Average rating
24 Reviews
195 Students
2 Courses
Software Engineer, Application Analyst, Reporting Guru

Andy Swinford is a highly experienced professional with a vast background from his 10+ years working in Information Technology. Andy's previous roles range from System Administration, Software Engineering as well as more than 5 years experience with utilizing various technologies to provide reports for all levels requested.

Andy is a very skilled software engineer and has experience in SQL, MySQL, PHP, C#, ASP MVC, JavaScript and a few other languages. At any opportunity Andy has, he works to learn new, and better his current skills.