Publisher: O'Reilly Media Released: September 2004 Pages: 720
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 a lean, 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 open source implementations (PostgreSQL, 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, Second 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. |
-
Chapter 1 SQL History and Implementations -
The Relational Model and ANSI SQL -
History of the SQL Standard -
SQL Dialects -
Chapter 2 Foundational Concepts -
Database Platforms Described in This Book -
Categories of Syntax -
SQL2003 and Platform-Specific Datatypes -
Constraints -
Chapter 3 SQL Statement Command Reference -
How to Use This Chapter -
SQL Platform Support -
SQL Command Reference -
Chapter 4 SQL Functions -
Types of Functions -
ANSI SQL Aggregate Functions -
ANSI SQL Window Functions -
ANSI SQL Scalar Functions -
Platform-Specific Extensions -
Chapter 5 Database Programming -
Database Programming Overview -
Opening a Database Connection -
Closing a Database Connection -
Managing Transactions -
Executing Statements -
Retrieving Data -
Bound Parameters -
Error Handling -
Examples -
Appendix A Sybase Adaptive Server -
Sybase Adaptive Server Datatypes -
Sybase Adaptive Server SQL Statements -
Sybase Adaptive Server SQL Functions -
Sybase Adaptive Server Keywords -
Appendix B Shared and Platform-Specific Keywords -
Colophon |
- Title:
- SQL in a Nutshell, 2nd Edition
- By:
- Kevin Kline
- With:
- Brand Hunt, Daniel Kline
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- September 2004
- Ebook:
- June 2009
- Pages:
- 720
- Print ISBN:
- 978-0-596-00481-1
- | ISBN 10:
- 0-596-00481-8
- Ebook ISBN:
- 978-0-596-10388-0
- | ISBN 10:
- 0-596-10388-3
|
-
Kevin Kline Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring tools. Kevin is also a founding board member and former President of the international Professional Association for SQL Server (PASS) and frequently contributes to database technology magazines, web sites, and discussion forums. Kevin's most popular book is SQL in a Nutshell published by O'Reilly Media. Kevin is also the author of monthly magazine columns for SQL Server Magazine and Database Trends & Applications. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections. View Kevin Kline's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of SQL in a Nutshell 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 stablize body temperature.The extent of this camouflage capability is related to the gender, age, and species of the lizard. Mary Brady was the production editor for SQL in a Nutshell, and Jane Ellin was the copyeditor.Ann Schirmer was the proofreader. Sarah Sherman and Colleen Gorman provided quality control. Julie Hawks wrote the index. Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman.The cover image is a 19th-century engraving from the Dover Pictorial Archive.Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font. David Futato designed the interior layout. This book was converted by Julie Hawks to FrameMaker 5.5.6 with a format conversion tool created by Erik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher Bing. This colophon was written by Mary Brady. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By Robert Eckstein, Marc Loy, Dave Wood
September 1998
By Thomas Myer
February 2007
By Chris Takemura, Luke S. Crawford
October 2009
Ebook: $39.95
Print & Ebook: $54.95
Print: $49.95
|
Customer Reviews
9/26/2006 4.0missing INFORMATION_SCHEMA By frogola from Undisclosed 3/24/2006 3.0Good coverage of Oracle/SQL Server By loquin from Undisclosed 9/30/2005 4.0Struct Query Language Book very good! By Eduardo Cesar Lunardelli from Undisclosed
|
|
|