Introduction To SQL Server Reporting Services -SSRS

Introduction To SQL Server Reporting Services -SSRS, available at $19.99, has an average rating of 3.6, with 29 lectures, based on 27 reviews, and has 606 subscribers.

You will learn about 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 This course is ideal for individuals who are Database programmers or Novice Database Administrators -DBA or Data Analyst or Data mining Analyst or Data Scientist or Project Managers or Business Analyst It is particularly useful for Database programmers or Novice Database Administrators -DBA or Data Analyst or Data mining Analyst or Data Scientist or Project Managers or Business Analyst.

Enroll now: Introduction To SQL Server Reporting Services -SSRS

Summary

Title: Introduction To SQL Server Reporting Services -SSRS

Price: $19.99

Average Rating: 3.6

Number of Lectures: 29

Number of Published Lectures: 29

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $94.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Database programmers
Novice Database Administrators -DBA
Data Analyst
Data mining Analyst
Data Scientist
Project Managers
Business Analyst

Target Audiences

Database programmers
Novice Database Administrators -DBA
Data Analyst
Data mining Analyst
Data Scientist
Project Managers
Business Analyst

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.

Course Curriculum

Chapter 1: Setting up your lab environment

Lecture 1: Introduction

Lecture 2: What is Microsoft SQL Server

Lecture 3: What is Microsoft SQL Server Reporting Services -SSRS

Lecture 4: Hardware and Software Requirements for SQL Server

Lecture 5: Download SQL Server 2014

Lecture 6: Install SQL Server 2014

Lecture 7: Installing Multiple Instance of SQL Server

Lecture 8: Connecting to named instance of SQL Server

Lecture 9: Download Adventurework2014 Database

Lecture 10: Attaching Adventureworks 2014 Database to SQL Server 2014

Lecture 11: Preparing your computer for Visual studio

Lecture 12: Installing Visual Studio 2015 Community Edition

Lecture 13: Completing Visual Studio Installation

Lecture 14: Installing SQL Server Data Tools

Chapter 2: Creating a Basic Table Report with SSRS

Lecture 1: Requirements

Lecture 2: How to enable built-in administrator account in Windows

Lecture 3: SQL Server Reporting Services Configuration Manager

Lecture 4: Configuration of SQL Server Reporting Services -SSRS

Lecture 5: Granting users access to SQL Server Reporting Services

Lecture 6: Creating a Report Server Project

Lecture 7: Creating a Report Definition File

Lecture 8: Defining the Data Source

Lecture 9: Defining the DataSet

Lecture 10: Adding a Table to the Report

Lecture 11: Formatting Your Report

Lecture 12: Grouping Data

Lecture 13: Adding Totals to your Report

Lecture 14: Publishing your Report

Lecture 15: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 2 votes
2 stars: 0 votes
3 stars: 8 votes
4 stars: 9 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu