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
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!