Data Engineering — How to Build an ETL Pipeline Using SSIS
What you'll 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
Requirements
- Visual Studio 2019 Installation Required. ( The course shows you how to install it.)
- Microsoft SQL Server Installation Required. ( The course shows you how to install it.)
- SSIS Visual Studio Extension Required. ( The course shows you how to install it.)
Description
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.
Who this course is for:
- Beginner Data Analyst
- Beginner Data Scientist
- Beginners to ETL
Instructor
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.
At Bluelime Learning Solutions, our approach is simple: clear, direct, and engaging. We specialize in 100% video-based courses filled with hands-on examples that provide practical skills applicable in real-world scenarios. Our courses are designed to translate complex concepts into easy-to-understand lessons that anyone, regardless of their background, can grasp and apply.
Our extensive experience includes collaborating on projects with Fortune 500 companies, equipping us with the insights needed to understand the essential skills that today’s employers value most. At Bluelime, we’re not just about teaching; we’re about equipping you with the tools and knowledge to excel in your career and personal growth endeavors.
Join us on this journey to unlock your potential and master new skills in an easy, enjoyable, and efficient way with Bluelime Learning Solutions, where learning is made simple and effective.