Data Flow Implementation & ETL
SQL Server 2014
| Intermediate
- 8 Videos | 1h 2m 8s
- Includes Assessment
- Earns a Badge
Extract, transform, load (ETL), is the main process in data warehousing solutions and helps transfer data from one source to another. During this course you will examine the ETL process and how it can be implemented. You will start by examining data flows and how to debug them. Next, you will learn how to use SQL Server Integration Services (SSIS), and perform a broad range of data migration tasks. These include how to create SSIS packages, transform data, and perform lookup tasks. Next you will employ ETL, the SSIS data warehousing tool, to facilitate the transfer of data from a source to a destination. Discover how to implement the ETL process, to extract, transform, and load data. Specify a data source and a destination. Finally, you will performance tune SSIS data flow and optimize data Integration Services.
WHAT YOU WILL LEARN
-
list data flow componentsuse data flowsdebug data flowCreate SSIS packages and SQL/SSIS data transformations
-
perform lookup tasks in SSISspecify a data source and destinationextract, transform, and load dataperformance tune SSIS data flow and optimize Integration Services
IN THIS COURSE
-
1.Data Flow Components7m 4sUP NEXT
-
2.Using Data Flows7m 47s
-
3.Debugging Data Flow7m 21s
-
4.SQL/SSIS Transformations and Packages8m 1s
-
5.SSIS Lookups7m 43s
-
6.Data Sources and Destinations7m 37s
-
7.Extracting, Transforming, and Loading Data9m 2s
-
8.Performance Tuning, Optimization, and Integrity7m 34s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.