Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows with Prime
Try Prime and start saving today with fast, free delivery

FREE Returns

FREE delivery Friday, December 15. Order within 23 hrs 22 mins

Arrives before Christmas

Select delivery location

In Stock

$$49.56 () Includes selected options. Includes initial monthly payment and selected options. Details

Ships from

Amazon.com

Ships from

Amazon.com

Sold by

Amazon.com

Sold by

Amazon.com

Returns

Returnable until Jan 31, 2024

Returns

Returnable until Jan 31, 2024

For the 2023 holiday season, eligible items purchased between November 1 and December 31, 2023 can be returned until January 31, 2024

Read full return policy

Payment

Secure transaction

Payment

Secure transaction

We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more

Details

Add a gift receipt for easy returns

Get Fast, Free Shipping with Amazon Prime

FREE delivery Monday, December 18 on orders shipped by Amazon over $35

Arrives before Christmas

Select delivery location

Used: Very Good | Details

Sold by We Care About Books

Fulfilled by Amazon

Access codes and supplements are not guaranteed with used items.

Follow the author

Vadim Tropashko

Follow

SQL Design Patterns: The Expert Guide to SQL Programming (IT In-Focus)

by Vadim Tropashko (Author)

3.6 13 ratings

See all formats and editions

Price

New from

Used from

Paperback

"Please retry"

$49.56

$48.59

$15.00

Paperback
$26.28 - $49.56

8 Used from $15.00 9 New from $48.59

