Data Loading
SQL Server 2014
| Intermediate
- 10 Videos | 1h 1m 11s
- Includes Assessment
- Earns a Badge
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
-
1.Data Loading4m 58sUP NEXT
-
2.Incremental Data Load Strategy6m 21s
-
3.Full Data Load Strategy5m 27s
-
4.Data Mart5m 29s
-
5.Data Mart: Incremental Updates6m 28s
-
6.Indexed Tables7m 10s
-
7.Bulk Load Options4m 48s
-
8.Load Technique: SSIS Destination4m 32s
-
9.Load Technique: T-SQL4m 39s
-
10.Load Partitioned Tables6m 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.
