ETL, extract, transform, and load, is the main process in data warehousing solutions. It facilitates the transfer of the data from a source to a destination. This course discusses the ETL process and how it can be implemented.
Implementing Data Flow
start the course
list data flow components
use data flows
debug data flow
Create SSIS packages and SQL/SSIS data transformations
perform lookup tasks in SSIS
specify a data source and destination
extract, transform, and load data
performance tune SSIS data flow and optimize Integration Services
The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.