SSRS Reporting & T-SQL Combo with Real World Tricks 15+ Hrs

SSRS Reporting & T-SQL Combo with Real World Tricks 15+ Hrs

This course starts from the beginning , no prior knowledge is needed and it is step By step Practical Training on Programming Transact SQL Query from basics on Microsoft SQL Server Database Engine and Microsoft SQL Server Reporting Services Online Tutorial using Visual Studio 2017 or SQL Server Data Tools.

This course is must for all the Aspirants who want to become Microsoft SQL Server Database Developers , Microsoft Database Administrator, Web Developers such as .NET Developers,Database ANALYSTS , Report Developers such as SSRS or ETL Developers such as SSIS etc

The following topics are covered in this SSRS Reporting Video Training Course. After learning this course you will be able to handle real world reporting scnarios.

Following are the course contents which are covered in   T-SQL Online SQL Server Video Step By Step Training

Introduction

What is a Relational Database

What is Relational Database Management System

SSMS and SQL Server Database Engine

SQL Server and SSMS Installation

Basic T-SQL

Creating DB Tables & Inserting Data into the tables

Primary Key and Foreign Key

Basic Select Commands

Aggregate Functions with SELECT Command

Group By Clause using Single and Multiple Columns

Difference Between WHERE and HAVING Clause

Syntax of SELECT Command

T-SQL Joins to query SQL Server

Inner Join

T-SQL with Inner Join and Group By Together

Left Join

Right Join

Full Join

Cross Join

Self-Join

Union Operation

Union All Operation

Intersect Operation

Except Operation

Working with Schema

What is Schema and its Importance

Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL

Subqueries

Getting Started with first Subquery Example

Common Interview Question on Subquery

Joins Group by Derived table Subquery combined TSQL

Subquery as a Column

Subquery using NOT Exists

ALL ANY SOME Keywords in Subquery

Correlated Subquery

Not Exists Keyword Scenario of Correlated Subquery to speed up query performance

Datatypes

Datatype Conversion

Implicit & Explicit Conversion (Type Casting)

DML Operations and Constraints

Many Different Options while performing insert update and delete operations

Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints

Joining more than two tables

Joining three tables

Joining four Tables

One more example in joining four tables

Working with CASE Statements and Inbuilt Functions

Performing Select and Update operation using case statement

WHILE Loop

Inbuilt Functions - EOMONTH, IIF, CHOOSE, DatePart, String Functions etc.

Following are the course contents which are covered in SSRS Reporting Online  Video  Recording Step By Step Training

SSRS Reporting Process

Shared and Embedded DataSource and DataSet

Report Generation using Report Wizard

SSDT Components Explained

DataSet used in SSRS Reporting Explained

Tablix Report

SSRS Grouping

Why to create Black and White Report

DrillDown Option

Page Break in SSRS

Merge and Sort a column based on another column

Add Calculated Field

How to display loss in Red Color

Advantage of Creating Calculated Field

Report Header , Report Footer , Page Header and Page Footer

How to Reset Page Number on the basis of a Group

How to create Document Map

How to display first 3 characters of every month for the consistent report

How to Repeat Column Header on each Page of a Report in SSRS

How to Freeze the Headers of a Table in the SSRS Report

How to hide the Advanced Mode

How to Display Different Currency Symbols in SSRS

How to Display Different Currency Symbols in SSRS

Parameterized Reports

How to Add Parameters in the Report

How to use DropdownParameters in SSRS Report

How to implement Multi-Select Parameters Option for SSRS Reports

How to add All option to SSRS dropdown

Fixing the No Record issue in the Report

How to Manually Add the Options in SSRS Dropdown

How to setup the Default Value in the Dropdown

How to Generate Cascading Parameters in the SSRS Report

How to deal with Multiple Values in the Cascading Parameters

Display No Data Available for Empty Dataset and Dynamically play with Parameters

How to use a Column which has Date Datatype as a Parameter

Chart Reports

Creating Charts

How to make Lower Values Visible in SSRS charts using Scale Breaks Option

Tooltip DataLabels and Changing Chart Types

Mixture of Columns and Lines in a Single Chart

Dynamically changing the Chart Title based on the Dropdownlist Selected Options

How to display a Table Report after clicking on a Chart using Drillthrough Option

Changing Vertical Axis values in the Chart

Major Ticks, Minor Ticks, Major Gridlines & Minor GridLines

Pie Chart

Legends in the Pie Chart

Advanced Reporting

Matrix Report

How to convert Detailed Data into Summary

List in SSRS

Table inside a List

Sum Function with different Scopes in an expression

Indicators

Databars

Creating trends using Sparklines

How to Name Worksheets with the Group Name Values when Exporting Report to Excel

Using Stored Procedures as Dataset

Subreport in SSRS

Microsoft SQL Server Reporting Services Practical via Visual Studio SSDT & Programming Development Querying Transact SQL

Url: View Details

What you will learn

• Creating Database , Tables and Performing DML Operations
• Basic T-SQL - SELECT , WHERE , GROUP BY ,HAVING, BETWEEN , LIKE etc
• Joins - Inner Left Right Full & Cross , Joining more than two tables

Rating: 3.95

Level: All Levels

Duration: 15 hours

Instructor: Vikas Munjal