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

只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on October 17, 2013, 01:40:16 PM

Title: SSIS&ETL 第一期 2013-11-16
Post by: USA LaoTu Support Team on October 17, 2013, 01:40:16 PM
 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. (http://student.usalaotu.com/make_payment.php)

Click here: Register course and Webinar use Paypal. (http://student.usalaotu.com/courseschedule.php), click last Buy Now button, enter amount.
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: jenny88 on October 19, 2013, 01:02:40 PM
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
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: USA LaoTu Support Team on October 19, 2013, 02:22:11 PM
This is a new SSIS&ETL class.
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: cctv on October 27, 2013, 07:27:57 PM
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..
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: GoodSQL on October 27, 2013, 07:44:30 PM
can we get some discount if we already the Advanced ETL class?
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: cissy fu on October 29, 2013, 01:25:11 PM
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!

Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: USA LaoTu Support Team on October 29, 2013, 02:09:14 PM
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.
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: USA LaoTu Support Team on November 11, 2013, 12:38:54 AM
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. (http://student.usalaotu.com/make_payment.php)

Click here: Register course and Webinar use Paypal. (http://student.usalaotu.com/courseschedule.php), click last Buy Now button, enter amount.
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: USA LaoTu Support Team on November 14, 2013, 11:03:38 AM
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. (http://student.usalaotu.com/make_payment.php)
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: USA LaoTu Support Team on November 19, 2013, 04:30:11 PM
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.
Title: 我上了第一堂课，发觉授课老师很有艺术：他在短短的几个小时里，把我们比较混沌的理解和思想串在了一起
Post by: USA LaoTu Support Team on November 20, 2013, 09:50:57 AM

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

Frank
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: hollygu on December 12, 2013, 05:35:57 PM
老土老师，

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

谢谢
Title: Re: SSIS&ETL 第一期 2013-11-16
Post by: USA LaoTu Support Team on December 12, 2013, 10:00:01 PM
You can make up the missing class by watch recorded video.

Thanks!