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

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

Title: Content of SSIS & ETL course
Post by: USA LaoTu Support Team on December 01, 2013, 06:26:54 PM
SSIS&ETL

Will be 4 hours each class session, total 20 hours.
 
把原有的广受欢迎的MSBI 课的内容进一步扩展,充实,把 SSIS&ETL 单独开课,从基础到实战, 加进新内容,成为找工作, 赢BI工作的利器。
 
CLASS 1 (11/16/13) 8:00 to 12:00  USA PST

    ETL Working Environment
    Original SSIS lab 1-4 Demo
    Data Modeling Project 1/5

CLASS 2 (11/23/13) 8:00 to 12:00  USA PST

          Original SSIS lab 4-6 Demo
          Flat file Load—varying column width
           Data Modeling Project 2/5

CLASS 3 (12/7/13)  8:00 to 12:00  USA PST

        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 4 (12/21/13) 8:00 to 12:00  USA PST

      Data warehouse: Fact table ETL
      Data warehouse: Audit table creation and ETL
      Incremental Loading
      Data Modeling Project 4/5

CLASS 5 (1/4/14) 8:00 to 12:00  USA PST

      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

SSIS&ETL Term 1            $1199    for general public
                                      $999      for MSBI student
                                      $899      for Core Package student
                                      $599      for Core Package and MSBI student

Click here: Register course  use Credit Card. (http://student.usalaotu.com/make_payment.php)

Click here: Register course  use Paypal. (http://student.usalaotu.com/courseschedule.php), click last Buy Now button, enter amount.