Extracting and Transforming Data in SSIS

SSIS is the main on-premises ETL (Extract, Transform, and Load) tool from Microsoft, and it's heavily utilized for data engineering on SQL Server. In this course, you'll learn how to install and configure SSIS, and develop ETL packages with it.
Course info
Rating
(28)
Level
Intermediate
Updated
Sep 17, 2019
Duration
2h 45m
Table of contents
Course Overview
Understanding the SSIS Interface
Building Your First SSIS Package
Defining Common Control Flow Operations
Integrating Advanced Control Flow Operations
Transforming Data with Data Flow Operations
Piping Data with Data Flow Operations
Description
Course info
Rating
(28)
Level
Intermediate
Updated
Sep 17, 2019
Duration
2h 45m
Description

Data engineering is in the backbone of advanced analytics, business intelligence, and machine learning activities, and is also one of the most exciting and rewarding professions in the IT industry today. Whether you are building a data warehouse, transforming unstructured or semi-structured files into valuable insights, or loading massive amounts of information for data sciences operations, SSIS is the main SQL Server tool for achieving ETL (Extract, Transform, and Load) goals. In this course, Extracting and Transforming Data in SSIS, you’ll learn how to use SSIS to create and execute ETL Packages. First, you'll discover how to use conditional logic and loops to control your data flow. Next, you'll delve into integrating data from sources other than databases. Then, you'll explore additional processes, scripts, and packages to expand your ETL capabilities beyond SSIS. Finally, you'll learn how to transform data using Data Flow operations, and pipe data by Split, Merge, and Union operations. By the end of this course, you'll be able to use SSIS to execute fundamental ETL processes.

About the author
About the author

With over 20 years of experience on Microsoft infrastructure, data and collaboration software, Emilio Melo has a newly found passion and enthusiasm for the incredible potential of the cloud.

More from the author
More courses by Emilio Melo
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Emilio Melo, and welcome to my course, Extracting and Transforming Data in SSIS. I am a cloud solutions architect at Cloud Advantage with focus on data and AI technologies. Data engineering is in the backbone of analytics, machine learning, and business intelligence processes, and SSIS is the main Microsoft on-premises tool for such tasks. In this course, we're going to cover how to utilize SSIS for ETL extractions from load operations. Some of the major topics that we're going to cover include how to install and configure the development environment for SSIS, how to design debug and execute packages, how to manage SSIS execution with the control flow, and how to transform and route data with the data flow operations. By the end of this course, you'll know how to create your own ETL packages with SSIS. Before beginning this course, you should have some basic familiarity with relational databases and SQL scripting. From here, you should feel comfortable diving into other BI topics, such as data warehousing or reporting. I hope you'll join me on this journey to learn SSIS with Extracting and Transforming data in SSIS course at Pluralsight.