Project based MSBI & SQL Training step by step
28 Hours Live Training
What you'll learn :-
It is a 45 Days combined Training & Practicals on MSBI (SSIS, SSRS & SSAS) & SQL Server.
8 Months Video Subscription Program.
Doubt clearing related to Training Program.
Training Content
Learn MSBI in 45 Days(Project Based) -
Theory (30 Minutes) -
- Introduction of MSBI (SSIS, SSAS, SSRS), MSBI Tools.
Installation (60 Minutes) -
- MSBI Installation like Vsiual Studio, SQL Server, SQL Server Management Studio, SSDT Tools.
Practicals (24 Hours) -
- Lab 1 - ETL process (Extracting Data From Excel or CSV and Adding it Dataware House SQL Server DB).
- Lab 2 - SSIS Conditional Split, Derived Component and Data Conversion Component.
- Lab 3 - SSIS Error Handlings.
- Lab 4 - Understand SSIS Loops
- Lab 5 - SSIS Parameters, Environment Variables, File System Task, Package Deployment, Scheduling SSIS Package From SQL Server.
- Lab 6 - Understand Sort and Types of Joins in SSIS and Insert Update Data using Merge Join.
- Lab 7 - Understand OLAP, Star Schema, SnowFlake, Dimension and Facts and SSIS SCD and Lookup.
- Lab 8 - SSIS Data Profiling Task and Check Data Quality.
- Lab 9 - Designing Star Schema in SSIS.
- Lab 10 - Adding SSAS cube with Time Series to Star Schema with Excel Display
- Lab 11 - SSAS Hierarchical Dimensions.
- Lab 12 - Adding SSRS Report to Star Schema.
- Lab 13 - SSRS Reports (Matrix Tabular, Expression Parameters).
- Lab 14 - SSRS DrillDown and Subreports.
- Lab 15 - SQL Execute Task (SSIS).
- Lab 16 - SSAS KPI, Calculations and Many-to-Many Relationship in (SSAS).
- Lab 17 - Understand MDX (Multidimensional Expressions) Queries.
- Lab 18 - SSRS Bar Chart, Gauge and Indicators.
- Lab 19 - Understand Simple demo of WebServices and XML Task using WCF C# Code
- Lab 20 - SSIS DQS (Data Quality Service).
- Lab 21 - Script Component and Mailing.
- Lab 22 - CDC in SSIS.
- Lab 23 - SSAS Pivot, UnPivot and Aggregation.
Learn SQL Server Step by Step -
- Lab 1 - Introduction to SQL Server, RDBMS.
- Lab 2 - Installation of SQL Server and SQL Management Studio (Optional).
- Lab 3 - Security Windows and SQl Server authentication.
- Lab 4 - Basic Fundamentals Create DataBase and Create Tables, Rows and Columns.
- Lab 5 - Data Types in SQL, Auto Increment Primary Key / Unique Key / Referential Integrity and Constraints.
- Lab 6 - SQL Query writing : Create, Select, Insert, Alter, Delete, Update, Order By, Where Clause, Group By, AND, OR, NOT, Between, IN, Aliases, Having.
- Lab 7 - SQL Wildcards.
- Lab 8 - SQL Mathematical functions like Min, Max, Avg, Sum, Count, ABS, Round, Ceil and many more.
- Lab 9 - SQL JOINS .
- Lab 10 - SQL Stored Procedures.
- Lab 11 - SQL Normalization and Denormalization (OLTP and OLAP).
- Lab 12 - Star Schema and SnowFlake.
World-class training and development programs developed by top teachers
Whats Included
- World-class training teacher
- Bench has zero learning curve
- We handle the rest.