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.