SQL Server Reporting Services (SSRS) 101

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.

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

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.