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

　


　
軟體簡介:
　
AboutthisCourse

This5-dayinstructorledcourseprovidesstudentswiththetechnicalskills
requiredtowritebasicTransact-SQLqueriesforMicrosoftSQLServer2012.
ThiscourseisthefoundationforallSQLServer-relateddisciplines;namely,
DatabaseAdministration,DatabaseDevelopmentandBusinessIntelligence.
Thiscoursehelpspeopleprepareforexam70-461.Allthelabsforthiscourse
canbeperformedusingtheprovidedvirtualmachines.However,ifyouhave
aMicrosoftWindowsAzureaccountandtheclassroomvirtualmachinesconnect
totheinternetyoumaybeabletoconnecttoyourWindowsAzureserverand
databasefromtheclassroom.Manyofthelabsinthiscourseareenabledfor
youtoperformthelabwhileconnectedtoyourownWindowsAzuredatabaseinthe
cloud.YourinstructorshouldbeabletoprovideacurrentlistofWindowsAzure
enabledlabs.ToacquireatrialWindowsAzureaccount

AudienceProfileThiscourseisintendedforDatabaseAdministrators,DatabaseDevelopers,
andBusinessIntelligenceprofessionals.ThecoursewillverylikelybewellattendedbySQL
poweruserswhoarennecessarilydatabase-focusedorplanontakingtheexam;namely,repor
writers,businessanalystsandclientapplicationdevelopers.

AtCourseCompletion

Aftercompletingthiscourse,studentswillbeableto:

riteSELECTqueries
uerymultipletables
sebuilt-infunctions
sesubqueries
xecutestoredprocedures
sesetoperators
mplementerrorhandling
mplementtransactions
setableexpressions
ortandfilterdata
sewindowranking,offsetandaggregatefunctions
uerySQLServermetadata
rogramwithT-SQL
mprovequeryperformance