深入浅出SQL

图书标准信息

• 作者 [美]贝里 著
• 出版社 东南大学出版社
• 出版时间 2008-03
• 版次 1
• ISBN 9787564111380
• 定价 98.00元
• 装帧 平装
• 开本 16开
• 纸张 胶版纸
• 页数 571页
• 字数 643千字
• 正文语种 简体中文

【内容简介】

　　《深入浅出SQL（影印版）》能让你学到什么？在如今的世界，数据就是力量，但是成功的真正秘诀却是管理你的数据的力量。《深入浅出SQL（影印版）》带你进入SQL语言的心脏地带，从使用INSERT和SELECT这些基本的查询语法到使用子查询（subquery）、连接（join）和事务（transaction）这样的核心技术来操作数据库。到读完《深入浅出SQL（影印版）》之时，你将不仅能够理解高效数据库设计和创建，还能像一个专家那样查询、归一（normalizing）和联接数据。你将成为数据的真正主人。
　　为什么《深入浅出SQL（影印版）》看起来如此不同？
　　我们认为你的时间如此宝贵以至于不应该花费在为新概念伤脑筋上面。《深入浅出SQL（影印版）》用最新的认知科学和学习理论打造多感官的学习体验，它运用丰富的视觉形式激发你的大脑工作，而不是密密麻麻的文字让你看了昏昏欲睡。

【目录】

Intro
WhoiSthisbookfor?
Weknowwhatyou’rethinking
Metacognition
Bendyourbrainintosubmission
Readmc
Thetechnicalreviewteam
Acknowledgments
1DataandTables:Aplaceforeverything
Definingyourdata
Lookatyourdataincategories
Whatsinadatabase?
Yourdatabaseviewedthroughx-rayspecs
Databasescontainconnecteddata
TablesUpClose
Takecommand!
Settingthetable:theCREATETABLEstatement
Creatingamorecomplicatedtable
LookhoweasyitistowriteSQL
Createthemycontactstable,finally
Yourtableisready
Takeameetingwithsomedatatypes
Yourtable,DESCribed
Youcantrecreateanexistingtableordatabase!
Outwiththeoldtable,inwiththenew
Toadddatatoyourtable,youllusetheINSERTstatement
CreatetheINSERTstatement
VariationsonanINSERTstatement
Columnswithoutvalues
PeekatyourtablewiththeSELECTstatement
SQLExposed:ConfessionsofaNULL
ControllingyourinnerNULL
NOTNULLappearsinDESC
FillintheblankswithDEFAULT
YourSQLToolbox

2TheSELECTStatement:Gifteddataretrieval
Dateornodate?
AbetterSELECT
Whatthe*isthat?
Howtoqueryyourdatatypes
Morepunctuationproblems
Unmatchedsinglequotes
Singlequotesarespecialcharacters
INSERTdatawithsinglequotesinit
SELECTspecificcolumnstolimitresults
SELECTspecificcolumnsforfasterresults
Combiningyourqueries
Findingnumericvalues
SmComparisonOperators
FindingnumericdatawithComparisonOperators
TextdataropingwithComparisonOperators
TobeORnottobe
ThedifferencebetweenANDandOR
UseISNULLtofindNULLs
Savingtimewithasinglekeyword:LIKE
ThecalloftheWild(card)
SelectingrangesusingANDandcomparisonoperators
JustBETWEENus...theresabetterway
Afterthedates,youareeitherIN...
...oryouareNOTIN
MoreNOT
YourSQLToolbox

3DELETEandUPDATE:Achangewilldoyougood
Clownsarescary
Clowntracking
Theclownsareonthemove
Howourclowndatagetsentered
Bonzo,wevegotaproblem
GettingridofarecordwithDELETE
UsingournewDELETEstatement
DELETErules
TheINSERT-DELETEtwostep
BecarefulwithyourDELETE
ThetroublewithimpreciseDELETE
ChangeyourdatawithUPDATE
UPDATErules
UPDATEisthenewINSERT-DELETE
UPDATEinaction
Updatingtheclownsmovements
UPDATEyourprices
AllweneedisoneUPDATE
YOurSQLTbolbox

4SmartTableDesign:Whybenormal?
Twofishytables
Atableisallaboutrelationships
Atomicdata
Atomicdataandyourtables
Atomicdatarules
Reasonstobenormal
Thebenefitsofnormaltables
Clownsarentnormal
Halfwayto1NF
PRIMARYKEYrules
GettingtoNORMAL
FixingGregstable
TheCREATETABLEwewrote
Showmethe
Time-savingcommand
TheCREATETABLEwithaPRIMARYKEY
1,2,3...autoincrementally
AddingaPRIMARYKEYtoanexistingtable
ALTERTABLEandaddaPRIMARYKEY
YourSQLToolbox

5ALTER:Rewritingthepast
6AdvancedSELECT:Seeingyourdatawithneweyes
7Multi-tableDatabaseDesign:Outgrowingyourtable
8JoinsandMulti-tableOperations:Can’twealljustgetalong?
9Subqueries:QueriesWithinQueries
10OuterJoins,SelfJoins,andUnions:Newmaneuvers
11Constraints,Views,andTransactions:Toomanycooksspoilthedatabase
12Security:Protectingyourassets