SQL Pocket Guide, 2nd Edition
Publisher: O'Reilly Media
Final Release Date: April 2006
Pages: 192

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.

Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:

  • Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE))
  • Microsoft SQL Server 2005
  • MySQL 5
  • IBM DB2 8.2
  • PostreSQL 8.1 database
Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillySQL Pocket Guide, 2nd Edition
 
4.6

(based on 5 reviews)

Ratings Distribution

  • 5 Stars

     

    (3)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 5 customers

Sort by

Displaying reviews 1-5

Back to top

 
5.0

Good book to pick up SQL

By Lud

from Marion MA

About Me Designer, Developer

Verified Reviewer

Pros

  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Expert
    • Intermediate
    • Novice
    • Student

    Comments about oreilly SQL Pocket Guide, 2nd Edition:

    Bought book when sent to Syracuse NY to help with Oracle Database. Found very useful and helped with MS access.

     
    4.0

    Tables and Data

    By Wei

    from Ottawa, CA

    About Me Developer

    Pros

    • Accurate

    Cons

    • Could not find the tables

    Best Uses

    • Intermediate

    Comments about oreilly SQL Pocket Guide, 2nd Edition:

    The book is very useful as it have all info I need. It states we can download the tables and data used in this book from this page but I just could not find them. It would be great if the link to the all tables and data used in the book would be outstanding in the page it states [@]Thanks,

    (1 of 1 customers found this review helpful)

     
    5.0

    I use this several times each week

    By BluJai

    from Undisclosed

    Comments about oreilly SQL Pocket Guide, 2nd Edition:

    I own several items in the "Pocket Guide" series. I use this the most frequently by far. Few issues I run into are missing. It is incredibly useful for those quick questions (e.g. "what was the correct syntax for that aggregate function again?").

    If you use SQL on a regular basis, keep this reference handy!

     
    5.0

    Perfect :)

    By Fabio Alessandro Locati

    from Undisclosed

    Comments about oreilly SQL Pocket Guide, 2nd Edition:

    This is a perfect book. Is complete but is not too long. I think that is the best compromise between lenght and contents :).

    (1 of 1 customers found this review helpful)

     
    4.0

    Small is beautiful

    By Peter B.

    from Undisclosed

    Comments about oreilly SQL Pocket Guide, 2nd Edition:

    Its rare to find some good value in such a small book. Packed with all the key information, written concisely and at the right level of competence it provides a useful reminder of the power of SQL. Direct and to the point examples reinforce knowledge and encourage the user to explore the finer points of syntax to increase their own productivity.

    I just wish that the mainstream DB suppliers take up the challenge to demistify some of their own flavours of SQL.

    Peter B.

    Displaying reviews 1-5

    Back to top

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Ebook: $11.99
    Formats:  APK, DAISY, ePub, Mobi, PDF