SQL in a Nutshell 3e - Couverture souple

Kline, Kevin; Kline, Daniel; Hunt, Brand

Couverture souple

ISBN 10 : 0596518846 ISBN 13 : 9780596518844

Editeur : O′Reilly, 2008

Synopsis

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.

A propos du livre

Présentation de l'éditeur

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference to the language. While it's a standardized language, actual implementations of SQL are anything but standard. Vendor variation abounds, and that's where this book comes into play. SQL in a Nutshell, Second Edition, is a practical and useful command reference for SQL2003, the latest release of the SQL language. The book presents each of the SQL2003 statements and describes their usage and syntax, not only from the point of view of the standard itself, but also as implemented by each of the five major database platforms : DB2, Oracle, MySQL, PostgreSQL, and SQL Server. Each statement reference includes the command syntax by vendor, a description, and informative examples that illustrate important concepts and uses. And SQL is not just about statements. Also important are datatypes and the vast library of built-in SQL functions that is so necessary in getting real work done. This book documents those datatypes and functions, both as described in the standard and as implemented by the various vendors. This edition also includes detailed information about the newer window function syntax that is supported in DB2 and Oracle. SQL in a Nutsbell, Second Edition, is not only a convenient reference guide for experienced SQL programmers, analysts, and database administrators. It's also a great resource for consultants and others who need to be familiar with the various SQL dialects across many platforms.

Détails de l'édition

• Éditeur: O′Reilly
• Date d'édition: 2008
• ISBN 10: 0596518846
• ISBN 13: 9780596518844
• Reliure: Broché
• Langue: anglais
• Numéro d'édition: 3
• Nombre de pages: 592