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.
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.
SSIS is the main SQL Server tool for achieving ETL (Extract, Transform, and Load) goals, whether you are:
Author Name: Emilio Melo
Author Description:
Emilio Melo is a globetrotting IT professional with projects in over 15 countries, mostly focused on Microsoft software. After 15 years of On Premises experience in Infrastructure, Data and Collaboration, he became fascinated by Cloud technologies and the incredible transformation potential it brings.
Table of Contents
- Course Overview
1min - Understanding the SSIS Interface
17mins - Building Your First SSIS Package
17mins - Defining Common Control Flow Operations
35mins - Integrating Advanced Control Flow Operations
30mins - Transforming Data with Data Flow Operations
45mins - Piping Data with Data Flow Operations
19mins
User Reviews
Be the first to review “Extracting and Transforming Data in SSIS”
Related Products
Use Apache Spark in Azure Databricks
Azure Databricks is built on Apache Spark and enables data engineers and analysts to run Spark jobs to transform, analyze and visualize data at scale.
Transform data with Spark in Azure Synapse Analytics
Data engineers commonly need to transform large volumes of data. Apache Spark pools in Azure Synapse Analytics provide a distributed processing platform that they can use to accomplish this goal.
Data Ingestion with Kafka and Kafka Streaming
Learn how to build real-time data ingestion pipelines using Apache Kafka.
Load data into a relational data warehouse
A core responsibility for a data engineer is to implement a data ingestion solution that loads new data into a relational data warehouse.
Use Azure Synapse serverless SQL pools to transform data in a data lake
By using a serverless SQL pool in Azure Synapse Analytics, you can use the ubiquitous SQL language to transform data in files in a data lake.
Introduction to data engineering on Azure
Microsoft Azure provides a comprehensive platform for data engineering; but what is data engineering? Complete this module to find out.
There are no reviews yet.