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

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

Control Flow

Use Cases Implementation

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