SQL in A NutshellBook - 2009
SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is focused, and thoroughly comprehensive reference for those who live in a deadline-driven world. This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases. When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Third Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.
Kline, Kline, and Hunt present an updated resource text for programmers, developers, and database administrators describing the latest ANSI standard, SQL 2003 (SQL3) version of each SQL command, and then documenting how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, MySQL 5.1, and PostgreSQL 8.3. The text also provides an overview of the Relational Database Management System (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts. The text contains numerous tips and techniques to benefit both novice and veterans users of SQL. Kevin Kline is with Quest Software, a provider of tools for database management and application monitoring; Daniel Kline teaches English at the U. of Alaska, Anchorage; Hunt is a director of architecture and engineering at Merrill Lynch. Annotation ©2009 Book News, Inc., Portland, OR (booknews.com)
Ingram Publishing Services
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.