Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
SQL Pocket Guide, Paperback / softback Book

SQL Pocket Guide Paperback / softback

Paperback / softback

Item not Available

Description

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

Information

Other Formats

Save 32%

£15.99

£10.85

Item not Available
Item not Available
Sign in to add to wishlist
 
Free Home Delivery

on all orders

 
Pick up orders

from local bookshops

Information