- Paperback: 160 pages
- Publisher: O'Reilly Media; 1 edition (April 5 2004)
- Language: English
- ISBN-10: 0596005121
- ISBN-13: 978-0596005122
- Product Dimensions: 17.5 x 10.7 x 1.3 cm
- Shipping Weight: 340 g
- Average Customer Review: 4.0 out of 5 stars See all reviews (5 customer reviews)
- Amazon Bestsellers Rank: #1,115,695 in Books (See Top 100 in Books)
- See Complete Table of Contents
|
||||||||||||||||||
|
||||||||||||||||||
|
||||||||||||||||||
| ||||||||||||||||||
|
There is a newer edition of this item:
|
Product Details |
Product Description
Product Description
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.
About the Author
Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com.
Inside This Book
(Learn More)
Browse and search another edition of this book.
Browse and search another edition of this book.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most helpful customer reviews
2 of 2 people found the following review helpful
3.0 out of 5 stars
Great, but not what I was looking for.,
By
This review is from: SQL Pocket Guide (Paperback)
First: The signal to noise ratio in this book is wonderful. There's a vast amount of information packed into this little volume.Second: A significant portion of it has to do with interoperability between database vendors, the differences in syntactic sugar between Oracle/DB2/SQL Server & MySql really don't interest me all that much. Third: There is nary a word in here about DDL. Nothing on creating/dropping tables, indices & keys, views, databases. Fourth: Nor is there any treatment on user access (granting permissions, etc.) Fifth: Selects/Joins/updates/deletes, etc. Are all very thoroughly covered. These are all things I expect a "SQL Pocket Guide" to have. Instead this is more of a "SQL Interoperability Guide". Conclusion? This is a great little book if you are not a DBA and never take on the role of one.
1 of 1 people found the following review helpful
4.0 out of 5 stars
Missing Some Detail,
By
This review is from: SQL Pocket Guide (Paperback)
Over all, book is okay lots of content for such a small book. I use it frequently for a quick reference on joins, multi-table inserts, etc.Important things missing: granting user permissions, ddl, sometimes it would be nice to know about implementation details in previous versions.
4.0 out of 5 stars
Answers the 'how do I do that again' questions,
This review is from: SQL Pocket Guide (Paperback)
This is the perfect quick reference book for those familiar with SQL who are either working in a new environment or doing something they haven't done in a while. It's concise, well ordered, and importantly provides most of the crucial cross-platform differences in SQL implementation. The major thing I would have changed is to add more examples.
Share your thoughts with other customers: Create your own review
Want to see more reviews on this item?
|
Most recent customer reviews |
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
Would you like to update product info or give feedback on images?
