Extracting and Transforming Data in SSIS

via Pluralsight

Overview

SSIS is an ETL (Extract, Transform, and Load) tool from Microsoft. In this course, you'll learn how to install and configure SSIS, and develop ETL packages with it.

Data engineering is the backbone of advanced analytics, business intelligence, and machine learning activities. It is one of the most exciting and rewarding professions in the IT industry today. Whether building a data warehouse, transforming unstructured or semi-structured files into valuable insights, or loading massive amounts of information for data science operations, SSIS serves as the primary SQL Server tool for ETL 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.

University: Provider: Pluralsight

Categories: Machine Learning Courses, Business Intelligence Courses, SQL Courses, Windows Server Courses