Course curriculum

    1. Course Content

    2. BI Interview Questions and Answers

    3. MSBI Job Marketing Info

    1. What is BI?

    2. What is SSIS?

    3. What is Data Integration?

    4. Why SSIS?

    5. How does SSIS work?

    6. Requirements for SQL Server Integration Services

    7. What is the SSIS Package?

    8. SSIS Tasks

    9. Example of Data Flow Task

    10. Example of Execute SQL Task

    1. Hands On - ETL Solutions

    2. ETL Solutions - 09/26/2022

    1. Built-in Connection Managers

    2. Connection Managers - Flat files

    3. Connection Manager - 10/05/2022

    4. Excel Files

    1. Row Transformation Part 1 - 10/10/2022

    2. Row Transformation Part 2 - 10/17/2022

    3. Script Component Example File

    4. OleDB Command Example File

    5. Row Transformation 3 - 10/24/2022

    1. SSIS Project

    2. OLTP Files

    3. DWH Files

    4. Phase 1 - Source to Stage - 11/07/2022

    5. Phase 2 - Stage to Data-warehouse - 11/21/2022

    6. Phase 3 - Incremental Loading - 01/23/2023

About this course

  • $1,800.00
  • 30 lessons
  • 11.5 hours of video content

Discover your potential, starting today

Enroll today