Data Loading

SQL Server 2014    |    Intermediate
  • 10 videos | 56m 11s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 15 users Rating 4.8 of 15 users (15)
SQL Server Integration Services (SSIS) is an extensible platform for creating data integration and workflow solutions. Explore various options available for loading data, including incremental, full, and bulk load.

WHAT YOU WILL LEARN

  • Describe data loading
    Perform an incremental data load strategy
    Perform a full data load strategy
    Describe data mart
    Plan for an incremental update of the relational data mart
  • Plan for loads into indexed tables
    Configure bulk load options
    Select an appropriate load technique (ssis destination)
    Select an appropriate load technique (t-sql)
    Select appropriate load partitioned tables

IN THIS COURSE

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

Channel Database Business Intelligence
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Interskill CA Technologies
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Data Loading & Visualization in Power BI: Loading Data from Databases
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SSIS Components
Rating 4.5 of 28 users Rating 4.5 of 28 users (28)
Course Data Warehousing & Business Intelligence Implementation
Rating 4.5 of 67 users Rating 4.5 of 67 users (67)
Course Connection Managers & Data Sources
Rating 3.8 of 6 users Rating 3.8 of 6 users (6)