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

[Abhyasa]

[font=arial,helvetica,sans-serif][size=5]Hi friends,[/size][/font]

[font=arial,helvetica,sans-serif][size=5]We are providing online training on the following technologies by Real Time Experts.[/size][/font]

[font=arial,helvetica,sans-serif][size=5][b] -> SQL Server Development [/b][/size][/font]


[b][size=5][font=arial, helvetica, sans-serif] -> MSBI (SSIS, SSRS & SSAS)[/font][/size][/b]


[font=arial,helvetica,sans-serif][size=4][b]If you are interested, we will arrange demos for you.[/b][/size][/font]

[font=arial,helvetica,sans-serif][size=4][b][color=#282828]For demos, please contact to the below[/color][/b][/size][/font]

[b]Contact Details[/b]
[b]Sanjay : +91 9000205004[/b]
[b]Kiran : +91 9502766661[/b]
[b]Email : [size=4][font=arial, helvetica, sans-serif][color=#555555][email protected][/color][/font][/size][/b]



[b]Course Contents[/b]

[b][u]Life Cycle of Database (SQL Server):[/u][/b]
-> Design
-> Implementation
-> Maintenance

[size=4][u][b]Module1: Design[/b][/u][/size]
-> Basics
-> SQL Server Environment
-> Constructing tables
-> Data Types
-> Data Integrity
-> Relationships
-> Normalization
-> DDL-Data Definition Language
-> DML-Data Manipulation Language
-> DCL-Data Control Language

[u][b][size=4]Module2: Implementation[/size][/b][/u]
-> Joins and Sub Queries
-> Views
-> Stored Procedures
-> User Defined Functions
-> Transactions and Locks
-> Cursors
-> Triggers


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

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