SQL Pocket Guide: A Guide to SQL Usage

3.89 avg rating
( 203 ratings by Goodreads )
 
9781449394097: SQL Pocket Guide: A Guide to SQL Usage
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.

Buy New View Book
List Price: US$ 14.99
US$ 11.61

Convert currency

Shipping: FREE
From United Kingdom to U.S.A.

Destination, rates & speeds

Add to Basket

Top Search Results from the AbeBooks Marketplace

1.

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)
Rating
[?]

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 # AAH9781449394097

More information about this seller | Contact this seller

Buy New
US$ 11.61
Convert currency

Add to Basket

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

2.

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 International
(London, United Kingdom)
Rating
[?]

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 # AAH9781449394097

More information about this seller | Contact this seller

Buy New
US$ 11.67
Convert currency

Add to Basket

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

3.

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

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
US$ 11.68
Convert currency

Add to Basket

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

4.

Gennick, Jonathan
Published by O'Reilly Media (2018)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity Available: > 20
Print on Demand
Seller:
Murray Media
(NORTH MIAMI BEACH, FL, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 1449394094

More information about this seller | Contact this seller

Buy New
US$ 12.21
Convert currency

Add to Basket

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

5.

Gennick, Jonathan
Published by O'Reilly Media
ISBN 10: 1449394094 ISBN 13: 9781449394097
New PAPERBACK Quantity Available: 15
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)
Rating
[?]

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

More information about this seller | Contact this seller

Buy New
US$ 8.94
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

6.

Jonathan Gennick
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Quantity Available: 2
Seller:
Speedy Hen LLC
(Sunrise, FL, U.S.A.)
Rating
[?]

Book Description Condition: New. Bookseller Inventory # ST1449394094. Seller Inventory # ST1449394094

More information about this seller | Contact this seller

Buy New
US$ 15.91
Convert currency

Add to Basket

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

7.

Jonathan Gennick
Published by O'Reilly Media
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description O'Reilly Media. Paperback. Condition: New. 206 pages. Dimensions: 6.9in. x 4.2in. x 0.6in.If youre 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. Youll find many examples that address the languages 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: Oracles support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTHVALUE, and more PostgreSQLs 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 TOSECONDS function This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9781449394097

More information about this seller | Contact this seller

Buy New
US$ 16.52
Convert currency

Add to Basket

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

8.

Gennick, Jonathan
Published by O'Reilly Media (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity Available: 10
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

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

More information about this seller | Contact this seller

Buy New
US$ 13.04
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

9.

Jonathan Gennick
Published by O'Reilly Media, Inc, USA
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Paperback Quantity Available: > 20
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)
Rating
[?]

Book Description O'Reilly Media, Inc, USA. Paperback. Condition: New. New copy - Usually dispatched within 2 working days. Seller Inventory # B9781449394097

More information about this seller | Contact this seller

Buy New
US$ 7.98
Convert currency

Add to Basket

Shipping: US$ 9.06
From United Kingdom to U.S.A.
Destination, rates & speeds

10.

Jonathan Gennick
Published by O'Reilly Media (2010)
ISBN 10: 1449394094 ISBN 13: 9781449394097
New Softcover Quantity Available: 1
Seller:
Rating
[?]

Book Description O'Reilly Media, 2010. Condition: New. Seller Inventory # GH9781449394097

More information about this seller | Contact this seller

Buy New
US$ 13.88
Convert currency

Add to Basket

Shipping: US$ 3.51
From Germany to U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book