SQL Server Reporting Services Part 1 (SSRS)
4.6 (247 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.
1,685 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

SQL Server Reporting Services Part 1 (SSRS)

Learn how to create from simple to complex reports for your business decision making needs
Best Seller
4.6 (247 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.
1,685 students enrolled
Created by Raphael Asghar
Last updated 3/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Install SQL Server 2016, Microsoft Visual Studio 2015, create from scratch simple to complex reports that allow the upper management and end users to make important business decisions based on the reports generated
View Curriculum
Requirements
  • All material, applications, documents, SQL scripts will be provided by the instructor via a zip file that is requested. Student need to take Learn T-SQL course before taking this course (and or SQL Admin part 1, 2, 3 not mandatory but helpful)
Description

After completing this course, the student will be able to install SQL Server 2016, install Microsoft Visual Studio and create from scratch reports from simple to complex reports that aid in upper management in making important business decisions; and at the same time, aid the end user to view, interact with, and distribute reports in various platforms.  He will be versed in creating, formatting, designing, and submitting reports that the users will benefit from each business day.  The student will learn how to navigate through Microsoft visual Studio, learn how to to save .rdl files, create templates, render reports in various format, apply different methods of creating rich reports, help the end user with avoiding redundant input of data, examine ways to insure end user has aggregates for reports and be able to communicate the needs of the company via reports.  This knowledge will make the student become well versed in the ability to help the organization in moving forward with summary visual data.

Who is the target audience?
  • Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions
  • Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions. Students will need Learn T-SQL course created by me to help understand the T-SQL scripts created for each report.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
32 Lectures
06:03:43
+
SQL SERVER REPORTING SERVICES (SSRS)
32 Lectures 06:03:43


Download site for SQL 2016 Server
13:49

Correction of next Video
01:12

Download and install SQL Server Data Tools
08:28

Download and attach database AdverntureWorks2016
12:19

Creating a first simple SSRS report
19:22

The basics of formatting a simple report
18:37

Freezing the header columns of report
15:43

Creating a table using the table item object part 1
10:29

Creating a table using the table item object part 2
10:21

Create a Header and a Footer
17:12

How to group columns and use drill down
14:37

Grouping and creating subtotal and totals
13:08

Creating Grand Totals for numbers
04:52

Creating multiple drill down on columns part 1
13:13

Creating multiple drill down on columns part 2
07:34

Importing images
09:15

What is a matrix report
09:22

Creating charts
12:09

What are indicators
13:16

Using and creating a powerful list report
16:01

What are parameters
09:03

Creating a parameter
19:53

Creating a cascading parameter part 1
10:01

Creating a cascading parameter part 2
10:59

Using conditional formatting on a report
11:50

Creating and using templates
10:00

Creating and using templates part 2
10:08

Creating sub reports
14:41

Creating an embedded sub report
05:15

What is the benefit of a bookmark
05:53
About the Instructor
Raphael Asghar
4.6 Average rating
2,144 Reviews
23,198 Students
13 Courses
Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 12 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.