• See large image

  SQL Pocket Guide (Paperback) By (author) Jonathan Gennick

  

  $14.25 - Save $4.04 22% off - RRP $18.29 Free delivery worldwide (to United States and
  all these other countries) Usually dispatched within 48 hours Add to basket | Add to wishlist |

  Short Description for SQL Pocket GuideFor 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.
  Full description

  • Publisher: O'Reilly Media, Inc, USA
  • Published: 07 December 2010
  • Format: Paperback 208 pages
  • See: Full bibliographic data
  • Categories: Computing: General | Database Programming | Programming & Scripting Languages: General
  • ISBN 13: 9781449394097 ISBN 10: 1449394094
  • Sales rank: 72,402

• Transact-SQL Cookbook

  

  Add to basket $46.81 - Save $2.47 (5%) - RRP $49.28

• Oracle SQL*Loader

  

  Add to basket $37.99 - Save $11.29 22% off - RRP $49.28

• Sams Teach Yourself PL/SQL in 21...

  

  Add to basket $37.99 - Save $8.11 (17%) - RRP $46.10

• Oracle 10g Developer

  

  Add to basket $98.17 - Save $7.24 (6%) - RRP $105.41

• Head First SQL

  

  Add to basket $42.07 - Save $12.79 23% off - RRP $54.86

Full description for SQL Pocket Guide

• 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