Extracting and Transforming Data in SSIS

[mitsumi]

Extracting and Transforming Data in SSIS
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours 46M | 445 MB
Genre: eLearning | Language: English

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, as well as 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. Whether you are building a Data Warehouse, transforming unstructured/semi-structured files into valuable insights, or loading massive amounts of information for data sciences operations, SSIS is the main SQL Server tool for achieving these ETL (Extract/Transform/Load) goals. In this course, Extracting and Transforming Data in SSIS, you'll learn how to use SSIS to create and execute ETL Packages; use conditional logic and loops to control your data flow; integrate data from sources other than databases; call additional processes, scripts and packages to expand your ETL capabilities beyond SSIS; 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.
     

               

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction