Descrizione

In this course you will learn how to perform an ETL (Extract Transformation and Loading) pipeline on the data through Microsoft SQL Server Suite. The course will provide all information about the main components and the best practices related to the use of Integration Services (SSIS) focusing on the world of BI (Business Intelligence).

Target

Data Engineer, Data Analyst, Data Scientist

Prerequisiti

General knowledge of SQL-Server and T-SQL

Programma Corso

Modulo 1:

SQL server integration services overview:

• Create a SSIS Solution and Project
• Solution SSIS overview

SSIS Fundamentals:

• Project/Package environment
• Create a SSIS Package
• Data sources available

Data flow task and transformation overview:

• Data flow Task
• Transformation Task

Data extraction:

• How to load a SQL table with SSIS
• How to load a txt or Csv file with ssis
• Data source/Data Destination
• Transformation
• Tutorials

Implement a control flow:

• Containers
• Control Flow
• Loop Container (Foreach e For-Loop container)

Modulo 2:

Integration services for datawarehousing:

• Creation and loading of Staging area
• Staging structures creation
• DWH area creation
• Tutorials

SSIS project/package deployments:

• Deploy a SSIS solution and SSIS package
• SSIS Catalog
• Run a SSIS package with SQL Server Agent
• Creation of a SQL agent job