Build ETL Pipelines Using SSIS

About Course

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.

This content is for Lite Plan, Pro Plan, and Ultimate Plan members only.
Login Join Now

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 Content

Introduction

Course Journey

00:00
Course Introduction

01:00
SSIS Architecture

07:00
Database Setup (Source & Target Data)

00:00
SSIS Interface Overview

04:00

Data Flow | Source & Destinations

Data Flow | Transformations

Copy Column

03:00
Data Conversion

05:00
Derived Column

05:00
OLE DB Command

08:00
Aggregator

04:00
Sort

03:00
Conditional Split

03:00
Multicast

03:00
Union All

03:00
Merge

04:00
Merge Join

04:00
Lookup

07:00

Control Flow

Use Cases Implementation

Create Database & Load required data

00:00
Use Cases Requirement

04:00
Use Case 1: Introduction

00:00
Use Case 1: Total Revenue by Month

06:00
Use Case 2: Requirement

00:00
Use Case 2: Top Actors by Movies

09:00
Use Case 3: Requirement

00:00
Use Case 3: Transaction Details per Movie Purchase

09:00
Use Case 4: Requirement

00:00
Use Case 4: Top Grossing Cities

09:00

Student Ratings & Reviews

No Review Yet

About Course

Course Objective

What Will You Learn?

Course Content

Introduction

Course Journey

Course Introduction

SSIS Architecture

Database Setup (Source & Target Data)

SSIS Interface Overview

Data Flow | Source & Destinations

Data Flow Introduction

OLE DB Source

Excel Source

Types of Flat Files

Flat File Source

XML File Source

OLE DB Destination

Excel Destination

Flat File Destination

Data Flow | Transformations

Copy Column

Data Conversion

Derived Column

OLE DB Command

Aggregator

Sort

Conditional Split

Multicast

Union All

Merge

Merge Join

Lookup

Control Flow

Control Flow Introduction

Connection Manager

Execute SQL Task

Preceding Constraints

Containers

Variables

Looping through files

Expressions

Task: Get list of employees

Use Cases Implementation

Create Database & Load required data

Use Cases Requirement

Use Case 1: Introduction

Use Case 1: Total Revenue by Month

Use Case 2: Requirement

Use Case 2: Top Actors by Movies

Use Case 3: Requirement

Use Case 3: Transaction Details per Movie Purchase

Use Case 4: Requirement

Use Case 4: Top Grossing Cities

Student Ratings & Reviews

Resources

Information

Social Media

We Accept