SQL技术手册(第三版,影印版)
SQL技术手册(第三版,影印版)
Kevin E. Kline, Daniel Kline, Brand Hunt
出版时间:2009年07月
页数:578
《SQL技术手册》是当今最流行的数据库产品中使用的SQL语言的必不可少的一本指南。这个更新的版本依照最新的ANSI标准清楚地评述了每个SQL命令,并详述了这些命令在Microsoft SQL Server 2008、Oracle 11g、MySQL 5.1和 PostgreSQL 8.3中分别如何实现。你还可以纵览关系数据库管理系统(RDBMS)模型,并获取关于RDBMS基本原理的明确解释。这本通俗易懂的书提供了:
· 关系数据库模型的背景,包括当前的和以前的SQL标准
用于理解关系数据库和SQL命令的必要基础原理
· 按照SQL2003 ANSI标准的按字母表顺序排列的SQL语句
· 每一条命令的MySQL、Oracle、PostgreSQL和SQL Server实现
· 按字母表顺序排列的ANSI SQL2003函数和厂商实现
· 每种实现独有的平台特定函数
《SQL技术手册》在厂商文档结束时就着手更新至第三版,提取了众多专业数据库管理者和开发者使用SQL支持复杂的企业级应用程序的不同经验。无论你是初学者还是已经使用了一段时间SQL,这本简明扼要且实用的书籍都会让你学习到许多技巧和技术。
Kevin E. Kline是Quest Software公司SQL Server Solution的负责人,该公司是数据库管理及应用程序监测工具的供应商。
Daniel Kline是美国阿拉斯加大学英语系的副教授和研究生课程主席。
Brand Hunt是Merrill Lynch(美林证券)建筑与工程项目的负责人。
  1. Preface
  2. 1. SQL History and Implementations
  3. The Relational Model and ANSI SQL
  4. History of the SQL Standard
  5. SQL Dialects
  6. 2. Foundational Concepts
  7. Database Platforms Described in This Book
  8. Categories of Syntax
  9. SQL2003 and Platform-Specific Datatypes
  10. Constraints
  11. 3. SQL Statement Command Reference
  12. How to Use This Chapter
  13. SQL Platform Support
  14. SQL Command Reference
  15. 4. SQL Functions of Functions
  16. ANSI SQL Aggregate Functions
  17. ANSI SQL Window Functions
  18. ANSI SQL Scalar Functions
  19. Platform-Specific Extensions
  20. Appendix: Shared and Platform-Specific Keywords
  21. Index
书名:SQL技术手册(第三版,影印版)
国内出版社:东南大学出版社
出版时间:2009年07月
页数:578
书号:978-7-5641-1651-4
原版书出版商:O'Reilly Media
Kevin E. Kline
 
Kevin E. Kline是Quest Software(http://www.quest.com)的SQL Server难题小组技术总监。他领导一支跨国团队,专门为SQL Server市场规划并交付工具。Kevin是SQL Server专业协会(PASS,http://wwww.sqlpass.org)的发起人,PASS是首屈一指的SQL Server用户群,而他目前也担任这个协会的会长。除了在数据库及IT基础建设的相关会议上演说外,Kevin也编写了另外四本数据库方面的书籍,包括《TransactSQL Programming》(O'Reilly出版),还发表了许多关于Microsoft SQL Server的杂志与网络文章以及白皮书。当Kevin没为手边的工作搔头弄发时(虽然他的头发也剩不了多少了),他会跟老婆浪漫一下,陪四个小孩玩,在花园里莳花弄草。
Kevin E. Kline is the director of SQL Server Solutions at Quest Software, a leading
provider of award-winning tools for database management and application monitoring
on the SQL Server platform. Kevin is also the president of the international
Professional Association for SQL Server (PASS) and frequently contributes to database
technology magazines, web sites, and discussion forums. He is the coauthor of
Transact-SQL Programming (O’Reilly) and three other books on database technologies.
Kevin is a top-rated speaker, appearing at international conferences such as
Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections.
 
 
Daniel Kline
 
而Kevin的兄弟,Daniel Kline,是阿拉斯加大学安克雷奇分校的英语副教授,在这里,他专门研究中世纪的文学、文艺和文化理论,以及计算机辅助教学。他在印地安那大学Bloomington分校获得哲学博士学位和其他许多名誉学者称号。Dan最近发表了许多学术论文,如《Literary and Linguistic Computing》、《Philological Quarterly》、《Chaucer Review》和《Essays in Medieval Studies》。当不与妻子和两个儿子在一起时,Dan则沉浸于他喜爱的工程、电子版坎特伯雷故事集(Canterbury Tales)之中(http://cwolf.uaa.alaska.edu/~afdtk/ext_main.htm)。Dan的联系方式为:afdtk@uaa.alaska.edu。
Daniel Kline (Ph.D., Indiana University, 1997) specializes in Middle English
literature and culture; Chaucer; literary and cultural theory; critical pedagogy;
and digital medievalism. An associate professor of English at the University of
Alaska, Anchorage, he is widely published in academic journals and is the
author/webmaster of The Electronic Canterbury Tales (www.kankedort.net).
 
 
Brand Hunt
 
Brand Hunt是Systems Research and Development(SRD)的项目经理及软件开发人员。SRD的团队在亲友身份认知及关系理解的系统中独步全球。在加入SRD之前,Brand曾就职于Rogue Wave Software。工作之余,Brand喜欢玩扑克牌游戏皮纳克尔(pinochle),还喜欢与亲友一起玩滑雪板。
Brand Hunt is a director in architecture and engineering at Merrill Lynch. Beyond
work, Brand enjoys board games, pinochle, and snowboarding with his family and
friends.
 
 
The animal on the cover of SQL in a Nutshell, Third Edition, is a chameleon.
There are approximately 85 species of chameleons existing in the world today.
They are mostly indigenous to Africa, although there are a few species found in
Asia and in Europe. Most are tree dwellers. The chameleon is relatively small; the
average adult size is between 6 and 12 inches. It lives mostly on insects and uses
its long tongue to capture its prey. Indeed, the tongue is a critical tool. It can
stretch up to 1.5 times the lizard’s body length, and there is an adhesive pad on
the end on which the insects are trapped. There are several other characteristics
common to all species of chameleons. For example, its eyes are large and
protruding, and the lizard can see 360 degrees without moving its head or body.
Its toes are on either side of its feet, usually three on one side and two on the
other. This is ideal for moving quickly and efficiently through tree branches.
Chameleons are best known for their ability to change their appearance to adapt
to their physical environment. Actually, several types of reptiles can change their
skin color, but the chameleon is far and away the most accomplished. This skill,
which is moderated by the nervous system, obviously is invaluable for hunting
prey and avoiding predators, and also helps to stabilize body temperature. The
extent of this camouflage capability is related to the gender, age, and species of
the lizard.