SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly)) 1st Edition

by Anthony Molinaro (Author)

99 customer reviews

ISBN-13: 978-0596009762

ISBN-10: 0596009763

Why is ISBN important?

Trade in your item
Get a $2.41
Gift Card.

Trade in
Learn More

Have one to sell? Sell on Amazon

Share <Embed>

Condition: Used - Good

In Stock. Sold by K and G Books

Access codes and supplements are not guaranteed with used items.

48 Used from $11.98

+ $3.99 shipping

Turn on 1-Click ordering

In Stock.

Ships from and sold by Amazon.com. Gift-wrap available.

List Price: $39.95 Save: $8.80 (22%)

48 New from $22.59

FREE Shipping—or get FREE Two-Day Shipping with Amazon Prime

Turn on 1-Click ordering

Ship to:

Select a shipping address:

More Buying Choices

48 New from $22.59 48 Used from $11.98

96 used & new from $11.98

See All Buying Options

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.

Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:

Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out

Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function

Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set

Bucketization, and why you should never use that term in Brooklyn.

How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques

The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string

Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly))

$31.15 FREE Shipping—or get FREE Two-Day Shipping with Amazon Prime In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently bought together

Total price: $64.92

Buy the selected items together

This item:SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly)) by Anthony Molinaro Paperback $31.15
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping. Details
Learning SQL: Master SQL Fundamentals by Alan Beaulieu Paperback $23.19
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping on orders over $25. Details
SQL Pocket Guide: A Guide to SQL Usage by Jonathan Gennick Paperback $10.58
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping on orders over $25. Details

Customers who bought this item also bought

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Alan Beaulieu

86

Paperback
$23.19
Jonathan Gennick

49

Paperback
$10.58
Sylvia Moestl Vasilik

43

Paperback
$23.59
John L. Viescas

155

Paperback
$31.89
Inc. BarCharts

86

Pamphlet
$4.17
Ben Forta

486

in SQL
Paperback
$25.12

Editorial Reviews

About the Author

Anthony Molinaro is a SQL developer and database administrator with many years experience in helping developers improve their SQL queries. SQL is particular passion of Anthony's, and he's become known as the go-to guy among his clients when it comes to solving difficult SQL query problems. He's well-read, understands relational theory well, and has nine years of hands-on experience solving tough, SQL problems. Anthony is particularly well-acquainted with new and powerful SQL features such as the windowing function syntax that was added to the most recent SQL standard.

Series: Cookbooks (O'Reilly)
Paperback: 636 pages
Publisher: O'Reilly Media; 1 edition (December 26, 2005)
Language: English
ISBN-10: 0596009763
ISBN-13: 978-0596009762
Product Dimensions: 7 x 1.4 x 9.2 inches
Shipping Weight: 2.3 pounds (View shipping rates and policies)
Average Customer Review: 99 customer reviews
Amazon Best Sellers Rank: #45,476 in Books (See Top 100 in Books)
- #2 in Books > Computers & Technology > Databases & Big Data > Other Databases
- #9 in Books > Computers & Technology > Databases & Big Data > Data Warehousing
- #18 in Books > Computers & Technology > Databases & Big Data > SQL

Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?

NO_CONTENT_IN_FEATURE

Customer reviews

4.4 out of 5 stars

5 star		72%
4 star		18%
3 star		5%
2 star		3%
1 star		2%

Write a customer review

See all verified purchase reviews

Rated by customers interested in

What's this?

Cookbooks

4.8 out of 5 stars

Computer Science

4.4 out of 5 stars

Computer Books

4.3 out of 5 stars

Is this feature helpful?

Thank you for your feedback.

Top customer reviews

This book is brilliant!

ByBl0bon May 8, 2014

Format: PaperbackVerified Purchase

I am writing this review now, because a trick I learned from this book helped me reduce the execution time of an oracle 10g query from 37s to 1s. Yes, Oracle has these idiosyncrasies that can drive one nuts.

I find myself visiting the solutions in the book over and over, especially when it comes to hierarchical queries or the queries that generate consecutive numeric values (I use these to generate sample data).

I recommended the book to all my colleagues that do sql programming, and I am waiting for the second edition ;-)

0Comment 3 people found this helpful. Was this review helpful to you?YesNo

Immediate Application

ByMatton September 4, 2013

Format: PaperbackVerified Purchase

I was recently thrown into a job where many queries are already written and need to be analyzed for problems. This book is extremely useful in its ability to give you a quick description on why this function or why this setup was used to do this specific problem. I have gotten through 2 chapters and have already learned many quick tricks that have sped up my problem solving quite a bit. Very solid book for beginner and expert.

0Comment 4 people found this helpful. Was this review helpful to you?YesNo

My most-used SQL reference

ByJ. Elamon December 15, 2011

Format: PaperbackVerified Purchase

I have owned this book since 2006, and I use it in a DB2 environment. I do not use SQL daily or perhaps I would have outgrown the book by now. As it is, the book is smudged and dogeared. It is the book I open every time I need to do something new with SQL, or something that I have not done for a long time. It is extremely well organized, and I rarely have to spend much time finding what I'm looking for. In all this time I have found only one example that was erroneous among all the various topics I've pursued; that was for a complex statement that could have been impacted by an update to DB2 over time. I think it's remarkable that a single book could be so useful over such a long period of time. It is the single most valuable reference book I have ever purchased. I very much recommend it.

