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
3
SSIS Architecture
Understand the core components of SSIS
4
Install the Environment
Install and Configure all components of the SSIS environment.
5
Database Setup (Source & Target Data)
6
SSIS Interface Overview
Overview of the SSIS Package Designer interface, and its most used interfaces.
Data Flow | Source & Destinations
1
Data Flow Introduction
2
OLE DB Source
3
Excel Source
4
Types of Flat Files
5
Flat File Source
6
XML File Source
7
OLE DB Destination
8
Excel Destination
9
Flat File Destination
Data Flow | Transformations
1
Copy Column
2
Data Conversion
3
Derived Column
4
OLE DB Command
5
Aggregate
6
Sort
7
Conditional Split
8
Multicast
9
UnionAll
10
Merge
11
Merge Join
12
Lookup
Control Flow
1
Control Flow Introduction
2
Connection Manager
3
Execute SQL Task
4
Preceding Constraints
5
Containers
6
Variables
7
Looping through files
8
Expressions
9
Private: Task: Get list of employees
Use Cases Implementation
1
Create Database & Load required data
2
Use Cases Requirement
3
Use Case 1: Introduction
4
Use Case 1: Total Revenue by Month
5
Use Case 2: Requirement
6
Use Case 2: Top Actors by Movies
7
Use Case 3: Requirement
8
Use Case 3: Transaction Details per Movie Purchase
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