资源描述：
《apress.beginning.sql.queries.from.novice.to.professional.apr.2008bbl外语英文电子书外语英文电子书》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、cyanyelloWMaGenTaBlackpanTone123cBooksforprofessionalsByprofessionals®TheeXperT’sVoice®inDaTaBasesCompanioneBookAvailableBeginningSQLQueries:BeginningFromNovicetoProfessionalDearReader,BeginningSQLQueriesshowsyouhowtowritedatabasequeriesusingtheSQLlanguage.SQLisusedformanyformsofdatamanipulati
2、on,butkeytoallforms—whetheryouarereporting,deleting,orupdating—istheabilitytotargetBeginningAuthorofthe“right”data.ItisfrustratingwhenyouknowsomeinformationisinyourSQLQueriesdatabasebutyoujustcan’tworkouthowtoretrieveit.ItisfrustratingtowriteaBeginningDatabaseDesign:FromNovicetoProfessionalque
3、ry,onlytofindouttoolatethatitreturnsthewrongdata.LearningaboutthedifferentkeywordsandfunctionsinSQLisnotdifficult,butdecidingwhichoneswillhelpyouinanyparticularsituationcanbetricky.WritingquerieswithconfidenceisattheheartofsuccessfullyusingSQL,andthisbookaimstogiveyouthatconfidence.Inthisbook,
4、IshowyoudifferentwaystoapproachproblemssothatyouSQLQuerieswillbeabletofindyourwaythroughthemazeofSQLpossibilitiestocreateaccuratequeries.I’llexplainmanywaysthattablescanbecombined,filtered,andsummarized,andtheSQLstatementsthatsupporttheseoperations.Alongtheway,I’llshowyoualternativewaystothink
5、abouteachquery,sothatyoucanovercomethoseinevitablemomentswhenyourmindjustgoesblank.FromNovicetoProfessionalHavingtaughtSQLformoreyearsthanIcaretoadmit,Iamstillsurprisedbysomeofthequeriesmystudentsdevise,whichaccuratelyaddressaparticularproblem.Myexperiencereinforcesjusthowmanydifferentwaysther
6、earetodevelopaquery.Aninitialattemptthatmightseemobvioustomemaybequiteobscuretoyouandviceversa.Ihopethatafterreadingthisbook,youwillhavetheconfidencetotackleallmannerofqueries,knowingthatyou’regeneratingaccurateinformationfromAthoughtfulapproachtolearningSQLthathelpsyouyourdatabase.thinkaboutt
7、helanguage—andaboutyourdata—sothatClareChurcheryoucanapplytherightoperationstotherightproblemtoCompanioneBookgeneratetherightresults,everytime.THEAPRESSROADMAPSeelastpagefordetailsBeginningBeginningAppliedMathematicsforDateonDatabase:on
