SQLserver

——–

Installation

Datatypes

Database,Table creation

Insertion,conditions

Joins

subqueries

views

Aggregation

procedures

functions

 

SSRS

——–

Data Sources

Query Design

Creating New Project

Create a New Report

Creating Shared Data Source

Create Shared Dataset

Combine Two Datasets

 

—-Items————–

 

List of Report Items

New Table Report

Create Table using Report Wizard

Creating a New Matrix

Create Matrix Report Using Report Wizard

Display Image in Report

Add TextBox to Report

 

—-Basic Reports——

 

Add Grouping 

Create a Report using SQL Views

Create a Report using SQL Stored Procedure

Add Totals, and Subtotals to Reports

Add, Or Remove Headers and Footers on Reports

Export Reports to PDF, XML, Excel, Word

 

—Formatting———

 

Format Table 

Changing Font and Background Color 

Format Numbers 

Format Date and Time in a Report

Repeat Headers on Each Page

Headers Visible 

Filters 

Filters at Dataset Level

Sorting Data 

Add Row Numbers to Report

 

—Advanced———-

 

Calculated Fields

Dashboards

Drill Down Reports

Drill Through Action

Matrix Drill Down

Page Breaks

Subreports

parameters

charts

Deploy Reports

 

—–SSAS—————-

 

SSAS INTRO, CONFIGURATION

New Project creation

Create Data Source

Cube Design with SQL Server Data Tools

Data Source View

Add or Remove Tables from Data Source View

Difference between Star Schema and Snow Flake Schema

Create Dimensions

Creating OLAP Cube

How to Create Cube Dimensions

Difference between Cube Dimension and Database Dimension

How to Create Named Calculations

CALCULATIONS, MDX

Creating Measure Groups

 

—-SSIS——————-

 

Introduction

Connection Managers

SSIS Connection Managers Introduction

OLE DB Connection Manager

ADO Connection Manager

ADO.NET Connection Manager

Cache Connection Manager

EXCEL Connection Manager

Create my first SSIS Package

 

–Sources———

 

How to Load Tab Delimited File To SQL Server Table in SSIS Package

How to Load Pipe Delimited File into SQL Server Table in SSIS Package

How to Load Multiple Comma Delimited Files to SQL Server Table in SSIS Package

How to Load Fixed  Width Text File to SQL Server Table in SSIS Package

How to load Data From Comma Delimited text file to SQL Server Table in SSIS Package

How to convert blank values to Null in Flat File Source in SSIS Package

How to use Raw File Source in SSIS Package

Fast Parse Flat File Source Property in SSIS Package 

How to use Stored Procedure with Parameters in OLE DB Source in Data Flow Task in SSIS Package 

 

—-Flow Tasks———

 

Bulk Insert Task

Data Profiling Task

Execute T-SQL Statement Task

SSIS Execute SQL Task

Introduction to Execute SQL Task

Truncate Table using Execute SQL Task – Result Set None

Execute SQL Task – Single Row Result Set

Executing SQL Task – Full Result Set 

Execute Package Task

Executing Packages in File System

Execute Packages in SQL Server

Executing Packages present in the Same Project

File System Task

Copy Directory

Copy File

Delete Directory Content

Move Directory

Delete Directory

Move File

Move Multiple Files

Delete File

Rename File

Set Attributes

FTP Task

Send Files

Send Multiple Files

Receive Files

Receive Multiple Files

Delete Local Files

Create Remote Directory

Delete Remote Directory

Create a Local Directory

Delete Local Directory

Delete Remote Files

Script Task

Transfer SQL Server Objects Task

Transferring SQL Server Tables with Data

Transfer SQL Server Table Structures without Data

Transferring SQL Server Stored Procedures

Transfer SQL Server User-Defined Function

Transferring SQL Server Views

 

—–Deployment———-

 

Deploy Project using SQL Server

Use SQL Deployment Wizard to Deploy Project

Breakpoints

Checkpoints

Error Handling

Event Handlers

Logging

Parameters

MSBI Course Training Institute in Dilsukhnagar Hyderabad India