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.