{"desktop_buybox_group_1":[{"displayPrice":"$49.56","priceAmount":49.56,"currencySymbol":"$","integerValue":"49","decimalSeparator":".","fractionalValue":"56","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"cML35WS1QnZnGtsGvTDiiCUXbdxIYR5eaOerSrOLDNZcyTMw6Pl2AnCZeY0qp23aw%2Bj17D2zb7k5KTPgH9AtK99F39dlo0wpuOYvfu1qtOWFTvVHY3m2kj6VyAMqwtJc9y6v%2BATOjTM%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$26.28","priceAmount":26.28,"currencySymbol":"$","integerValue":"26","decimalSeparator":".","fractionalValue":"28","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"cML35WS1QnZnGtsGvTDiiCUXbdxIYR5e3%2Fs5yvuF2qKoFZ9nKpk9I%2FHhyeASNIdb9CW%2Fts3ZraeXvTvr0F1gZfwtWkgadZlPe%2BElMORuD1AKiRYEjVwve9YLPKLVz%2F9u%2BYfx4BcDYy1LaOhjMNnR2oPYcV36gA97XnqDnc8gyR9gxBWfxbBfnw%3D%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

This indispensable SQL reference book is the first-of- its-kind to leverage the benefits of design patterns to relational database SQL queries. Leveraging on the success of programming design patterns books, SQL guru Vadim Tropashko categorizes and describes all common SQL structures and design patterns. This is an important book for programmers and managers alike. Because SQL is a declarative language there are many ways to write any SQL query and convoluted and clumsy SQL syntax has become a maintenance nightmare. Professional database programmers must understand the correct way to write SQL for complicated database queries, and managers must institute formal SQL coding standards to improve productivity and maintainability. As relational databases structures become more complex, so do their SQL queries. Complex SQL becomes difficult to understand and maintain, especially with novices who pile-on nested subqueries, and all SQL programmer must learn rudimentary SQL theory, which classifies known SQL solutions into common patterns. SQL design patterns greatly improve the quality and productivity of systems development projects because SQL design patterns form a "best practices" foundation for all relational database queries. The SQL programmers benefit from using SQL design patterns since all query structures are standardized with common approaches, and management benefits by having standardized and maintainable SQL syntax. This book is both pragmatic and academic, a worthy academic book that emphasizes theoretical foundation for almost every type of SQL query problem. Most of the material has accompanying figures that help visualizing the problem. This is not a book for casual programmers or dilettantes. It is specifically created for professional SQL developers who need to solve complex problems using common SQL idioms.

ISBN-10

0977671542
ISBN-13

978-0977671540
Publication date

2014
April 10
Language

EN
English
Dimensions

7.5 x 0.6 x 9.3
inches
Length

256
Pages
See all details

Harry Percival
464
Paperback
40 offers from $35.18
Bill Karwin
181
Paperback
34 offers from $11.25
Cathy Tanimura
123
Paperback
34 offers from $33.40
Anthony Molinaro
183
Paperback
19 offers from $37.99

Editorial Reviews

About the Author

Vadim Tropashko is the translator for "The C++ Programming Language" into Russian. He is a former C++ instructor at University of Radio and Electronics in Belarus and currently works for Oracle.

Product details

Publisher ‏ : ‎ Rampant TechPress (April 10, 2014)
Language ‏ : ‎ English
Paperback ‏ : ‎ 256 pages
ISBN-10 ‏ : ‎ 0977671542
ISBN-13 ‏ : ‎ 978-0977671540
Item Weight ‏ : ‎ 1.13 pounds
Dimensions ‏ : ‎ 7.5 x 0.58 x 9.25 inches

Best Sellers Rank: #2,941,286 in Books (See Top 100 in Books)
- #561 in SQL
- #934 in Database Storage & Design
- #2,722 in Computer Programming Languages

Customer Reviews:
3.6 13 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

Important information

To report an issue with this product, click here.

About the author

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

Vadim Tropashko

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

3.6 out of 5

13 global ratings

2 star

0%

1 star

17%

How customer reviews and ratings work

Sort reviews by

Top reviews from the United States

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

Noel Diaz

Interesting ideas for different views of the same old problems

Reviewed in the United States on October 30, 2019

Well kept book

Some good tips, but known ones

Reviewed in the United States on October 18, 2013

Verified Purchase

It is good book for average to advanced programmers. "Expert" in the name is somewhat misleading. Tips and tricks in this book are mostly well known. If you have more than five years experience as DB programmer - this book might be not so valuable to you as for guy who is working with DB programming a year or two.

One person found this helpful

Helpful

Christopher Wanko

I am unconvinced.

Reviewed in the United States on December 27, 2011

Verified Purchase

This text would be a revelation to someone unfamiliar with Tom Kyte, Joe Celko, or Chris Date. However, given that I own books by all of the former authors, I have to say relunctantly that I am unimpressed by much of the book. His explanations are tough to unravel, and while I do not doubt the math behind some of what he chooses to employ to prove his assertions, I find the reading experience tortuous. This is not an easy book to use, and I suppose his initial caveat that "this is for advanced practitioners only" is supposed to buy him an excuse if you fail to comprehend his text. In my case it does not, as I am confident it's not me, it's him.

-C

9 people found this helpful

Helpful

Amazon Customer

It is quite disappointed, especially compared to GoF's Design Patterns.

Reviewed in the United States on October 26, 2015

Verified Purchase

Cannot find any practical design patterns for SQL programming. Although I was expected to learn some practical design patterns for SQL programming just like GoF's Design Patterns in the field of object oriented programming, however, it is quite disappointed.

Helpful

Jason

Great book for improving SQL skills

Reviewed in the United States on December 30, 2008

I really liked this book. Great examples and explanations of complex ideas. It has definitely helped me to better understand Design Patterns. I plan to come back to this one.

One person found this helpful

Helpful

Laurent Schneider

I have learnt new methods

Reviewed in the United States on July 17, 2007

This book explain the root techniques for grouping and aggregating. It contains versatile approaches, like summing hashes to group items. By reading this book I have now extended my capabilities to build creative queries.

The author invented many techniques, the most famous is probably the row generator CONNECT BY LEVEL<10. Wise approach to constraint is to use a on-commit refreshable materialized view and a constraint on the materialized view to check the view is empty rather than using a trigger. This technique however requires COMMIT (like a deferred constraint).

9 people found this helpful

Helpful

Zack’s Boston

reads like a technical database journal

Reviewed in the United States on September 12, 2009

Verified Purchase

ok vadim knows his stff. but i want to see more emphasis on the practical sections (like sql servers pivot operator, which i use in practice all the time but only got 3 pages, whereas really weird stuff like graphs got like 50 pages.
if your into the super deep stuff u might check this out, however if u are a practical user, than this will be pretty useless.

4 people found this helpful

Helpful

Top reviews from other countries

Dr. Heisenberg

sql master level reading helps you climb a bit higher

Reviewed in Germany on December 5, 2009

Verified Purchase

The book contains what its title promises: sql design patterns. It is very entertaining in reading. There are examples and the complexity grows gradually, so it is a pleasant read for an sql power user. The topics it covers can be found neither in official manuals nor "in a nutshell" style handbooks for the sql databases. The book sits in a sweet spot between database theory and sql specs.

As a power user of an sql database you will probably sooner or later face one or another problem described in the book. Until now I have managed to solve my problems myself, but why reinvent the wheel? It is not only the speed in the development and sql execution time but also maintainability that this book could help you to increase.

As a business and marketing databases analyst I could directly profit from the discussion of the pivot and histogram patterns. Interval coalesce is what I probably will be able to use directly in the near future. The chapters about trees and graphs have extended my horizon. Now I am be able to think about data management problems in a more powerful abstract way. I will certainly keep the book on my table for a reference.

However decently focusing on mainstream sql the book has a slight skew towards Oracle dialect. I have also hoped to find some mention of a Teradata sql dialect and its "all parallel" approach. Some things were not directly applicable to Teradata, like the equivalence of "distinct" and "group by" keywords, that may have different execution plan on Teradata.

All in all I give this excellent book a 4 stars as a must read for anybody interested in getting his data management skills on a much higher level. If you have a problem that looks similar to the topics discussed in this book, you will certainly profit from reading too.

5 people found this helpful

Aman

average

Reviewed in the United Kingdom on March 8, 2015

Verified Purchase

average book

See more reviews

Image Unavailable

Follow the author