|
SQL Pocket Guide (Pocket Reference (O'Reilly))
|
| List Price: | $14.99 |
| Price: | $10.19 & eligible for FREE Super Saver Shipping on orders over $25. Details |
Availability: Usually ships in 24 hours
Ships from and sold by Amazon.com
48 new or used available from $5.49
Average customer review:
Product Description
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
Product Details
- Amazon Sales Rank: #37202 in Books
- Published on: 2008-08-05
- Original language: English
- Number of items: 1
- Binding: Paperback
- 192 pages
Editorial Reviews
About the Author
Customer Reviews
Not Bad, not Great
Its a pocket guide on just the data manipulation components of the SQL language for the 4 major versions (Oracle, MySQL, MS SQL and DB2) - you can't judge this as a complete reference or learning guide. As SQL data manipulation has only a finite set of keywords and a fairly strict syntax, its hard to go wrong. Like most pocket guides, only people that already know the topic should purchase. As this title only covers data manipulation and not definition language control language (for example, page 112 does list the CREATE TABLE keywords, but as a secondary example and not a true reference), if you are looking for a complete reference guide to all things SQL, this is not your title.
The biggest problem I had with this book is it's organization and layout. Unlike other keyword guides that organize keyword references alphabetically, any time you need to refresh your memory on a specific keyword you have to find it first in the back index as this guide organizes by topic (Inserting Tables, Deleting Data, Predicates, etc.). The topic-oriented structure would be better served in a learning text, or as a secondary table of content for a larger reference guide. Once you do find your keyword's page, the actual layout of the text can make it difficult to quickly identify the topic, keyword, and target vendor. If you're going to run everything together in very similar font sizes and weights without a page break, a few horizontal lines and inverse text won't kill you.
Definitely a useful reference book if you're on the go and need to carry a reminder with you, but as a day to day desktop reference, there are other guides which provide more complete reference as well as better formatting.
DML short reference for ORACLE, DB2, SQL Server and MySQL
"SQL Pocket Guide" is a short reference book for SQL DML (Data Manipulation Language = insert, update, delete, select verbs) and derived statements (merge in ORACLE, replace in MySQL is missing) for the following databases:
- ORACLE (9i und 10g)
- DB2
- SQL Server
- MySQL
Jonathan Gennick explains the ANSI SQL commands and the special implementations of the different databases. For every statement you will find at least one example that can be tested on Jonathan's example data (available from the O'Reilly website). This book does NOT describe the DDL (e.g. create table) or DCL (e.g. grant) statements of the respective databases. Maybe this book should have been named "SQL (DML) pocket guide" to avoid different expectations.
Being an ORACLE person, I can not comment much on the correctness of the information about the other databases, however I found it quite interesting to see the comparison (ORACLE seems to implement most options).
I found the organization of the book a bit strange when I read it from cover to back (I would have placed type conversions and literals together). If you are using this book as a reference this should not concern you because I found the index to be very good. A chapter numbering (or bigger differences in the font size for the chapter levels) would have made it easier for me to keep track of the subchapter level while reading.
The coverage of the DML statement's possibilities is quite high and lots of exceptions are covered. I (re)learned a lot of things like WITH in ORACLE, NVL2, CASE statement, RETURNING with UPDATE, INSERT und DELETE when I read this book.
I will continue to use this book as a starting point when I don't remember how to use a certain SQL/DML feature (reference lookup). "SQL Pocket Reference" already saved a colleague of mine valuable hours (because I just reread about the MERGE statement). You will not be able to learn SQL with this book but you will probably save some time with it, if you write DML a lot.
Excellent LITTLE Book
This is an excellent LITTLE book. With books from O'Reilly or Wiley, you can usually rest assured that it is worth your money. This one certainly is. I bought two -- one for work and one for home. I also bought "SQL in a Nutshell" which is more extensive but much larger (but not a tome). For those quick now-how-do-I-write-that-stupid-little-sql-statement moments, this is the ticket.
