Data Loading

SQL Server 2014
  • 10 Videos | 1h 1m 11s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
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

  • Playable
    1. 
    Data Loading
    4m 58s
    UP NEXT
  • Playable
    2. 
    Incremental Data Load Strategy
    6m 21s
  • Locked
    3. 
    Full Data Load Strategy
    5m 27s
  • Locked
    4. 
    Data Mart
    5m 29s
  • Locked
    5. 
    Data Mart: Incremental Updates
    6m 28s
  • Locked
    6. 
    Indexed Tables
    7m 10s
  • Locked
    7. 
    Bulk Load Options
    4m 48s
  • Locked
    8. 
    Load Technique: SSIS Destination
    4m 32s
  • Locked
    9. 
    Load Technique: T-SQL
    4m 39s
  • Locked
    10. 
    Load Partitioned Tables
    6m 19s

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.

YOU MIGHT ALSO LIKE

Likes 0 Likes 0  
Likes 11 Likes 11  
Likes 20 Likes 20  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 22 Likes 22  
COURSE T-SQL Queries
Likes 112 Likes 112  
Likes 26 Likes 26