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
Create a lake database in Azure Synapse Analytics
Why choose between working with files in a data lake or a relational database schema? With lake databases in Azure Synapse Analytics, you can combine the benefits of both.
Designing Data Systems
Master the principles of designing data systems that handle large-scale data efficiently.
Automate Data Pipelines
Learn techniques for automating data pipelines for faster data processing.
Use Azure Synapse serverless SQL pool to query files in a data lake
With Azure Synapse serverless SQL pool, you can leverage your SQL skills to explore and analyze data in files, without the need to load the data into a relational database.
Use Spark Notebooks in an Azure Synapse Pipeline
Apache Spark provides data engineers with a scalable, distributed data processing platform, which can be integrated into an Azure Synapse Analytics pipeline.
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.
There are no reviews yet.