USA LaoTu 美国老土 MSBI 2012 Part 1 Class preview скачать в хорошем качестве

USA LaoTu 美国老土 MSBI 2012 Part 1 Class preview

USA LaoTu 美国老土 MSBI 2012 Part I: SSIS&ETL 把原有的广受欢迎的MSBI 课的内容进一步扩展，充实，把 SSIS&ETL 单独开课，从基础到实战， 加进工业界的实际项目和二十年SSIS Consultant 的经验精华。成为找工作， 赢MSBI工作的利器。 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.