请输入您要查询的百科知识:

 

词条 深入浅出SQL(影印版)
释义

书名,(美国)贝里著,汉语版由东南大学出版社2008年出版。介绍SQL的使用方法,从使用INSERT和SELECT这些基本的查询语法到使用子查询(subquery)、连接(join)和事务(transaction)这样的核心技术来操作数据库。该书“运用丰富的视觉形式激发大脑工作,而不是密密麻麻的文字让读者看了昏昏欲睡”。

版权信息

书 名: 深入浅出SQL(影印版)

作 者:(美国)贝里

出版社: 东南大学出版社

出版时间: 2008

ISBN: 9787564111380

开本: 16

定价: 98.00 元

内容简介

你将从本书学到什么?

在如今的世界,数据就是力量,但是成功的真正秘诀却是管理你的数据的力量。《深入浅出SQL》带你进入SQL语言的心脏地带,从使用INSERT和SELECT这些基本的查询语法到使用子查询(subquery)、连接(join)和事务(transaction)这样的核心技术来操作数据库。到读完本书之时,你将不仅能够理解高效数据库设计和创建,还能像一个专家那样查询、归一(normalizing)和联接数据。你将成为数据的真正主人。

为什么本书看起来如此不同?

我们认为你的时间如此宝贵以至于不应该花费在为新概念伤脑筋上面。《深入浅出SQL》用最新的认知科学和学习理论打造多感官的学习体验,它运用丰富的视觉形式激发你的大脑工作,而不是密密麻麻的文字让你看了昏昏欲睡。

编辑推荐

“这本书不是让SQL变得容易,而是让SQL变得有挑战性,变得有趣,变得好玩。本书甚至回答了那个老问题:如何讲解无关联子查询而不会因此失去活下去的愿望?本书是正确的学习途径——快速、活泼、而且看上去很酷。”

——AndrewCumming,《SQLHacks》的作者

“有些书你会买,有些你会保存,有些你会放在案头,感谢O’Reilly和HeadFirst团队开创了终极的HeadFirst(深入浅出)系列。这个系列的书籍会被逐页翻阅,变得皱皱巴巴并被随身携带。《深入浅出SQL》在我的书堆的顶端。”

——BillSawyer,ATG培训经理,Oracle

作者介绍

Lynnisafictionwriterstuckinatechnicalbookwriter'sbody.Upondiscoveringthattechnicalbookwritingactuallypaidrealmoney,shelearnedtoacceptandenjoyit.

AftergoingbacktoschooltogetaMastersincomputerscience,sheworkedfortheacronymsNRLandLANL.ThenshediscoveredFlash,andwroteherfirstbestseller.

目录

Intro

WhoiSthisbookfor?

Weknowwhatyou’rethinking

Metacognition

Bendyourbrainintosubmission

Readmc

Thetechnicalreviewteam

Acknowledgments

1DataandTables:Aplaceforeverything

Definingyourdata

Lookatyourdataincategories

What'sinadatabase?

Yourdatabaseviewedthroughx-rayspecs

Databasescontainconnecteddata

TablesUpClose

Takecommand!

Settingthetable:theCREATETABLEstatement

Creatingamorecomplicatedtable

LookhoweasyitistowriteSQL

Createthemycontactstable,finally

Yourtableisready

Takeameetingwithsomedatatypes

Yourtable,DESCribed

Youcan'trecreateanexistingtableordatabase!

Outwiththeoldtable,inwiththenew

Toadddatatoyourtable,you'llusetheINSERTstatement

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...there'sabetterway

Afterthedates,youareeitherIN...

...oryouareNOTIN

MoreNOT

YourSQLToolbox

3DELETEandUPDATE:Achangewilldoyougood

Clownsarescary

Clowntracking

Theclownsareonthemove

Howourclowndatagetsentered

Bonzo,we'vegotaproblem

GettingridofarecordwithDELETE

UsingournewDELETEstatement

DELETErules

TheINSERT-DELETEtwostep

BecarefulwithyourDELETE

ThetroublewithimpreciseDELETE

ChangeyourdatawithUPDATE

UPDATErules

UPDATEisthenewINSERT-DELETE

UPDATEinaction

Updatingtheclowns'movements

UPDATEyourprices

AllweneedisoneUPDATE

YOurSQLTbolbox

4SmartTableDesign:Whybenormal?

Twofishytables

Atableisallaboutrelationships

Atomicdata

Atomicdataandyourtables

Atomicdatarules

Reasonstobenormal

Thebenefitsofnormaltables

Clownsaren'tnormal

Halfwayto1NF

PRIMARYKEYrules

GettingtoNORMAL

FixingGreg'stable

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

……

随便看

 

百科全书收录4421916条中文百科知识,基本涵盖了大多数领域的百科知识,是一部内容开放、自由的电子版百科全书。

 

Copyright © 2004-2023 Cnenc.net All Rights Reserved
更新时间:2025/3/25 16:58:41