SQL Pocket Guide

SQL Pocket Guide
Author :
Publisher : "O'Reilly Media, Inc."
Total Pages : 208
Release :
ISBN-10 : 9781449396664
ISBN-13 : 1449396666
Rating : 4/5 (64 Downloads)

Book Synopsis SQL Pocket Guide by : Jonathan Gennick

Download or read book SQL Pocket Guide written by Jonathan Gennick and published by "O'Reilly Media, Inc.". This book was released on 2010-11-10 with total page 208 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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


SQL Pocket Guide Related Books

SQL Pocket Guide
Language: en
Pages: 208
Authors: Jonathan Gennick
Categories: Computers
Type: BOOK - Published: 2010-11-10 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

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
Pocket Guide to Performance Management
Language: en
Pages: 73
Authors: Mark Graham Brown
Categories: Business & Economics
Type: BOOK - Published: 2009-10-29 - Publisher: Quality Press

DOWNLOAD EBOOK

The first half of this book is designed as a mini-dictionary or glossary of common terms used in planning, measuring, and managing performance. The second half
Linux Pocket Guide
Language: en
Pages: 269
Authors: Daniel J. Barrett
Categories: Computers
Type: BOOK - Published: 2016-06 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

O'Reilly's Pocket Guides have earned a reputation as inexpensive, comprehensive, and compact guides that have the stuff but not the fluff. Every page of Linux P
Pocket Guide to Prostate Cancer
Language: en
Pages: 228
Authors: Jeanne Held-Warmkessel
Categories: Prostate
Type: BOOK - Published: 2001 - Publisher: Jones & Bartlett Learning

DOWNLOAD EBOOK

This easy-to-use reference provides nurses with practical material that is useful in the day-to-day care of men with prostate cancer. This pocket guide is divid
Berlitz: Italy Pocket Guide
Language: en
Pages: 364
Authors: Berlitz
Categories: Travel
Type: BOOK - Published: 2014-01-22 - Publisher: Apa Publications (UK) Limited

DOWNLOAD EBOOK

There is something for everyone in Italy: whether you're seeking Roman ruins, Renaissance art, designer chic, mountain climbing, or simply good food and wine, y