Buy used: $19.62

Get Fast, Free Shipping with Amazon Prime

FREE delivery Tuesday, February 14 if you spend $25 on items shipped by Amazon

Or fastest delivery Thursday, February 9. Order within 22 hrs 5 mins

Select delivery location

Used: Good | Details

Sold by JT3 Industries LLC

Fulfilled by Amazon

Access codes and supplements are not guaranteed with used items.

Have one to sell?

Sell on Amazon

Flip to back Flip to front

Listen Playing... Paused You're listening to a sample of the Audible audio edition.
Learn more

See all 2 images

Follow the Author

Anthony Molinaro

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

by Anthony Molinaro (Author)

301 ratings

See all formats and editions

Price

New from

Used from

Paperback

"Please retry"

$19.62

—

$4.29

Paperback
$19.62

41 Used from $4.29

There is a newer edition of this item:

SQL Cookbook: Query Solutions and Techniques for All SQL Users
$53.56
(141)
In Stock.

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.

ISBN-10

9780596009762
ISBN-13

978-0596009762
Edition

1st
Publication date

January 10, 2006
Language

English
Dimensions

7 x 1.4 x 9.19 inches
Print length

636 pages
See all details

Anthony Molinaro
141
Paperback
31 offers from $32.49
Alan Beaulieu
385
Paperback
33 offers from $21.36
Walter Shields
1,378
Paperback
in Data Warehousing
25 offers from $12.21
Inc. BarCharts
1,703
Cards
in SQL
7 offers from $2.49
Ben Forta
456
Paperback
57 offers from $16.99
Mark Reed
283
Paperback
8 offers from $17.46

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.

Product details

ASIN ‏ : ‎ 0596009763
Publisher ‏ : ‎ O'Reilly Media; 1st edition (January 10, 2006)
Language ‏ : ‎ English
Paperback ‏ : ‎ 636 pages
ISBN-10 ‏ : ‎ 9780596009762
ISBN-13 ‏ : ‎ 978-0596009762
Item Weight ‏ : ‎ 2.2 pounds
Dimensions ‏ : ‎ 7 x 1.4 x 9.19 inches

Best Sellers Rank: #571,924 in Books (See Top 100 in Books)
- #54 in MySQL Guides
- #94 in Data Warehousing (Books)
- #131 in SQL

Customer Reviews:
301 ratings

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Videos

Help others learn more about this product by uploading a video!

Upload your video

About the author

Follow authors to get new release updates, plus improved recommendations.

Anthony Molinaro

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs and more

Customer reviews

4.6 out of 5

301 global ratings

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

How customer reviews and ratings work

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

Nate Lincoln

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

Reviewed in the United States 🇺🇸 on August 12, 2017

Verified Purchase

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 T-SQL first (which I recommend going through before this book if you are a beginner).
If you are using T-SQL, I think Ben-Gan's book is a perfect intro to this one. However, this is the book that takes you to another level. This is the book that enables you to find solutions that others won't be able to. This is the book that makes you a player at work if you aren't a developer and you write SQL. There are no functions, triggers, optimization, table and view creation details. This book is about pulling whatever you want with those things already created (although there is a chapter on metadata and another on inserting/updating). So it isn't for everyone (Developers and Beginners especially).

Also, the book's date may scare people. I mean, the book could use an update as it is working with SQL Server 2005 (if you write T-SQL like I do). Based on the date, I'm sure the editions of the other platforms are outdated as well. With SQL Server 2005 capabilities though, you still get Window Functions, Pivots, string extraction, cast, convert, etc., and some of the Oracle functions not in SQL Server 2005 are a part of T-SQL in later editions, so at times, you can use the Oracle solution or pieces of it if you are using the latest edition of SQL Server (if you need to use lead and lag for example). The important functions that still exist are there for the most part (Concat for example, is not).

Most people know how to use partitioning, cases, and subqueries, but can they cast an integer as a string to cast it again into decimal, average that decimal using a case statement that filters out negative values and partition the average as a window function based on multiple criteria all in one line? This book turns you into a magician, and it is all hands on examples, no filler, no lengthy unneeded explanations. Learn by doing.

44 people found this helpful

Helpful

Eric M

Good reference for developers with secondary querying responsibilities

Reviewed in the United States 🇺🇸 on September 23, 2015

Verified Purchase

When you work with SQL infrequently, as I do, but do things beyond the trivial, this book is an excellent way to dive right back into complex query tasks. This has been an invaluable reference that sits on my desk and gets pulled down when I need a guide to accomplish a task. It serves as a way to find a basic approach to the problem at hand and then I can adapt and perhaps combine one or more recipes to do the job. The time saved and effective solutions developed have proved this to be a valuable resource over and over again.

I am not sure how effective this book would be for someone who works on intermediate or advanced queries on a frequent basis. The recipes run the gamut from simple to complicated. However, for someone who needs to dive back in the queries once a month or so, it is a great reference to have on hand. The database-agnostic approach has also benefited me as I moved from an Oracle shop, to an outdated SQL Server shop, to a modern SQL Server shop.

