SSIS&ETL 第一期 2013-11-16

[USA LaoTu Support Team]

 SSIS&ETL 第一期 Nov. 16
SSIS&ETL  第一期

Start on Nov. 16 , Saturday 8:00am to 12:00 noon USA PST.

Will be 4 hours each class session, total 20 hours.

SSIS&ETL Term 1            $1199    for general public
                                      $899      for student paid $2999
                                      $499      for student paid $4298 and up
 
把原有的广受欢迎的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
                                      $899      for student paid $2999
                                      $499      for student paid $4298 and up

Click here: Register course and Webinar use Credit Card.

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

[jenny88]

Is this class a section one of MS BI class? or it's just section one of SSIS&ETL class. Kind of confused. Please explain. Thanks!
Jenny Yuan

[USA LaoTu Support Team]

This is a new SSIS&ETL class.

[cctv]

Laotu Laishi,

I already took the core package but  not take MSBI yet, so what I should take first: MSBI or  SSIS&ETL, got confused..

[GoodSQL]

can we get some discount if we already the Advanced ETL class?

[cissy fu]

Laotu Laishi,

I have the same concern about MSBI and SSIS&ETL. It sounds like SSIE&ETL is a advanced course, compared to the MSBI. Am I right?

Thank you!

[USA LaoTu Support Team]

New SSIS&ETL course will cover SSIS part of previous MSBI course, and add more stuff. Yes, it is a class from basic to high level.
Yes, previous students will get discount.
Will publish price information later.

[USA LaoTu Support Team]

SSIS&ETL 第一期 Nov. 16
SSIS&ETL  第一期

Start on Nov. 16 , Saturday 8:00am to 12:00 noon USA PST.

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/11/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
                                      $699      for Core Package and MSBI student

Click here: Register course and Webinar use Credit Card.

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

[USA LaoTu Support Team]

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

Click here: Register course and Webinar use Credit Card.

[USA LaoTu Support Team]

Student of SSIS ETL class: a new class board "SSIS & ETL" has created for you.
Our SSIS class teacher will be in there answer your questions.
Please publish your SSIS questions in that board.

[USA LaoTu Support Team]

我上了第一堂课，发觉授课老师很有艺术：他在短短的几个小时里，把我们比较混沌的理解和思想串在了一起，比我自己看书，下载视频效率提高十倍。说起来，能够到美国的都是会读书的好手，但是，还是但是--------现代社会讲究的是效率，要快！
希望老土老师把我的管窥之见，供大家参考！

Frank

[hollygu]

老土老师，

错过了这一期，请问下一期什么时候开？

谢谢

[USA LaoTu Support Team]

You can make up the missing class by watch recorded video.

Thanks!