SQL技术手册

出版时间：2009-7  出版社：东南大学出版社  作者：（美）克兰（Kline,K），（美）克兰（Kline,D），（美）亨特（Hunt,B）　著  页数：578  

前言

Since its first incarnation in the 1970s,the Structured Query Language （SQL）hasbeen developed hand in hand with the information boom,and as a result,it is themost widely used database manipulation language in business and industry.Anumber of different software companies and program developers,including thosein the open source movement （http://www.opensource.org）,have concurrently developed their own SQL dialects in response to specific professional needs.Allthe while,standards bodies have developed a growing list of common features.SQL in a Nutshell,Third Edition,describes the latest ANSI standard,SQL2003（SQL3）version of each SQL command,and then documents each platform'simplementation of that command.In this book,you will find a concise explana-tion of the relational database management system （RDBMS）model,a clear-cutexplanation of foundational RDBMS concepts,and thorough coverage of SQLsyntax and commands.Most importantly,at least if you're a programmer or developer,SQL in a Nutshell,Third Edition,provides a concise guide both to the most popular commercialdatabase packages on the market （Microsoft SQL Server and Oracle）.It is also theguide for two of the best-known open source database products （MySQL andPostgreSQL）.The attention this book pays to open source SQL platforms recog-nizes the growing importance of the open source movement within the computingcommunity.

内容概要

《SQL技术手册》是当今最流行的数据库产品中使用的SQL语言的必不可少的一本指南。这个更新的版本依照最新的ANSI标准清楚地评述了每个SQL命令，并详述了这些命令在Microsoft SQL Server 2008、Oracle 11g、MySQL 5.1和PostgreSQL 8.3中分别如何实现。你还可以纵览关系数据库管理系统(RDBMS)模型，并获取关于RDBMS基本原理的明确解释。这本通俗易懂的书提供了：　　·关系数据库模型的背景，包括当前的和以前的SQL标准　　·用于理解关系数据库和SQL命令的必要基础原理　　·按照SQL2003ANSI标准的按字母表顺序排列的SQL语句　　·每一条命令的MySQL、Oracle、PostgreSQL和SQL Server实现　　·按字母表顺序排列的ANSISQL2003函数和厂商实现　　·每种实现独有的平台特定函数　　《SQL技术手册》在厂商文档结束时就着手更新至第三版，提取了众多专业数据库管理者和开发者使用SQL支持复杂的企业级应用程序的不同经验。无论你是初学者还是已经使用了一段时间SQL，这本简明扼要且实用的书籍都会让你学习到许多技巧和技术。

作者简介

Kevin E.Kline是Quest Software公司SQL Server Solution的负责人，该公司是数据库管理及应用程序监测工具的供应商。

书籍目录

Preface1.SQL History and Implementations　The Relational Model and ANSISQL　History of the SQL Standard　SQL Dialects2.Foundational Concepts　Database Platforms Described in This Book　Categories of Syntax　SQL2003 and Platform-Specific Datatypes　Constraints3.SQL Statement Command Reference　HowtoUseThisChapter　SQLPlatformSupport　SQLCommandReference4.SQL Functions　Types of Functions　ANSI SQL Aggregate Functions　ANSI SQL Window Functions　ANSI SQL Scalar Functions　Platform-Specific ExtensionsAppendix:Shared and Platform-Specific KeywordsIndex

章节摘录

插图：History of the SQL StandardIn response to the proliferation of SQL dialects,ANSI published its first SQL stan-dard in 1986 to bring about greater conformity among vendors.This was followedby a second,widely adopted standard in 1989.The International Standards Orga-nization （ISO）also approved the SQL standard.ANSI released one update in1992,known as SQL92 or SQL2,and another in 1999,termed SQL99 or SQL3.The next update,made in 2003,is also referred to as SQL3（or SQL2003）.Whenwe use that term in this book,we are referring to the 2003 revision of thestandard.Each time it revises the SQL standard,ANSI adds new features and incorporatesnew commands and capabilities into the language.For example,the SQL99 stan-dard added a group of capabilities that handled object-oriented datatypeextensions.What's New in SQL2006The ANSI standards body that regulates SQL issued a new standard in 2006,inwhich the important major improvements of SQL3 were retained and augmented.The ANSI SQL2006 release was evolutionary over the SQL3 release,but it did notinclude any significant changes to the SQL3 commands and functions that weredescribed in the second edition of this book.Instead,SQL2006 described anentirely new functional area of behavior for the SQL standard.Briefly,SQL2006describes how SQL and XML（the eXtensible Markup Language）interact.Forexample,the SQL2006 standard describes how to import and store XML data in aSQL database,manipulate that data,and then publish the data both in nativeXML form and as conventional SQL data wrapped in XML form.The SQL2006standard provides a means of integrating SQL application code with XQuery,theXML Query Language standardized by the World Wide Web Consortium（W3C）.Because XML and XQuery are disciplines in their own right,they are consideredbeyond the scope of this book and are not covered here.What's New in SQL2003（SQL3）SQL99 had two main parts,Foundation:1999 and Bindings:1999.The SQL3 Foun-dation section includes all of the Foundation and Bindings standards fromSQL99,as well as a new section called Schemata.The Core requirements of SQL3 did not change from Core SQL99,so the data-base platforms that conformed to Core SQL99 automatically conform to SQL3.Although the Core of SQI_3 has no additions（except for a few new reservedwords）,a number of individual statements and behaviors have been updated ormodified.Because these updates are reflected in the individual syntax descrip-tions of each statement in Chapter 3,we won't spend time on them here.

编辑推荐

《SQL技术手册(影印版)》是由东南大学出版社出版发行的。

用户评论 (总计4条)

•   本书是影印的英文原版，需要一定的SQL语句学习基础和英语才能很好地阅读。
  本书将SQL标准以及SQL Server、Oracle、MySQL和PostgreSQL四大数据库中涉及的语句逐条地进行解析，包括各种关键字的使用方法，在不同数据库中的支持情况等都有详细的说明。适合已经有一点基础的SQL学习者进阶使用，不仅可以当做SQL语句查询工具书，同时借助本书还可以提高自己的数据库英语专业词汇的能力，可谓一举两得。
  美中不足的是，内容繁多，排版难免出现一些小错误，另外语句的查询索引没有标明页数，查询起来略显不便。
•   不错的字典！
•   还在看 很好
•   对几种最常见的数据库中几乎所有SQL命令都齐全，是一本完整的工具书。不过最可惜的是书中的大目录从第三章末的63页直接跳到了第四章的437页，横跨了三百多页。书的最后单独为第三章列了一个明细目录，像字典一样。第三章正好就是讲具体各个数据库各个命令函数的细节的。不过觉得还是放在前面好，因为大目录只有一页，最后一二四章估计都不怎么翻的了。然后日后都从书的后面开始，往前翻到字典目录的开头，然后再往后查询，十分繁琐。人又不是机器，指个Index就可以找到那一页的。希望再版的时候能把字典目录移到前面第二三页开始。