Pluralsight com Developing and Deploying SQL Server ISV Applications 視頻教學 英文教學版

 



 
軟體簡介:
 
LearnhowtoproperlymakeuseofSQLServerinyour
applications,avoidingcommondesign,security,coding,
performance,andinstallationproblems,applicablefor
developerscreatingapplicationsthatuseSQLServer2005onward.

Therearemanyimportantconsiderationswhencreatingand
deployinganapplicationthatusesSQLServerfordatastorage,
whetheryouworkforalargeorsmallISV,andarecreatinga
complexorsimpleapplication.It'scriticalthatyour
applicationperformswellunderload,keepstheuserdata
secure,andisabletobeinstalledandupgradedeasily.This
courseexplainsalltheseconsiderationsusingalayered
approachthattiesintostagesinthedevelopmentlifecycle.The
coursebeginsbyexaminingdatabasedesignandschema
considerations,plusgeneralbestpracticesaroundsecurity
usingroles,logins,andusers.Itthenexplainsand
demonstratesnumerousaspectsofT-SQLcodingwherechoicescan
bemadetomakethecodeandapplicationmoreefficient,and
avoidcommonperformancepitfalls.Applicationandcodetesting
isthenaddressed,alongwithfiguringoutthehardware,
software,andSQLServerrequirementsthatmustbecommunicated
totheusers.Thecourseendsbywalkingthroughthedeployment
phase,includingcommonSQLServeranddatabaseconfiguration
optionsthatmustbechangedorleftasthedefaultvalue,and
explaininghowtoensurethatapplicationanddatabaseupgrades
runsmoothly.Thiscourseisperfectfordeveloperswhoare
involvedinthedevelopmentlifecycleofapplicationsthatuse
SQLServerfordatastorage.Theinformationinthecourse
appliestoallversionsfromSQLServer2005onward.