Connection Managers & Data Sources
SQL Server 2014
| Intermediate
- 11 Videos | 1h 9m 11s
- Includes Assessment
- Earns a Badge
Connection managers in a data warehouse are used to define the data source connections. Discover how to use connection managers to specify source and destinations, as well as how to create custom data sources.
WHAT YOU WILL LEARN
-
plan the configuration of connection managersdescribe package level and project level connection managerdefine a connection stringdescribe parameterization of connection stringsdefine data sources and destinationsdistinguish between blocking and non-blocking transformations
-
determine when to use custom data sources, destinations, and transformationsdescribe both trusted and authoritative data sourcesuse different methods to pull out changed data from data sourcesuse different methods to pull out changed data from data sourcesdescribe data flow components
IN THIS COURSE
-
1.Configuring Connection Managers7m 33sUP NEXT
-
2.Connection Manager Levels4m 40s
-
3.Connection Strings7m 6s
-
4.Parameterization5m 43s
-
5.Data Sources and Destinations6m 3s
-
6.Transformations6m 13s
-
7.Custom Data Sources3m 23s
-
8.Trusted and Authoritative Data Sources4m 12s
-
9.Change Data Capture - Part 17m 38s
-
10.Change Data Capture - Part 211m 3s
-
11.Data Flow Components5m 39s
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.