Introduces learners to ETL (extract, transform, load) using SQL Server Data Tools. Learners use variables and parameters to write data to tables. Learners ensure that data is not duplicated or deleted when employing tools to load data to tables. Additional topics include scheduling ETL deployments.

Conditions

Prerequisite: 10-152-536 DATABASE DESIGN AND SQL C.