MS 10777A Beta part2 Virtual Machines Implementing a Data Warehouse With SQL Server 2012 視頻教學 英文正式版

　


　
軟體簡介:
　
CourseOutline


AboutthisCourse

Datawarehousingisasolutionorganizationsusetocentralizebusinessdata
forreportingandanalysis.Thisfive-dayinstructor-ledcoursefocusesonteaching
individualshowtocreateadatawarehousewithSQLServer2012,implementETLwith
SQLServerIntegrationServices,andvalidateandcleansedatawithSQLServerData
QualityServicesandSQLServerMasterDataServices.Thiscoursehelpspeopleprepare
forexam70-463.


AudienceProfile

ThiscourseisintendedfordatabaseprofessionalswhoneedtofulfillaBusinessIntelligence
Developerrole.Theywillneedtofocusonhands-onworkcreatingBIsolutionsincludingData
Warehouseimplementation,ETL,anddatacleansing.Primaryresponsibilitiesinclude:

mplementingadatawarehouse.

evelopingSQLServerIntegrationServices(SSIS)packagesfordataextraction,transformation,
andloading(ETL).

nforcingdataintegritybyusingMasterDataServices.

leansingdatabyusingDataQualityServices.

AtCourseCompletion

Aftercompletingthiscourse,studentswillbeableto:

escribedatawarehouseconceptsandarchitectureconsiderations.

electanappropriatehardwareplatformforadatawarehouse.

esignandimplementadatawarehouse.

mplementDataFlowinanSSISPackage.

mplementControlFlowinanSSISPackage.

ebugandTroubleshootSSISpackages.

mplementanSSISsolutionthatsupportsincrementaldatawarehouseloadsandchangingdata.

ntegrateclouddataintoadatawarehouseecosysteminfrastructure.

mplementdatacleansingbyusingMicrosoftDataQualityServices.

mplementMasterDataServicestoenforcedataintegrity.

xtendSSISwithcustomscriptsandcomponents.

eployandConfigureSSISpackages.

escribehowinformationworkerscanconsumedatafromthedatawarehouse.