Content of SSIS & ETL course

[USA LaoTu Support Team]

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.

Click here: Register course  use Paypal., click last Buy Now button, enter amount.