Connection Managers & Data Sources

SQL Server 2014    |    Intermediate
  • 11 videos | 1h 9m 11s
  • Includes Assessment
  • Earns a Badge
Rating 3.8 of 6 users Rating 3.8 of 6 users (6)
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

  • 7m 33s
    Find out how to plan the configuration of connection managers. FREE ACCESS
  • 4m 40s
    After completing this video, you will be able to describe package-level and project-level connection managers. FREE ACCESS
  • Locked
    3.  Connection Strings
    7m 6s
    In this video, you will learn how to define a connection string. FREE ACCESS
  • Locked
    4.  Parameterization
    5m 43s
    Upon completion of this video, you will be able to describe how to parameterize connection strings. FREE ACCESS
  • Locked
    5.  Data Sources and Destinations
    6m 3s
    Find out how to define data sources and destinations. FREE ACCESS
  • Locked
    6.  Transformations
    6m 13s
    In this video, learn how to distinguish between blocking and non-blocking transformations. FREE ACCESS
  • Locked
    7.  Custom Data Sources
    3m 23s
    In this video, find out how to determine when to use custom data sources, destinations, and transformations. FREE ACCESS
  • Locked
    8.  Trusted and Authoritative Data Sources
    4m 12s
    After completing this video, you will be able to describe both trusted and authoritative data sources. FREE ACCESS
  • Locked
    9.  Change Data Capture - Part 1
    7m 38s
    In this video, you will use different methods to extract changed data from data sources. FREE ACCESS
  • Locked
    10.  Change Data Capture - Part 2
    11m 3s
    During this video, you will learn how to use different methods to extract changed data from data sources. FREE ACCESS
  • Locked
    11.  Data Flow Components
    5m 39s
    After completing this video, you will be able to describe data flow components. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Journey Data Analytics Specialist
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Networking & Building Relationships
Rating 4.5 of 2 users Rating 4.5 of 2 users (2)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course DDL, DML, & Constraints
Rating 4.6 of 100 users Rating 4.6 of 100 users (100)
Course Data Transformation & Flow
Rating 5.0 of 5 users Rating 5.0 of 5 users (5)
Course Data Quality Services (DQS) & Master Data Services (MDS)
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)