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
Related Courses
Arabic
Pandas is one of the most important libraries in data engineering and data science with its powerful features and capabilities, you can see that al...
Add to Wishlist
Free
Featured
English
Data Warehouse Modeling and Design Course Introduction Data Warehouse is a critical component in any organization today, as the center and a core c...
Add to Wishlist
Free