0Comment 4 people found this helpful. Was this review helpful to you?YesNo

Some useful information and explanations

ByReview 3.14on April 30, 2017

Format: Kindle EditionVerified Purchase

Some useful information and explanations, but I was expecting more based on the price and other reviews. The examples could be better. It's super detailed in many areas that I doubt I'll ever use.

0CommentWas this review helpful to you?YesNo

Chock-full of info, but needs an index!

ByL. Rodriguezon May 6, 2010

Format: Kindle EditionVerified Purchase

I'm not going to summarize the text, since other reviews have done that very well. The only thing I want to contribute is that I bought the Kindle version for my iPod, and it doesn't have an index. I've had to return to the table of contents multiple times and still needed to guess where a keyword might appear. (Would you know, for example, that the "minus" set difference function appeared in the section titled, "Retrieving values from one table that do not exist in another" if you were unfamiliar with SQL?) There is so much information in this book that I reference constantly, and an index complete with hyperlinks to appropriate sections would have helped so much! As it is, I need the paper version of this book for my office, and the Kindle to read on the bus to work. Still, I would HIGHLY recommend this book to anyone who uses SQL, no matter what platform.

0Comment 3 people found this helpful. Was this review helpful to you?YesNo

Other uses for this book

ByF. Riazon July 1, 2009

Format: PaperbackVerified Purchase

Majority of the cookbooks cater to seasoned programmers so they can quickly lookup a solution without having to reinvent the wheel. However, this particular cookbook can also be used by less experienced programmers as part of "learning by example" methodology.

After learning the sql basics, I had decided to purchase this text. I would read the problem statement and then try to implement the solution by myself. I would compare my solution to that of the author's. Or in certain cases, cheat by copying the given solution. It took me 3+ months to try each and every problem in the text, but in the end, it definitely helped to improve my sql code reading, designing, and coding skills.

I would recommend this book to anybody who is interested in mastering any flavor of sql.

0Comment 4 people found this helpful. Was this review helpful to you?YesNo

Book

ByJolene Nashon August 15, 2016

Format: Kindle EditionVerified Purchase

On time as promised. Excellent Amazon seller. Love that SQL. Would like another book covering the bar-b-queing approach.

0Comment One person found this helpful. Was this review helpful to you?YesNo

Great for learners

ByR. Evanson June 24, 2013

Format: PaperbackVerified Purchase

Over the last couple of years I have been learning SQL for data analysis and collection. The book itself is easy to understand, and the examples given make it easy to understand how the code it working to pull your results back.

Great book for intermediate skilled SQLers.

0Comment 2 people found this helpful. Was this review helpful to you?YesNo

Most recent customer reviews

Succinct & Highly Useful

This book jumps immediately into the examples and provides solutions and examples to many common and sometimes complex issues.Read more

Published 17 days ago by Jean Junker

Four Stars

useful handbook for a quick lookup

Published 1 month ago by Sean

Four Stars

concise and accurate refresher for multiple SQL dialects

Published 1 month ago by Amazon Customer

I write SQL for a living, and this book is why I am able to do my job effectively.

It's the first SQL book I picked up, but be warned, it is for at least intermediate level users. So by the time I reached Chapter 3, I gave up and bought Ben-Gan's Fundamentals of...Read more

Published 1 month ago by Nate Lincoln

The book content is excellent, with lots of examples and good descriptions of ...

I gave this 3 stars, since it wouldn't let me enter 2-1/2, the average of 2 scores, 5 stars and 0 stars.Read more

Published 3 months ago by Unkl Donald

Excellent SQL reference

Very well written. Regardless of which platform you are reading for, this book covers the major ones. For me, it is the DB2 references.Read more

Published 6 months ago by THOMAS W SNIPES

Five Stars

Good for beginners

Published 6 months ago by Susan

Five Stars

Great book, I recommend it...

Published 10 months ago by Amazon Customer

Best SQL Book Ever

BEST SQL book I have ever seen!!! Very useful!

Published 11 months ago by Amazon Customer

Four Stars

Book was in good shape when I received it.

Published 1 year ago by Amazon Customer

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway

This item: SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly))

Set up a giveaway

What other items do customers buy after viewing this item?

Learning SQL: Master SQL Fundamentals Paperback

Alan Beaulieu

86

$23.19
SQL Pocket Guide: A Guide to SQL Usage Paperback

Jonathan Gennick

49

$10.58
SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a "learn-by-doing" approach Paperback

Sylvia Moestl Vasilik

43

$23.59
SQL in 10 Minutes, Sams Teach Yourself (4th Edition) Paperback

Ben Forta

486

$25.12

Pages with related products. See and discover other items: machine shop, virtual machine, data management, german language learning, sql programming, sql databases

SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly)) 1st Edition

Buy used On clicking this link, a new layer will be open $11.98 On clicking this link, a new layer will be open

Turn on 1-Click ordering

Buy new On clicking this link, a new layer will be open $31.15 On clicking this link, a new layer will be open

Turn on 1-Click ordering

or

or

Frequently bought together

Customers who bought this item also bought

Editorial Reviews

About the Author

Product details

Customer reviews

Top customer reviews

Most recent customer reviews

Set up an Amazon Giveaway

What other items do customers buy after viewing this item?

Buy used On clicking this link, a new layer will be open

$11.98 On clicking this link, a new layer will be open

Buy new On clicking this link, a new layer will be open

$31.15 On clicking this link, a new layer will be open