SQL in a Nutshell: A Desktop Quick Reference Guide

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

  • Background on the Relational Database Model, including current and previous SQL standards
  • Fundamental concepts necessary for understanding relational databases and SQL commands
  • An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
  • The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
  • An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
  • Platform-specific functions unique to each implementation

Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

1100169445
SQL in a Nutshell: A Desktop Quick Reference Guide

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

  • Background on the Relational Database Model, including current and previous SQL standards
  • Fundamental concepts necessary for understanding relational databases and SQL commands
  • An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
  • The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
  • An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
  • Platform-specific functions unique to each implementation

Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

20.49 In Stock
SQL in a Nutshell: A Desktop Quick Reference Guide

SQL in a Nutshell: A Desktop Quick Reference Guide

SQL in a Nutshell: A Desktop Quick Reference Guide

SQL in a Nutshell: A Desktop Quick Reference Guide

eBook

$20.49  $35.99 Save 43% Current price is $20.49, Original price is $35.99. You Save 43%.

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers


Overview

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

  • Background on the Relational Database Model, including current and previous SQL standards
  • Fundamental concepts necessary for understanding relational databases and SQL commands
  • An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
  • The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
  • An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
  • Platform-specific functions unique to each implementation

Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.


Product Details

ISBN-13: 9780596554255
Publisher: O'Reilly Media, Incorporated
Publication date: 11/21/2008
Series: In a Nutshell (O'Reilly)
Sold by: Barnes & Noble
Format: eBook
Pages: 594
Sales rank: 367,149
File size: 7 MB

About the Author

Kevin Kline is a renowned database expert and software industry veteran. A long-time Microsoft SQL Server MVP and noted leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server and the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide. He tweets at @kekline and blogs at http://KevinEKline.com. His IT leadership blog is http://ForITPros.com.

Daniel T. Kline (Ph.D., Indiana University, 1997) specializes Middle English literature and culture; Chaucer; literary and cultural theory; critical pedagogy; and digital medievalism. Among others, his publications include essays in Chaucer Review, College Literature, Comparative Drama, the Journal of English and Germanic Philology, Philological Quarterly, and Literary and Linguistic Computing, and recent chapters in the Cambridge Companion to Medieval Women (Cambridge, 2003), Translating Desire in Medieval and Early Modern Literature (MRTS, 2005), Mass Market Medievalism (McFarland, 2007), Essays on Medieval Childhood: Responses to Recent Debates (Shaun Tyas, 2007), and Cultural Studies of the Modern Middle Ages (Palgrave, 2007). He edited Medieval Children's Literature (Routledge, 2003) and is co-editing The Medieval in Motion, a volume on contemporary film, TV, and videogame neo-medievalism. His current research concerns children, violence, and sacrifice in late-medieval England, and he has essays forthcoming on Emmanuel Levinas and medieval drama and the apocryphal Infancy of Jesus Christ in MS Laud 108. Prof. Kline is an Associate Professor of English and Chair of the Graduate Program in English at the University of Alaska Anchorage. He is also the author/webmaster of The Electronic Canterbury Tales .

Brand Hunt is a Project Manager and Software Developer at Systems Research and Development (http://srdsoftware.com). The team at SRD is a world leader in systems for privacy-friendly identity recognition and relationship awareness. Prior to SRD, Brand worked at Rogue Wave software. Beyond work, Brand enjoys playing board games, pinochle, and snowboarding with his family and friends.

Guy Harrison has worked with databases for more than a decade, has conducted many MySQL and Oracle training seminars, and is author of several books on Oracle, including "Oracle Desk Reference" (Prentice Hall PTR). Currently a product architect at Quest Software, Harrison has conducted many training seminars and has authored several articles for the Oracle Technical Journal. He resides in Australia.

Richard (@SQLRich) is a Sales Engineer at SentryOne, specializing in our SQL Server portfolio offering in EMEA. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community; previously he ran a PASS Chapter in the UK and served on the organizing committee for SQLRelay. Richard also blogs at SQL.RichardDouglas.co.uk.

Table of Contents

Preface v

1 SQL History and Implementations 1

The Relational Model and ANSI SQL 2

History of the SQL Standard 10

SQL Dialects 14

2 Foundational Concepts 16

Database Platforms Described in This Book 16

Categories of Syntax 17

SQL2003 and Platform-Specific Datatypes 29

Constraints 50

3 SQL Statement Command Reference 59

How to Use This Chapter 59

SQL Platform Support 60

SQL Command Reference 63

4 SQL Functions 437

Types of Functions 437

ANSI SQL Aggregate Functions 438

ANSI SQL Window Functions 455

ANSI SQL Scalar Functions 463

Platform-Specific Extensions 483

Appendix Shared and Platform-Specific Keywords 547

Index 555

From the B&N Reads Blog

Customer Reviews