深入淺出SQL(影印版)

深入淺出SQL(影印版)

書名,(美國)貝里著,漢語版由東南大學出版社2008年出版。介紹SQL的使用方法,從使用INSERT和SELECT這些基本的查詢語法到使用子查詢(subquery)、連線(join)和事務(transaction)這樣的核心技術來運算元據庫。該書“運用豐富的視覺形式激發大腦工作,而不是密密麻麻的文字讓讀者看了昏昏欲睡”。

基本介紹

  • 書名:深入淺出SQL(影印版)
  • 作者:(美國)貝里
  • ISBN:9787564111380
  • 定價:98.00 元
  • 出版社東南大學出版社
  • 出版時間:2008
  • 開本:16
內容簡介,編輯推薦,作者介紹,目錄,

內容簡介

你將從本書學到什麼?
在如今的世界,數據就是力量,但是成功的真正秘訣卻是管理你的數據的力量。《深入淺出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
……

相關詞條

熱門詞條

聯絡我們