内容简介
TheDefinitiveGuidetoSQLGetcomprehensivecoverageofeveryaspectofSQLfromthreeleadingindustryexperts.RevisedwithcoverageofthelatestRDBMSsoftwareversions,thisone-stopguideexplainshowtobuild,populate,andadministerhigh-performancedatabasesanddeveloprobustSQL-basedapplications.SQL:TheCompleteReference,ThirdEditionshowsyouhowtoworkwithSQLcommandsandstatements,setuprelationaldatabases,loadandmodifydatabaseobjects,performpowerfulqueries,tuneperformance,andimplementreliablesecuritypolicies.LearnhowtoemployDDLstatementsandAPIs,integrateXMLandJavascripts,useSQLobjects,buildwebservers,handleremoteaccess,andperformdistributedtransactions.Techniquesformanagingin-memory,stream,andembeddeddatabasesthatrunontoday'smobile,handheld,andwirelessdevicesareincludedinthisin-depthvolume.BuildSQL-basedrelationaldatabasesandapplicationsCreate,load,andmodifydatabaseobjectsusingSQLConstructandexecutesimple,multitable,andsummaryqueriesImplementsecuritymeasureswithauthentication,privileges,roles,andviewsHandledatabaseoptimization,backup,recovery,andreplicationWorkwithstoredprocedures,functions,extensions,triggers,andobjectsExtendfunctionalityusingAPIs,dynamicSQL,andembeddedSQLExploreadvancedtopicssuchasDBMStransactions,lockingmechanisms,materializedviews,andtwo-phasecommitprotocolUnderstandthelatestmarkettrendsandthefutureofSQL