Books  Ecological & Biological Sciences  Data Analysis & Modelling  Computing for the Natural Sciences 

SQL Pocket Guide

By: Jonathan Gennick(Author)

208 pages, black & white tables

O'Reilly & Associates

Paperback | Dec 2010 | Edition: 3 | #220892 | ISBN-13: 9781449394097
Availability: Usually dispatched within 4 days Details
NHBS Price: £9.50 $12/€11 approx

About this book

For programmers and database administrators who use SQL in their day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL. That includes the syntax for querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax.

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 for compatibility with Oracle
* MySQL features such as the TIMESTAMP type and the TO_SECONDS function

Write a review

There are currently no reviews for this book. Be the first to review this book!


Jonathan Gennick is an O'Reilly Media, Inc. 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. 

Bestsellers in this subject

Computing for Biologists

NHBS Price: £35.99 $46/€40 approx

A Survivor's Guide to R

NHBS Price: £32.99 $42/€37 approx

Machine Learning Methods in the Environmental Sciences

NHBS Price: £29.99 $38/€33 approx

Learning SQL

NHBS Price: £26.50 $34/€29 approx

SQL Cookbook

NHBS Price: £26.50 $34/€29 approx

VAT: GB 407 4846 44
NHBS Ltd is registered in England and Wales: 1875194