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

[Abhyasa]

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

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

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

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


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

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

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



[b]Course Contents[/b]

[b][u]Life Cycle of Database (SQL Server):[/u][/b]
[color=#282828][font=helvetica, arial, sans-serif] -> Design[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif] -> Implementation[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif] -> Maintenance[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif][u][b]Module1: Design[/b][/u][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Basics[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> SQL Server Environment[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Constructing tables [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Data Types[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Data Integrity[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Relationships[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Normalization[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> DDL-Data Definition Language[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> DML-Data Manipulation Language[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> DCL-Data Control Language[/font][/color]

[u][b]Module2: Implementation[/b][/u]
[color=#282828][font=helvetica, arial, sans-serif]-> Joins and Sub Queries[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Views[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Stored Procedures[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> User Defined Functions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Transactions and Locks[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Cursors[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]-> Triggers[/font][/color]


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

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