PLURALSIGHT NET SQL SERVER TRANSACT SQL BASIC DATA MODIFICATION 視頻教學 英文正式版

　


　
軟體簡介:
　
IfyouneedtomodifydatainaSQLServerdatabase,thenyouneedtoknowhowtousetheINSERT,
UPDATEandDELETEstatements.Thiscoursestartsbyexplaininghowtofindinformationaboutthe
tablesandcolumnsyouwanttomodify.ItthenexplainstheINSERT,UPDATE,andDELETEstatements
indetailalongwithvariousmethodsforlimitingthedatabeingmodified.Finallyitmovesbeyond
thebasicmodificationstatementstomoreadvancedtopicsliketheMERGEstatement,errorhandling
andmore.Morethenthirtyfivedemoshelptogiveyouathoroughunderstandingofhowtoperform
theseessentialoperations,allusingafreely-availabledemoenvironmentthatyou'reshownhowto
setupandconfigure.ThiscourseisperfectfordeveloperswhoneedtomodifydatainSQLServer
databases,fromcompletebeginnersthroughtomoreexperienceddeveloperswhocanusesomeofthe
modulesasreferencematerial.TheinformationinthecourseappliestoallversionsfromSQLServer
2005onwards.