SQL Pocket Guide: A Guide to SQL Usage (Pocket Guides)

3.89 avg rating
( 255 ratings by Goodreads )
 
9781449394097: SQL Pocket Guide: A Guide to SQL Usage (Pocket Guides)
View all copies of this ISBN edition:
 
 

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

"synopsis" may belong to another edition of this title.

Book Description:

A Guide to SQL Usage

About the Author:

Jonathan Gennick is an SQL aficionado who writes extensively on the SQL language and other database topics. He is the author of several books, and also a number of articles in Oracle Magazine. He is currently a book editor focusing on database titles, primarily involving Oracle and SQL Server.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

Stock Image

1.

Gennick, Jonathan
Published by O'Reilly Media (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity available: 2
Seller:
Academic Book Solutions
(Medford, NY, U.S.A.)

Book Description O'Reilly Media, 2010. Paperback. Condition: New. Third. New, unread, and unused. Seller Inventory # ABS-1197-1274

More information about this seller | Contact this seller

Buy New
6.45
Convert currency

Add to Basket

Shipping: 2.88
Within U.S.A.
Destination, rates & speeds
Stock Image

2.

Gennick, Jonathan
Published by O'Reilly Media (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity available: 1
Seller:
ShopBook
(Sussex, WI, U.S.A.)

Book Description O'Reilly Media, 2010. Paperback. Condition: New. Seller Inventory # FF-111

More information about this seller | Contact this seller

Buy New
6.68
Convert currency

Add to Basket

Shipping: 2.71
Within U.S.A.
Destination, rates & speeds
Stock Image

3.

Jonathan Gennick
Published by O'Reilly Media, Inc, USA, United States (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity available: 10
Seller:
Book Depository hard to find
(London, United Kingdom)

Book Description O'Reilly Media, Inc, USA, United States, 2010. Paperback. Condition: New. 3rd edition. Language: English. Brand new Book. 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. Seller Inventory # BTA9781449394097

More information about this seller | Contact this seller

Buy New
11.09
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds
Stock Image

4.

Jonathan Gennick
Published by O'Reilly Media, Inc, USA, United States (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity available: 10
Seller:
The Book Depository
(London, United Kingdom)

Book Description O'Reilly Media, Inc, USA, United States, 2010. Paperback. Condition: New. 3rd edition. Language: English. Brand new Book. 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. Seller Inventory # BTA9781449394097

More information about this seller | Contact this seller

Buy New
11.41
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds
Seller Image

5.

Gennick, Jonathan
Published by O'Reilly Media (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity available: 20
Seller:
booksXpress
(Freehold, NJ, U.S.A.)

Book Description O'Reilly Media, 2010. Paperback. Condition: new. Seller Inventory # 9781449394097

More information about this seller | Contact this seller

Buy New
11.47
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Seller Image

6.

Gennick, Jonathan
Published by O'Reilly Media 12/4/2010 (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback or Softback Quantity available: 10
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)

Book Description O'Reilly Media 12/4/2010, 2010. Paperback or Softback. Condition: New. SQL Pocket Guide. Book. Seller Inventory # BBS-9781449394097

More information about this seller | Contact this seller

Buy New
11.54
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

7.

Gennick, Jonathan
Published by O'Reilly Media (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Softcover Quantity available: 1
Seller:
GlassFrogBooks
(Hawthorne, CA, U.S.A.)

Book Description O'Reilly Media, 2010. Condition: New. A+ Customer service! Satisfaction Guaranteed! Book is in NEW condition. Seller Inventory # 1449394094-2-1

More information about this seller | Contact this seller

Buy New
11.75
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

8.

Gennick, Jonathan
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Quantity available: 1
Seller:
GreatBookPrices
(Columbia, MD, U.S.A.)

Book Description Condition: New. Seller Inventory # 10092988-n

More information about this seller | Contact this seller

Buy New
10
Convert currency

Add to Basket

Shipping: 1.91
Within U.S.A.
Destination, rates & speeds
Stock Image

9.

Gennick, Jonathan
Published by O'Reilly Media (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Softcover Quantity available: 10
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)

Book Description O'Reilly Media, 2010. Condition: New. BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!|VCF. Seller Inventory # OTF-Y-9781449394097

More information about this seller | Contact this seller

Buy New
9.25
Convert currency

Add to Basket

Shipping: 2.88
Within U.S.A.
Destination, rates & speeds
Stock Image

10.

Jonathan Gennick
Published by Oand#8242;Reilly (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New PAP Quantity available: 15
Seller:
Paperbackshop-US
(Wood Dale, IL, U.S.A.)

Book Description Oand#8242;Reilly, 2010. PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # WO-9781449394097

More information about this seller | Contact this seller

Buy New
12.14
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book