3.5.0 Overview

Module 2 introduces data integration tasks using ETL methodology and topics that include data flow tasks, data automation, data connectivity and use of variables. 1:39 minutes

• Module 2: Overview Video

Target Competencies

• Assemble advanced queries using SQL
• Evaluate optimization techniques for data models
• Construct an ETL (extract, transform and load) to a data infrastructure

Learning Objectives

• Create logical joins to query data
• Develop queries to populate data models
• Explain quiried data results
• Write queries fo optimal performance
• Demonstrate best practices in query structure
• Identify errors and required components of a query
• Diagram an ETL process
• Create a basic data flow following the ETL process
• Create and ETL process that executes syntax
• Incorporate variables into an ETL process
• Create an ETL process using a divers set of tasks