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

3.99 avg rating
( 231 ratings by Goodreads )
 
9780596009762: SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly))
View all copies of this ISBN edition:
 
 

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.

"synopsis" may belong to another edition of this title.

Book Description:

Query Solutions and Techniques for Database Developers

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Molinaro, Anthony
Published by O'Reilly Media 12/1/2005 (2005)
ISBN 10: 0596009763 ISBN 13: 9780596009762
New Paperback or Softback Quantity Available: 10
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description O'Reilly Media 12/1/2005, 2005. Paperback or Softback. Condition: New. SQL Cookbook. Book. Seller Inventory # BBS-9780596009762

More information about this seller | Contact this seller

Buy New
US$ 29.09
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Molinaro, Anthony
Published by O'Reilly Media
ISBN 10: 0596009763 ISBN 13: 9780596009762
New PAPERBACK Quantity Available: > 20
Seller:
Mediaoutlet12345
(Springfield, VA, U.S.A.)
Rating
[?]

Book Description O'Reilly Media. PAPERBACK. Condition: New. 0596009763 *BRAND NEW* Ships Same Day or Next!. Seller Inventory # SWATI2132919673

More information about this seller | Contact this seller

Buy New
US$ 25.75
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

3.

Molinaro, Anthony
Published by O'Reilly Media (2018)
ISBN 10: 0596009763 ISBN 13: 9780596009762
New Paperback Quantity Available: > 20
Print on Demand
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 0596009763

More information about this seller | Contact this seller

Buy New
US$ 31.34
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Molinaro, Anthony
Published by O'Reilly Media
ISBN 10: 0596009763 ISBN 13: 9780596009762
New PAPERBACK Quantity Available: 15
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)
Rating
[?]

Book Description O'Reilly Media. PAPERBACK. Condition: New. 0596009763 BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!|2.25. Seller Inventory # OTF-S-9780596009762

More information about this seller | Contact this seller

Buy New
US$ 27.37
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

5.

Molinaro, Anthony
Published by O'Reilly Media (2018)
ISBN 10: 0596009763 ISBN 13: 9780596009762
New Paperback Quantity Available: 10
Print on Demand
Seller:
Save With Sam
(North Miami, FL, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, 2018. Paperback. Condition: New. Brand New! This item is printed on demand. Seller Inventory # 0596009763

More information about this seller | Contact this seller

Buy New
US$ 29.16
Convert Currency

Add to Basket

Shipping: US$ 3.00
Within U.S.A.
Destination, Rates & Speeds

6.

Anthony Molinaro
Published by O Reilly Media, Inc, USA, United States (2006)
ISBN 10: 0596009763 ISBN 13: 9780596009762
New Paperback Quantity Available: 10
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description O Reilly Media, Inc, USA, United States, 2006. Paperback. Condition: New. Language: English . Brand New Book. Query Solutions and Techniques for Database Developers. Seller Inventory # AAH9780596009762

More information about this seller | Contact this seller

Buy New
US$ 35.74
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Molinaro, Anthony
Published by O'Reilly Media, Inc, USA (2005)
ISBN 10: 0596009763 ISBN 13: 9780596009762
New Softcover First Edition Quantity Available: 14
Rating
[?]

Book Description O'Reilly Media, Inc, USA, 2005. Condition: New. Useful for those who want to take his or her SQL skills to the next level. Containing over 200 recipes, this book helps you conquer common data query and manipulation problems, including those related to window functions, data warehousing, and string manipulation. Num Pages: 636 pages, black & white illustrations. BIC Classification: UMT. Category: (G) General (US: Trade). Dimension: 233 x 178 x 32. Weight in Grams: 860. . 2005. 1st Edition. Paperback. . . . . . Seller Inventory # V9780596009762

More information about this seller | Contact this seller

Buy New
US$ 36.49
Convert Currency

Add to Basket

Shipping: FREE
From Ireland to U.S.A.
Destination, Rates & Speeds

8.

Anthony Molinaro
Published by O Reilly Media, Inc, USA, United States (2006)
ISBN 10: 0596009763 ISBN 13: 9780596009762
New Paperback Quantity Available: 10
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description O Reilly Media, Inc, USA, United States, 2006. Paperback. Condition: New. Language: English . Brand New Book. Query Solutions and Techniques for Database Developers. Seller Inventory # AAH9780596009762

More information about this seller | Contact this seller

Buy New
US$ 36.74
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Anthony Molinaro
ISBN 10: 0596009763 ISBN 13: 9780596009762
New Quantity Available: 3
Seller:
Speedy Hen LLC
(Sunrise, FL, U.S.A.)
Rating
[?]

Book Description Condition: New. Bookseller Inventory # ST0596009763. Seller Inventory # ST0596009763

More information about this seller | Contact this seller

Buy New
US$ 37.01
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

Molinaro, Anthony
Published by O'Reilly Media, Inc, USA
ISBN 10: 0596009763 ISBN 13: 9780596009762
New Softcover Quantity Available: 14
Seller:
Kennys Bookstore
(Olney, MD, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, Inc, USA. Condition: New. Useful for those who want to take his or her SQL skills to the next level. Containing over 200 recipes, this book helps you conquer common data query and manipulation problems, including those related to window functions, data warehousing, and string manipulation. Num Pages: 636 pages, black & white illustrations. BIC Classification: UMT. Category: (G) General (US: Trade). Dimension: 233 x 178 x 32. Weight in Grams: 860. . 2005. 1st Edition. Paperback. . . . . Books ship from the US and Ireland. Seller Inventory # V9780596009762

More information about this seller | Contact this seller

Buy New
US$ 37.27
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book