5 people found this helpful

Helpful

Ken Powers

Hope They Write An Updated Version

Reviewed in the United States 🇺🇸 on April 23, 2020

Verified Purchase

I wish I had bought this book sooner, as it's packed with useful SQL that can easily be adapted to the projects you're working on. One note for readers using SQL Server: do an internet search for the functions that the author says are not available for SQL Server. Microsoft has added a lot of functionality to SQL Server since 2005. Functions like "CONCAT", "CONCAT_WS" and "TRANSLATE" are now available in SQL Server. The syntax is similar to the Oracle syntax for those same functions. Still a great book, and I hope someone will write an updated version in the near future.

3 people found this helpful

Helpful

John R. Spencer

Helped Me (a SQL Newbie) Deliver Cmplex SQL Reports

Reviewed in the United States 🇺🇸 on November 25, 2008

Verified Purchase

I was tasked with deliverying 6 key-performance-indicator (KPI) using SQL and Crystal Reports and an Oracle database. And for three disparate areas in the world (USA, Singapore, and The Netherlands).
Sure, I could write a 'SELECT' statement or perform and 'UPDATE'.
But, I did not know how to approach SQL as being a 'complete' solution for record selection.
The Crystal Reports portion was not too much trouble.
I was using the PL/SQL environment for creating the SQL. Oracle 10g.

Mr. Molinaro's book was instrumental in having me develop what turned out to be some rather complex SQL.
It took awhile to get to use SQL's window functions. But, the author's presentation/explanation made them more than approachable---and quite useful.
I liked the explanations that covered the multiple vendors' database engines.
I will make no pretense of having reached SQL knowledge 'nirvana'--However, there was more than one time where I was out of ideas on how to get/count certain data----The SQL Cookbook did its job by showinge 'yet another way' to approach a pressing problem with a solution.
And one can gain a deep understanding of how SQL works. Always a plus for anyone that is new to an environment.
If there was something like a SQL University, this book seems to be text that would work very well for giving students more than enough 'footing' to face the 'real' world. It did for me.
I am more than pleased to have this book as part of my SQL 'library.'

16 people found this helpful

Helpful

L. Rodriguez

Chock-full of info, but needs an index!

Reviewed in the United States 🇺🇸 on May 6, 2010

Verified 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.

4 people found this helpful

Helpful

Top reviews from other countries

Michael Bironneau

Good for beginners

Reviewed in the United Kingdom 🇬🇧 on April 23, 2014

Verified Purchase

I bought this as a quick reference for my job. I find it very helpful and some of the tricks, explained concisely and with easy-to-follow examples, saved me a lot of time. The comparison of solutions for various DB provides (Oracle, SQL Server...) is very clear and also serves as an interesting point of reference for someone who is comparing providers. Some statistical functions are supported out of the box in Oracle, while they are not in SQL Server, for example.

However, I would like to have seen a brief discussion of the impact of window functions on performance in addition to (or instead of) the needlessly abstract explanations in the appendix. More generally, some quick tips on optimizing the performance of queries would have been helpful, and could have been done without straying beyond the scope of the book. That said, from the point of view of a developer in need of quick answers this book does exactly what it promises - helps the reader rapidly identify a solution to most problems involving SQL databases.

3 people found this helpful

Say No More 67

Highly recommended for intermediate level

Reviewed in the United Kingdom 🇬🇧 on September 4, 2018

Verified Purchase

I found many of the hundreds of real life examples very useful.
How much useful can be seen by my extensive use of highlighting and bookmarks.
It certainly boosted my productivity, especially the sections about Cubes, Window Functions and Common Table Expressions (CTE).

One person found this helpful

osgarsea

Very intuitive and useful book

Reviewed in the United Kingdom 🇬🇧 on March 19, 2016

Verified Purchase

Very well explained recipes, with the example code for Oracle, Post great, DBE, SQL server and MySQL. There is a discussion for each recipe and for every RDBMS explaining the code bit by bit. The only negative aspect so far is that as it's from 2005, there are some functions that didn't exist at that time so they are not used, but that's not a big issue.

2 people found this helpful

Pádraig Ó

SQL Cooks

Reviewed in the United Kingdom 🇬🇧 on September 26, 2011

Verified Purchase

I needed an SQL book to give me some assistance with some coding I was working on.

Being new to SQL, I found this book to be very helpful. The examples are good, easy to follow and have allowed me to carry on with my work.

A useful book to have in your library.

3 people found this helpful

Nigelo

Great buy

Reviewed in the United Kingdom 🇬🇧 on August 6, 2013

Verified Purchase

I purchased this and another book for my staff at the office,. they had used SQL a little and started to learn it. These guys are now flying and are now quite advanced

One person found this helpful

See all reviews

Follow the Author

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

There is a newer edition of this item:

Customers who viewed this item also viewed

Editorial Reviews

About the Author

Product details

Videos

About the author

Anthony Molinaro

Customer reviews

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

Top reviews from other countries