视频:
[ Invalid YouTube link ]
USA LaoTu MSBI 2012 Part 1 SSIS ETL 课 坐家妈妈这样通过做项目 一步一步走出家 :
MSBI2012 Part 1 SSIS ETL
CLASS 1st 4 hour
ETL Working Environment
SSIS lab 1-4 Demo
Data Modeling Project 1/5
CLASS 2nd 4 hour:
SSIS lab 4-6 Demo
Flat file Load—varying column width
Data Modeling Project 2/5
CLASS 3rd 4 hour:
Data warehouse: Dimension table ETL
Truncate and delete in ETL
How to apply Surrogate Key in Data Warehouse
Data warehouse: Unique Constrain, migration from DEV to PRO
Data Modeling Project 3/5
CLASS 4th 4 hour:
Data warehouse: Fact table ETL
Data warehouse: Audit table creation and ETL
Incremental Loading
Data Modeling Project 4/5
CLASS 5th 4 hour:
Master Package Design---XML method
How to parse XML data
Data warehouse: Unique Constrain, migration from DEV to PRO
How to deploy SSIS package to Production---Environment Variable Method
Maintaining Production Server—process of fixing production issues
Data Modeling Project 5/5
CLASS 6th 4 hour:
More real work projects.