On demand Training Videos accessible at your comfortable timings. Our SSIS Video Training Service (Course Code: VC04) offers complete realtime practical knowledge transfer services for aspiring and working SQL BI / ETL Developers. Study and Practice Material with Realtime Case Study, Free LIVE Server Access for online Lab are included in this course. Register for SSIS & ETL/DW Video Training
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Description | SSIS | T-SQL & SSIS | T-SQL & SSIS, ADF |
No Of Videos | 12 Videos | 24 Videos | 34 Videos |
SSIS: Control Flow, Data Flow; SSIS DB | ![]() |
![]() |
![]() |
SSIS: Static & Dynamic Connections | ![]() |
![]() |
![]() |
SSIS: ETL, Data Warehouse Design | ![]() |
![]() |
![]() |
SSIS: Transformations, Data Loads | ![]() |
![]() |
![]() |
SSIS: Data Cleansing, Lookups | ![]() |
![]() |
![]() |
SSIS: Catalog Databases, Usage | ![]() |
![]() |
![]() |
SSIS: Deployments, Migrations | ![]() |
![]() |
![]() |
SSIS : Star & Snowflake Schemas | ![]() |
![]() |
![]() |
SQL : Basics, DDL, DML, SELECT | ❌ | ![]() |
![]() |
T-SQL : Constraints, Normal Forms | ❌ | ![]() |
![]() |
T-SQL: Joins, Group By, Queries | ❌ | ![]() |
![]() |
T-SQL: Merge, Pivot, Date & Time Formats | ❌ | ![]() |
![]() |
T-SQL: Excel Integrations, Pivot Charts | ❌ | ![]() |
![]() |
ADF : Azure Data Factory Architecture | ❌ | ❌ | ![]() |
ADF : Azure Data Warehouse Concepts | ❌ | ❌ | ![]() |
ADF : Massively Parallel Processing (MPP) | ❌ | ❌ | ![]() |
ADF : Copy Data Tool and ADF Portal | ❌ | ❌ | ![]() |
ADF : Stored Procedures For Incremental Loads | ❌ | ❌ | ![]() |
ADF : SSIS Package Migrations to Azure | ❌ | ❌ | ![]() |
Total Course Fee * | INR 7,000 USD 95 |
INR 11,000 USD 149 |
INR 20,000 USD 271 |
Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance.
Type: | 100% Practical & Example Based, Real-time |
No Of Videos: | 12 Videos (Duration: 80 mins per video) |
Course Fee: | INR 7,000/- (USD 120) payable in 2 installments |
SSIS TRAINING HIGHLIGHTS :
✔ Basic to Adv. ETL | ✔ Lookup, Fuzy Lookup |
✔ SSIS Catalog Database | ✔ ETL Type 1 & Type 2 |
✔ Fast Loads, ETL Tuning | ✔ Errors, SSIS Logs |
✔ Kimball BI Design | ✔ Inmon BI Design |
✔ Star, Snowflake | ✔ Data Warehousing |
✔ ADF Migrations | ✔ Data Lake Storage |
✔ Resume Guidance | ✔ MCSA MSBI Exam |
All Session Are Completely Practical & Real Time
Video 1: SQL SERVER INTRODUCTION
|
Video 5: SQL Basics - 3, T-SQL INTRO
|
Video 9: JOINS, T-SQL QUERIES Level 3
|
Video 2: SQL SERVER INSTALLATIONS
|
Video 6 : CONSTRAINTS,INDEXES Basics
|
Video 10: VIEW, SPs, Function Basics
|
Video 3: SSMS Tool, SQL BASICS - 1
|
Video 7: JOINS, T-SQL Queries - 1
|
Video 11: Triggers & Transactions
|
Video 4: SQL BASICS - 2
|
Video 8: Group By, T-SQL Queries - 2
|
Video 12 : ER MODELS, NORMAL FORMS
|
Real-time Case Study - 1
(Sales & Retail) Objective : Database Design, Table Design and Relations. Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case Study - 2
(Sales & Retail) Objective : Queries, Excel Integration Pivot Tables, Pivot Charts, ODC Connections |
Module I: Basic SSIS Development & ETL - DWH |
Module II: Advanced SSIS Development & Deployments |
Video 1: SSIS INTRODUCTION & INSTALLATION
|
Video 7: CHECKSUM TRANSFORMATION, DWH DESIGN
|
Video 2: SSIS ETL PACKAGES: EXTRACT,TRANSFORM,LOAD
|
Video 8: CHANGE DATA CAPTURE: DWH DIMENSIONS
|
Video 3: MERGE, FUZZY LOOKUP, DATA CONVERSION
|
Video 9: FACT TABLE DESIGN, FACT LOADS (DWH)
|
Video 4: PACKAGE PROPERTIES, CHECKPOINT, PIVOT
|
Video 10: DWH MIGRATIONS with SSIS, SCRIPT Task
|
Video 5: EVENTS, LOOPS, EXPRESSIONS
|
Video 11: SSIS PROJECT DEPLOYMENT, UPGRADES
|
Video 6: DATAWAREHOUSE (DWH) DESIGN WITH SSIS
|
Video 12: SSIS PROJECT [ECommerce Domain]
|
Module I: AZURE DATA FACTORY - 1 |
Module II: AZURE DATA FACTORY - 2 |
HOUR 1: ADF INTRODUCTION
|
HOUR 6 : AZURE DATA FACTORY - 3
|
HOUR 2: AZURE SQL CONFIG, DTU
|
HOUR 7 : AZURE DATA FACTORY - 4
|
HOUR 3: AZURE DATA WAREHOUSE
|
HOUR 8: AZURE DATA FACTORY - 5
|
HOUR 4: AZURE DATA FACTORY - 1
|
HOUR 9: AZURE DATA FACTORY - 6
|
HOUR 5: AZURE DATA FACTORY - 2
|
HOUR 10: AZURE DATA FACTORY - 7
|
> Videos are accessible 24x7. You can opt to access any number of videos each day or same video for multiple days.
> Video Course to be completed within 3 months from the date of registration.
> A Technical Test / Mock Interview is conducted and a Course completion certificate to be issued upon completion of the course.
> Each video is for duration of 80 - 90 minutes, can be paused/replayed for writing running notes and understanding.
> Each video can be accessible multiple times before you proceed with the next video. Any time, any day.
> To ensure secured delivery of our services the participant shall connect to our video cloud in a secured environment.
> Study Material and Practice examples used in every video to be provided on email.
> Software Installation Assistance and access to our 24x7 LIVE Server to be provided for duration of the course.
> Trainers are available for doubts clarifications. On Skype, Email as well as on Call.
This course is helpful for aspiring MSBI Developers, BI Architects, SQL Developers, Database Testers, BI Analysts, DB Architects and .NET Professionals. This course also helps in preparing for Microsoft 70-463 and 70-767 (MSBI Developer) Exams. All training videos are completely practical and realtime. Video wise Material and LIVE Server Access with Lab included in this SSIS Video Course.