SQL Pocket Guide

( 2 )

All Available Formats + Editions

——

$10.19

NOOK Book

——

$10.19

SQL Pocket Guide (eBook) Pub. Date: 11/10/2010 Publisher: O'Reilly Media, Incorporated

——

$10.19

SQL Pocket Guide (eBook) Pub. Date: 12/17/2008 Publisher: O'Reilly Media, Incorporated
$0.01

$11.18

Paperback

$8.64

$11.18

SQL Pocket Guide (Third Edition) Pub. Date: 12/1/2010 Publisher: O'Reilly Media, Incorporated

$0.01

——

SQL Pocket Guide (First Edition) Pub. Date: 1/28/2004 Publisher: O'Reilly Media, Incorporated

$1.24

——

SQL Pocket Guide (Second Edition) Pub. Date: 4/11/2006 Publisher: O'Reilly Media, Incorporated

Customers Who Bought This Also Bought

Advertising

Overview

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.

SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats.

All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including:

Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators
Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more
PostgreSQL’s support of recursive WITH and some window functions
DB2 syntax and datatypes, some compatible with Oracle
MySQL features such as the TIMESTAMP type and the TO_SECONDS function

Product Details

ISBN-13: 9781449394097
Publisher: O'Reilly Media, Incorporated
Publication date: 12/1/2010
Edition description: Third Edition
Edition number: 3
Pages: 196
Sales rank: 140,303
Product dimensions: 4.20 (w) x 6.90 (h) x 0.60 (d)

Meet the Author

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com.

Chapter 1: SQL Pocket Guide; 1.1 Introduction; 1.2 Analytic Functions; 1.3 CASE Expressions: Simple; 1.4 CASE Expressions: Searched; 1.5 CAST Function; 1.6 CONNECT BY Queries; 1.7 Data Type Conversion; 1.8 Data Types: Binary Integer; 1.9 Data Types: Character String; 1.10 Data Types: Datetime; 1.11 Data Types: Decimal; 1.12 Datetime Conversions: DB2; 1.13 Datetime Conversions: MySQL; 1.14 Datetime Conversions: Oracle; 1.15 Datetime Conversions: PostgreSQL; 1.16 Datetime Conversions: SQL Server; 1.17 Datetime Functions: DB2; 1.18 Datetime Functions: MySQL; 1.19 Datetime Functions: Oracle; 1.20 Datetime Functions: PostgreSQL; 1.21 Datetime Functions: SQL Server; 1.22 Deleting Data; 1.23 EXTRACT Function; 1.24 GREATEST; 1.25 Grouping and Summarizing; 1.26 Hierarchical Queries; 1.27 Indexes, Creating; 1.28 Indexes, Removing; 1.29 Inserting Data; 1.30 Joining Tables; 1.31 LEAST; 1.32 Literals; 1.33 Merging Data; 1.34 Nulls; 1.35 Numeric Conversions: DB2; 1.36 Numeric Conversions: MySQL; 1.37 Numeric Conversions: Oracle; 1.38 Numeric Conversions: PostgreSQL; 1.39 Numeric Conversions: SQL Server; 1.40 Numeric/Math Functions; 1.41 OLAP Functions; 1.42 Pivoting and Unpivoting; 1.43 Predicates; 1.44 Recursive Queries; 1.45 Regular Expressions; 1.46 Selecting Data; 1.47 String Functions; 1.48 Subqueries; 1.49 Tables, Creating; 1.50 Tables, Dropping; 1.51 Tables, Modifying; 1.52 Transaction Management; 1.53 Union Queries; 1.54 Updating Data; 1.55 Window Functions;

Jonathan Gennick is an SQL aficionado who writes extensively on the SQL language and other database topics. He is the author of several books, and also a number of articles in Oracle Magazine. He is currently a book editor focusing on database titles, primarily involving Oracle and SQL Server.

Customer Reviews

Average Rating 4.5

( 2 )

Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Review Guidelines

Tell the world what you think of this product.

Add Recommendations

Your Name: Create a Pen Name or Leave Anonymously

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

- HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
- Time-sensitive information such as tour dates, signings, lectures, etc.
- Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
- Comments focusing on the author or that may ruin the ending for others
- Phone numbers, addresses, URLs
- Pricing and availability information or alternative ordering information
- Advertisements or commercial solicitation

Reminder:

- By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
- Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
- See Terms of Use for other conditions and disclaimers.

extofer

Posted February 22, 2011

more from this reviewer

Must Have IT Tool Kit for DBA or Developer

Jonathan Gennick's SQL Pocket Guide is a seamless guide any Database Admin or developer, expert or beginner alike, should have in their IT toolbox. I recall when I was in the university; I picked up a "learn SQL in 24 hours" book as a supplementary to our curriculum book. Had I had this pocket guide then, I would have most certainly struggled less. Most recently I been developing .Net applications to a Pervasive SQL Database, and even with years of Microsoft SQL Server experience, this reference book has been on my side.

SQL is a platform independent database language, this guide will provide guidance and examples for Oracle, DB2, SQL Server, MySQL and PostgreSQL. You can also download code sample for all the mentioned platforms. Moreover, the organization of the book will indicate platform specifics, for instance, Data types spans several pages to distinguish between the various database platforms. The book is structured in alphabetical order by commands, this makes it easier for when you know you want to write a UNION but don't remember the syntax, you're sure to find it towards the end of the book. At times it may seem there are superfluous references to databases you don't work with, nonetheless, it is a Pocket Book primarily for reference and I won't hesitate in recommending it.

1 out of 1 people found this review helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Anonymous

Posted June 28, 2006

Great quick reference

This is a great quick reference. I like that it distinguishes which platform the various sql will work with. The book does not bog down with extreme examples. This book is not a training book. This does a nice job of covering common basic sql.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.

If you find inappropriate content, please report it to Barnes & Noble