资源描述：
《Pro Oracle SQL 2nd Edition》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、BOOKSFORPROFESSIONALSBYPROFESSIONALS®MortonOsborneSandsShamsudeenStillRELATEDProOracleSQLProOracleSQL,SecondEditionunlocksthepowerofSQLintheOracledatabase—oneofthemostpotentSQLimple-mentationsonthemarkettoday.Tomasteritrequiresamulti-prongedapproach:learnthelanguagefeatures,learnhowandwhythelanguag
2、efeatureswork,learnthesupportingfeaturesthatOracleprovidestohelpusethelanguageeffec-tively,andlearntothinkandworkinsets.KarenMortonhasupdatedthecontentforOracleversion12candhelpsyoumasterpowerfulaspectsofOracleSQLfromtheinside-out.You’lllearnanalyticfunctions,theMODELclause,andadvancedgroupingsynta
3、x—featuresthatwillhelpincreatinggoodqueriesforreportingandbusinessintelligenceapplications.ProOracleSQL,SecondEditionalsohelpsyouminimizeparsingoverhead,readexecutionplans,testforcorrectresults,understandperformancemanagement,andexertcontroloverSQLexecutioninyourdatabase.You’lllearnwhentocreateinde
4、xes,howtoverifythattheymakeadif-ference,howtouseSQLBaselinesandProfilestooptimizeandstabilizeSQLexecutionplans,andmuchmore.You’llalsounderstandhowSQLisoptimizedforworkinginsets,andthatthekeytogettingaccurateresultsliesinmakingsurethatqueriesaskclearandprecisequestions.ProOracleSQL,SecondEditionhelp
5、syouworkatatrulyprofessionallevelintheOracledialectofSQL.You’llmasterthelanguage,thetoolstoworkeffectivelywiththelanguage,andtherightwaytothinkaboutaprobleminSQL.•EndorsedbytheOakTableNetwork,agroupofOracletechnologistswell-knownfortheirrigorousandscientificapproachtoOracleDatabaseperformance•Compr
6、ehensive—goesbeyondthelanguagewithafocusonwhatyouneedtoknowtowritesuccessfulqueriesanddatamanipulationstatements.•Performancefocused—teachesyouhowtomeasuretheperformanceofyourSQLstatementsandnotjustthesyntax.WhatYou’llLearn:•MasterpowerfulSQLfeaturesimplementedintheOracleDatabase•UnderstandhowtheOr
7、acleOptimizerdevelopsexecutionplans•ReadandinterpretSQLexecutionplans•QuicklydiagnoseandfixbadlyperformingSQL•Controlexecutionplansthroughhints,profiles,andplanbaselines•Optimizequerieswithinpackagedapplica
