Introduction To SQL Server Reporting Services -SSRS
3.8 (9 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.
550 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction To SQL Server Reporting Services -SSRS to your Wishlist.

Add to Wishlist

Introduction To SQL Server Reporting Services -SSRS

Learn Hands-On how to create a basic report using SQL Server Reporting Services
3.8 (9 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.
550 students enrolled
Last updated 3/2017
English
Current price: $12 Original price: $115 Discount: 90% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Configure SQL Server Reporting Services
  • Grant users access to the Reporting Services Server
  • Create a Report Server Project
  • Define a data source
  • Define a Dataset
  • Customize report parameters
  • Format Reports
  • Group Data in Reports
  • Add Totals to Reports
  • Publish and Deploy Reports through Report Server
View Curriculum
Requirements
  • Basic Understanding of Relational Databases
  • Basic working knowledge of SQL Server Management Studio
  • Basic T-SQL
  • Basic SQL
Description

This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility but is also  applicable to Microsoft SQLserver Reporting Services 2016 as well as  SQL Server 2008 R2 release and  later versions.   This course is for anyone
 who wants to develop reports and has no prior experience with SQL Server Reporting Services. I will walk you through how to use the development tools effectively to create, enhance and present reports.

The course starts off by setting up the environment which includes the installation of Microsoft SQL Server,SQL server Data Tools, Microsoft Visual Studio and also the download and installation of AdventureWorks 2014 sample database. We
 Will then explore the SQL Server Reporting Services Configuration which is configuration tool used to configure SSRS.
Whether you’re new to reporting services, or experienced with earlier versions, we’ll show you how to design and build reports and Leverage SSRS to extract business intelligence from your data. We will create dataset from our data source  and use T-SQL to create aliases ,aggregate functions,table-joins,grouping data with the having clause.

Topics include:
Configuration of SQL Server Reporting Services
Granting user access to the Reporting Services Server
Creating a Report Server
Defining a data source
Defining a Dataset
Customizing report parameters
Formatting Reports
Grouping Data in Reports
Adding Totals to Reports
Publishing and Deploying Reports through Report Server

By the end of the course, you’ll have developed a complete reporting solution and be ready to analyse and visualize your own business data with SQL Server Reporting Services.

Who is the target audience?
  • Database programmers
  • Novice Database Administrators -DBA
  • Data Analyst
  • Data mining Analyst
  • Data Scientist
  • Project Managers
  • Business Analyst
Compare to Other SQL Server Courses
Curriculum For This Course
28 Lectures
02:27:46
+
Setting up your lab environment
14 Lectures 01:05:40




Download SQL Server 2014
04:07

Install SQL Server 2014
06:47

Installing Multiple Instance of SQL Server
09:25

Connecting to named instance of SQL Server
03:44

Download Adventurework2014 Database
05:06

Attaching Adventureworks 2014 Database to SQL Server 2014
04:14

Preparing your computer for Visual studio
03:08

Installing Visual Studio 2015 Community Edition
07:47

Completing Visual Studio Installation
05:09

Installing SQL Server Data Tools
06:03
+
Creating a Basic Table Report with SSRS
14 Lectures 01:22:06
Requirements
01:48

How to enable built-in administrator account in Windows
04:09

SQL Server Reporting Services Configuration Manager
04:39

Configuration of SQL Server Reporting Services -SSRS
10:46

Granting users access to SQL Server Reporting Services
06:20

Creating a Report Server Project
03:01

Creating a Report Definition File
08:31

Defining the Data Source
04:49

Defining the DataSet
05:42

Adding a Table to the Report
07:24

Formatting Your Report
06:57

Grouping Data
05:05

Adding Totals to your Report
08:43

Publishing your Report
04:12
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,780 Reviews
39,058 Students
92 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.