SQL Server Reporting Services (SSRS) 101

Learn how to build professional reports using SSRS with no previous experience.
4.1 (18 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.
124 students enrolled
$19
$70
73% off
Take This Course
  • Lectures 24
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2015 English

Course 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.

What are the requirements?

  • Basic IT skills
  • An understanding of SQL is helpful, but not necessary

What am I going to get from this course?

  • Install and configure SSRS
  • Build professional reports using SSRS
  • Understand Report Manager and permissions
  • Understand the basics of SQL

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
01:04

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.

04:05

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

02:02

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

01:14

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.

03:10

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

02:11

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

Section 2: SQL Basics
03:18

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

03:50

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

02:57

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

03:04

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

01:15

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

03:01

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

02:49

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.
Section 3: Report Manager and Creating Data Sources
04:12

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

02:04

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

Section 4: Building Your First Report
05:04

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

06:02

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

04:10

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

07:10
In this lecture, we will cover setting up cascading parameters for our report.
Section 5: Charts
05:33

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

02:21

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.

Section 6: Delivering Reports
02:35

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

02:51

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

03:12

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

Delivering Reports Quiz
2 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andy Swinford, 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.

Ready to start learning?
Take This Course