深入浅出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

　　这本书不是让SQL变得容易，而是让SQL变得有挑战性，变得有趣，变得好玩。本书甚至回答了那个老问题：如何讲解无关联子查询而不会因此失去活下去的愿望？本书是正确的学习途径快速、活泼、而且看上去很酷。《深入浅出SQL》用最新的认知科学和学习理论打造多感官的学习体验，它运用丰富的视觉形式激发你的大脑工作，而不是密密麻麻的文字让你看了昏昏欲睡。　　你将从本书学到什么？　　在如今的世界，数据就是力量，但是成功的真正秘诀却是管理你的数据的力量。《深入浅出SQL》带你进入SQL语言的心脏地带，从使用INSERT和SELECT这些基本的查询语法到使用子查询（subquery）、连接（join）和事务（transaction）这样的核心技术来操作数据库。到读完本书之时，你将不仅能够理解高效数据库设计和创建，还能像一个专家那样查询、归一（normalizing）和联接数据。你将成为数据的真正主人。