ETL Using SSIS

Course Objective

Applying ETL Concepts is one of the major skills for any data integration developer or any data engineer in general, and also it is not about the tool, it is about applying the ETL concepts and DWH concepts with an understanding of the best practices and how about how to build your own project from scratch so you get understanding of the full cycle of ETL and data integration.

What you will learn

  • Understand ETL Concepts
  • Understand SSIS Architecture
  • Install and Setup SSIS 
  • Understand and apply Data flow tasks
  • Understand and apply Control flow tasks
  • Apply your knowledge on common ETL Use cases
  • Build Data Warehouse Dimensions and Facts
  • Learn the best practices for SSIS and ETL Development
  • SSIS Interview Questions

Course Prerequisites

  • Familiarity with SQL (Optional)
  • Familiarity with DWH

Who should enroll in the course?

  • Data Engineers
  • ETL and Data Integration Developers
  • Anyone from any background who wants to know about ETL and SSIS

 

Introduction

1
Course Journey
2
Course Introduction
1 Minute
3
SSIS Architecture
7 Minutes

Understand the core components of SSIS

4
Install the Environment
12 minutes

Install and Configure all components of the SSIS environment.

5
Database Setup (Source & Target Data)
10 minutes
6
SSIS Interface Overview
4 Minutes

Overview of the SSIS Package Designer interface, and its most used interfaces.

Data Flow | Source & Destinations

1
Data Flow Introduction
3 Minutes
2
OLE DB Source
4 Minutes
3
Excel Source
3 Minutes
4
Types of Flat Files
5 Minutes
5
Flat File Source
3 Minutes
6
XML File Source
3 Minutes
7
OLE DB Destination
4 Minutes
8
Excel Destination
5 Minutes
9
Flat File Destination
4 Minutes

Data Flow | Transformations

1
Copy Column
3 Minutes
2
Data Conversion
5 Minutes
3
Derived Column
5 Minutes
4
OLE DB Command
5 Minutes
5
Aggregate
4 Minutes
6
Sort
3 Minutes
7
Conditional Split
5 Minutes
8
Multicast
3 Minutes
9
UnionAll
3 Minutes
10
Merge
4 Minutes
11
Merge Join
4 Minutes
12
Lookup
7 Minutes

Control Flow

1
Control Flow Introduction
3 Minutes
2
Connection Manager
5 Minutes
3
Execute SQL Task
4 Minutes
4
Preceding Constraints
5 Minutes
5
Containers
6 Minutes
6
Variables
9 Minutes
7
Looping through files
8 Minutes
8
Expressions
12 Minutes
9
Private: Task: Get list of employees
12 Minutes

Use Cases Implementation

1
Create Database & Load required data
10 Minutes
2
Use Cases Requirement
4 Minutes
3
Use Case 1: Introduction
4
Use Case 1: Total Revenue by Month
6 Minutes
5
Use Case 2: Requirement
6
Use Case 2: Top Actors by Movies
9 Minutes
7
Use Case 3: Requirement
8
Use Case 3: Transaction Details per Movie Purchase
9 Minutes
9
Use Case 4: Requirement
10
Use Case 4: Top Grossing Cities
Data Engineers, ETL Developers, and Data Integration Developers
By end of this course, you will be familiar and confident applying ETL and DWH concepts using SSIS
You have to finish the course To review it
Add to Wishlist
Enrolled: 72 students
Duration: 3 Hours
Lectures: 46
Video: 2.5 Hours