*** Sql Server & Msbi(Ssis, Ssrs & Ssas) Online Training & Job Support

[Abhyasa]

Hi friends,

We are providing online training on the following technologies by Real Time Experts.

-> SQL Server Development

-> MSBI (SSIS, SSRS & SSAS)


If you are interested, we will arrange demos for you.

For demos, please contact to the below

Contact Details
Sanjay : +91 9000205004
Kiran : +91 9502766661
Email : [email protected]



Course Contents

Life Cycle of Database (SQL Server):
-> Design
-> Implementation
-> Maintenance

Module1: Design
-> Basics
-> SQL Server Environment
-> Constructing tables 
-> Data Types
-> Data Integrity
-> Relationships
-> Normalization
-> DDL-Data Definition Language
-> DML-Data Manipulation Language
-> DCL-Data Control Language

Module2: Implementation
-> Joins and Sub Queries
-> Views
-> Stored Procedures
-> User Defined Functions
-> Transactions and Locks
-> Cursors
-> Triggers


Introduction to MS - BI
--> What is MS-BI?
--> BI/DWH life cycle
--> ETL and OLAP Tools
--> Features of MS-BI
Introduction to SSIS
--> Package
--> Tasks
--> SSIS installation
--> SSIS Architecture
Developing SSIS Packages
--> SSIS Wizard
--> SSIS Designer
--> Control Flow Tasks
--> Data Flow Task [ETL]
--> Variables and Expressions
--> .Net Scripting in SSIS
Errors and Debugging SSIS
--> Events
--> Configure Error Output
--> Data viewers
--> Breakpoints
--> Execution Logging
SSIS Administration
--> Deployment
--> Configuration
--> Security
--> Manually Executing SSIS Package
--> Scheduling SSIS Package
--> Importing and Exporting Packages
--> Monitoring and Optimizing Packages

DWH with SSIS
--> DWH concepts and Architecture
--> Dimension Tables Data Loading
--> Fact Tables Data Loading
Introduction to SSRS
--> Data Sources
--> Datasets
--> Reports
--> Report Wizard
--> Report Designer
Authoring Reports
--> Report Items
--> Report Layout Sections
--> SSRS Expressions
--> Working with Data Regions
Advanced Authoring
--> Parameterized Reports
--> Drill Down Reports
--> Sub Reports
--> Filters in SSRS
--> Actions in SSRS
--> .NET Scripting in SSRS
SSRS Administration
--> Installation and Configuration
--> Deployment and Security
--> Subscriptions and Rendering
--> Caching and Snapshots
AD –Hoc Reports Development
--> Report Model Project
--> Model Designer
--> Report Builder
Introduction To SSAS
--> Dimensions
--> Facts
--> Data Sources
--> Data Source Views
Developing Cubes
--> Cube Designer
--> Partitions and Aggregations
--> Dimension Usage
--> Calculations and Kpis
--> Perspectives, Actions
--> Translations
--> Write-back feature
MDX Language
--> Axes, Slice
--> Tuple and set
--> MDX Queries
--> MDX expressions
--> MDX Scripts
SSAS Administration
--> Installation
--> Configuration 
--> Deployment
--> Processing
--> Security
--> Backup and Restore
Introduction to Data Mining