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 managers
describe package level and project level connection manager
define a connection string
describe parameterization of connection strings
define data sources and destinations
distinguish between blocking and non-blocking transformations -
determine when to use custom data sources, destinations, and transformations
describe both trusted and authoritative data sources
use different methods to pull out changed data from data sources
use different methods to pull out changed data from data sources
describe 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.
