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.
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.
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.
We will go over how to install SQL express as it will be the primary datasource in this course.
We will cover installing and configuring SSRS for first time use.
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.
In this lecture, we will learn about configuring report manager for first time use.
We will import the sample database we will be using for this course.
In this lecture, we are going to discuss what a relational database is and the main advantages of using a relational database.
We will go over how to use the SELECT statement to select data from the database.
We will cover how to use the INSERT statement to add records into a table.
This video will show how to UPDATE records in a table.
This video will cover how to DELETE records from a table.
We will cover how to use JOIN, to combine data from multiple tables.
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.
In this lecture, we will cover how to import and export .rdl files using Report Manager.
In this video we will cover creating shared data sources within Report Manager.
In this lecture, we will cover using the new report wizard to create our first report.
In this lecture, we will go over displaying item properties and modifying them.
In this lecture, we will discuss what parameters are and go over the properties of them.
In this lecture, we will cover adding a chart to our report and we will look at the different types of charts.
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.
In this lecture, we will go over exporting reports and the file types available.
In this lecture, we will cover what the Report Viewer is and how to use it.
In this lecture, we will go over setting up subscriptions to have reports emailed to our end users.
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.