SQL Pocket Guide
Publisher: O'Reilly Media
Final Release Date: March 2004
Pages: 160

This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include:

  • Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).
  • Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate)
  • Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries.
  • Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site.
"If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book." --Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillySQL Pocket Guide
 
4.5

(based on 2 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 2 customers

Sort by

Displaying reviews 1-2

Back to top

 
4.0

Like any pocket guide, you can't go wrong.

By Scott Hiser

from Undisclosed

Comments about oreilly SQL Pocket Guide:

I love the O'Reilly pocket guides. They're like a check list reminder of things you know how to do but sometimes need to take a quick look to jog your memory.

I write a lot of programs and do a lot of consulting. Sometimes I don't touch anything beyond basic SQL statements for months on end. Being like most people in the IT field, we're very busy learning and keeping up with new technologies. Having this as a quick reference is great for leveraging your time and knowledge adaption.

For experienced IT people, a Pocket Guide may eliminate the need for buying any books (For those who don't read the online manuals or subscribe to knowledge services). Hand an experienced script writing a C++ pocket reference and in no time that person will be writing C++ programs.

These are great for beginners to experts.

 
5.0

The little book you keep on your desk

By Douglas Rowe from the Columbia Java Users Group

from Undisclosed

Comments about oreilly SQL Pocket Guide:

Most people that work in SQL daily, don't need reminders of how to write join, correlate or update queries. But the other 10% of the work you do is where you run into trouble. You know you can do something, you just need to know the syntax. This little gem fills that bill nicely. Concise, clear and with a good index, SQL Pocket Guide gives you what you need. Complex functions are explained and it covers DB2, Oracle, SQL Server and MySQL with good depth. Indispensible.

Displaying reviews 1-2

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options