USA LaoTu 高薪转行做数据第一平台

只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司! => 坚定正确的转行方向 高薪捷径 视频试看 => Topic started by: USA LaoTu Support Team on March 17, 2014, 12:31:46 AM

Title: Content of MSBI 2012 Part 1 SSIS ETL
Post by: USA LaoTu Support Team on March 17, 2014, 12:31:46 AM
视频:
[ 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.