SQL Pocket Guide (Paperback)

by Jonathan Gennick

Format: Paperback 208 pages

In stock

Usually despatched within 24 hours

Price check

RRP £9.50

£9.30

You save: £0.20

Add to basket

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

Book details

Published
07/12/2010

Publisher
O'Reilly Media, Inc, USA

ISBN
9781449394097


Other books by this author See all titles

The prices displayed are for website purchases only, and may differ to the prices in Waterstones shops.