Data Engineering — How to Build an ETL Pipeline Using SSIS

Data Engineering — How to Build an ETL Pipeline Using SSIS, available at $44.99, has an average rating of 4, with 24 lectures, based on 18 reviews, and has 882 subscribers.

You will learn about Create an ETL Pipeline Create an SSIS Package Configure Data source Extract Data Configure Data Destination Transform Data Test and Run SSIS Package to Load Data This course is ideal for individuals who are Beginner Data Analyst or Beginner Data Scientist or Beginners to ETL It is particularly useful for Beginner Data Analyst or Beginner Data Scientist or Beginners to ETL.

Enroll now: Data Engineering — How to Build an ETL Pipeline Using SSIS

Summary

Title: Data Engineering — How to Build an ETL Pipeline Using SSIS

Price: $44.99

Average Rating: 4

Number of Lectures: 24

Number of Published Lectures: 24

Number of Curriculum Items: 24

Number of Published Curriculum Objects: 24

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Create an ETL Pipeline
Create an SSIS Package
Configure Data source
Extract Data
Configure Data Destination
Transform Data
Test and Run SSIS Package to Load Data

Who Should Attend

Beginner Data Analyst
Beginner Data Scientist
Beginners to ETL

Target Audiences

Beginner Data Analyst
Beginner Data Scientist
Beginners to ETL

SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading .

ETL, which stands for extract, transform and load, is a data integration process that combines data from multiple data sources into a single, consistent data store that is loaded into a data warehouse or other target system.

An ETL pipeline is the set of processes used to move data from a source or multiple sources into a database such as a data warehouse or target databases.

SQL Server Integration Service (SSIS) provides an convenient and unified way to read data from different sources (extract), perform aggregations and transformation (transform), and then integrate data (load) for data warehousing and analytics purpose. When you need to process large amount of data (GBs or TBs), SSIS becomes the ideal approach for such workload.

In this course you will learn how to build an ETL pipeline for database migration using SQL Server Integration Services (SSIS) in Visual Studio 2019.

We will create a SSIS package that will extract and transform data from a source database and then load the data into a target destination database.

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: SQL Server Editions

Lecture 4: Download SQL Server

Lecture 5: Install SQL Server

Lecture 6: Install SQL Server Management Studio -SSMS

Lecture 7: Connect SSMS to SQL Server

Lecture 8: Install Sample database

Chapter 2: Visual Studio Setup

Lecture 1: What is Visual Studio

Lecture 2: Please Read

Lecture 3: Install Visual Studio

Lecture 4: Visual studio workloads

Lecture 5: Install Visual Studio Data Tools – SSDT

Lecture 6: Install SSIS Visual Studio Extension

Chapter 3: Building SSIS ETL Pipeline

Lecture 1: What is SSIS

Lecture 2: What is ETL

Lecture 3: What is an ETL Pipeline

Lecture 4: ETL Pipeline Requirements

Lecture 5: Install Source Database

Lecture 6: Create destination database

Lecture 7: Create a new SSIS Project

Lecture 8: Configure data source and data destination

Lecture 9: Data Transformation

Lecture 10: Running SSIS Package

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 10 votes
5 stars: 5 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu