PLURALSIGHT LOGICAL AND PHYSICAL MODELING FOR ANALYTICAL APPLICATIONS 視頻教學 英文教學版

　



　
軟體簡介:
　
Abaddatamodelleadstoanapplicationthatdoesnotperformwell.
Therefore,whendevelopinganapplication,youshouldcreateagooddata
modelfromthestart.However,eventhebestlogicalmodelcan’thelpwhen
thephysicalimplementationisbad.ItisalsoimportanttoknowhowSQL
Serverstoresandaccessesdata,andhowtooptimizethedataaccess.Database
optimizationstartsbysplittingtransactionalandanalyticalapplications.
Inthiscourse,youlearnhowtosupportanalyticalapplicationswithlogical
design,getunderstandingoftheproblemswithdataaccessforqueriesthat
dealwithlargeamountsofdata,andlearnaboutSQLServeroptimizationsthat
helpsolvingtheseproblems.