MS 10776A Beta Part2 Virtual Machines Developing SQL Server 2012 視頻教學 英文正式版

　


　
軟體簡介:
　
AboutthisCourse

This5-dayinstructor-ledcourseintroducesSQLServer2012anddescribes
logicaltabledesign,indexingandqueryplans.Italsofocussesonthe
creationofdatabaseobjectsincludingviews,storedprocedures,alongwith
parameters,andfunctions.Othercommonaspectsofprocedurecoding,suchas
transactions,concurrency,errorhandling,triggers,andSQLCLRarealsocovered
inthiscourse.AlsothiscoursehelpsyoupreparefortheExam70-464

Allthelabsforthiscoursecanbeperformedusingtheprovidedvirtualmachines.
However,ifyouhaveaMicrosoftWindowsAzureaccountandtheclassroomvirtualmachines
connecttotheinternetyoumaybeabletoconnecttoyourAzureserveranddatabasefrom
theclassroom.Manyofthelabsinthiscourseareenabledforyoutoperformthelabwhile
connectedtoyourownAzuredatabaseinthecloud.Yourinstructorshouldbeabletoprovide
acurrentlistofAzureenabledlabs.ToacquireatrialWindowsAzureaccountclickhere.

AtCourseCompletion
Aftercompletingthiscourse,studentswillbeableto:
ntroducetheentireSQLServerplatformanditsmajortools.Itwillcovereditions,
versions,basicsofnetworklisteners,andconceptsofservicesandserviceaccounts.

etermineappropriatedatatypestobeusedwhendesigningtables,convertdatabetween
datatypes,andcreatealiasdatatypes.

eawareofgooddesignpracticesregardingSQLServertablesandbeabletocreatetables
usingT-SQL.(Note:partitionedtablesarenotcovered).

mplementPRIMARYKEY,FOREIGNKEY,DEFAULT,CHECKandUNIQUEconstraints,andinvestigate
cascadingFOREIGNKEYconstraints.

etermineappropriatesinglecolumnandcompositeindexesstrategies.

reatetablesasheapsandtableswithclusteredindexes.Alsoconsiderthedesignofa
tableandsuggestanappropriatestructure.

eadandinterpretdetailsofcommonelementsfromexecutionplans.

esigneffectivenon-clusteredindexes.

esignandimplementviews

esignandimplementstoredprocedures.

orkwithtabletypes,tablevaluedparametersandusetheMERGEstatementtocreatestored
proceduresthatupdatedatawarehouses.

esignandimplementfunctions,bothscalarandtable-valued.(Alsodescribewheretheycanleadtoperformanceissues).

erformbasicinvestigationofadeadlocksituationandlearnhowtransactionisolationlevelsaffectapplicationconcurrency.

sebothtraditionalT-SQLerrorhandlingcodeandstructuredexceptionhandling.

esignandimplementDMLtriggers

earnappropriateusesforSQLCLRintegrationandimplementanexisting.NETassemblywithinSQLServer.

toreXMLdataandschemasinSQLServer.

erformbasicqueriesonXMLdatainSQLServer.

orkwiththeGEOGRAPHYandGEOMETRYdatatypes

mplementandqueryafull-textindex