This video on SQL Server Integration Services explains
1) What is SQL Server Integration Services (SSIS)?
2) Why use Extract Transform Load (ETL) tools like SSIS?
3) The basic building blocks of an Integration Services package. This includes Connection Managers and transformations such as Merge Joins, Sorts, Data Conversions, Aggregates, Conditional Splits, Union All, Pivots, Unpivots and Multicasts.
The tutorial also demonstrates how these building blocks are linked together in a live SSIS package. Links to various free learning resources are provided.
I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
