MSBI 2012 Part I: SSIS&ETL 02/25/2014 to 03/13/2014

[USA LaoTu Support Team]

MSBI 2012  Part I:  SSIS&ETL   Start 19:00 to 21:00 USA PST, Tuesday Feb 25:

把原有的广受欢迎的MSBI 课的内容进一步扩展，充实，把 SSIS&ETL 单独开课，从基础到实战， 加进工业界的实际项目和二十年SSIS Consultant 的经验精华。成为找工作， 赢MSBI工作的利器。

Will be five 4 hour sessions, total 20 hours:
 
Mr. Wei will teach 18 hours.
Dr. Vivian will teach 2 hours.

Feb 25 (Tue）， 2H,  19:00 to 21:00 USA PST
Feb 27（Thu),  2H,   19:00 to 21:00 USA PST
Mar 1 (Sat), 4H,      08:00 to 12:00 USA PST
March 4(Tue）, 2H    19:00 to 21:00 USA PST
March 6(Thu) , 2H   19:00 to 21:00 USA PST
March 8 (Sat),4H     08:00 to 12:00 USA PST
March 11(Tue), 2H   19:00 to 21:00 USA PST
March 13(Thu), 2H   19:00 to 21:00 USA PST
 
CLASS 1st 4 hour
    ETL Working Environment
    Original SSIS lab 1-4 Demo
    Data Modeling Project 1/5

CLASS 2nd  4 hour:

          Original 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 last 2 hour:
      Bio Ph.D, current BI expert Di. Vivian  will talk real SSIS experience.

SSIS&ETL                       $1199    for general public
                                      $999      for MSBI 2008 student
                                      $899      for Core Package 2013 student
                                      $699      for Core Package 2013 and MSBI 2008 student
                                      $100      for previous SSIS ETL student join online live class listen only.

Click here: Register course and Webinar use Credit Card.

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

[DBV]

老师，这个为什么是PartI? PartI以后还会有PartII等吗?如果来不及赶2月底的课程，MSBI Live Class什么时候再开？

谢谢！

[USA LaoTu Support Team]

Yes, Part 2 will cover SSAS and SSRS.
Better join this class.
Next same class will open after three month.

[DBV]

This MSBI 2012, add more stuff than previous MSBI (2008).
Yes, MSBI 2012 Part 2 covers SSAS and SSRS, it will be charged separately.

Yes, Part 2 will cover SSAS and SSRS.
Better join this class.
Next same class will open after three month.

好谢谢。我再想问一下，这个跟老土老师网站里列的那个$1299 (for core package student) MSBI 课程有什么不一样呢？
PartII (SSRS)还要单收费是吗？

[zhangxun20070810]

报这课的能access哪些以前相关课的 class material /video? Thanks

[DBV]

我现在的电脑装了SQL Server，用VM分了100G，请问如果学BI，还需要新硬盘/电脑吗？谢谢！

[USA LaoTu Support Team]

The first 8 hour of this class cover old MSBI SSIS chapter 1 to chapter 7 material.
You will access previous SSIS ETL Term 1 class video.
 

报这课的能access哪些以前相关课的 class material /video? Thanks

[USA LaoTu Support Team]

You will be OK.

我现在的电脑装了SQL Server，用VM分了100G，请问如果学BI，还需要新硬盘/电脑吗？谢谢！

[USA LaoTu Support Team]

MSBI 2012 is A different class with old MSBI 2008 CLASS.
Student registered SSIS ETL (MSBI 2012 part 1) will get access of previous SSIS ETL class material and video immediately for review.
They will not get MSBI 2008 class video. The old SSIS  content OF MSBI 2008 COURSE and chapter is covered in SSIS ETL class video.

[zhangxun20070810]

Which developing tool are we using in BI class VS2008,  VS2012 or the special one for BI?

[USA LaoTu Support Team]

We will use the same edition as we used on SQL Server 2012 class.

[zhangxun20070810]

We will use the same edition as we used on SQL Server 2012 class.

But which Visual Studio version are we using in  coming BI class?

[乐乐]

Visual Studio comes with SQL Server 2012

[zhangxun20070810]

Get it. Thanks.

[Kathy]

那MSBI partII 什么时候开？