SQL Books

SQL Cookbook

$24.00

  • ISBN13: 9780596009762
  • Condition: USED – VERY GOOD
  • Notes:

Product Description

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
FROM

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

Pro SQL Server Disaster Recovery, James Luetkehoelter, Excellent Book
US $4.99
End Date: Sunday May-20-2012 17:06:52 PDT
Buy It Now for only: US $4.99
Buy it now | Add to watch list
VN:F [1.9.8_1114]
Follow up this rating with your own written review below...
Rating: 0.0/5 (0 votes cast)
Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Live
  • MSN Reporter
  • Netvibes
  • Reddit
  • RSS
  • StumbleUpon
  • Tumblr
  • Twitter

5 Reveiws for SQL Cookbook

  1. Too long at 600 pages. Sure you’ll understand SQL if you go through all 600 pages and understand them well. Heck that’s true for any subject, including the Qu’ran. But who’se got the time? Get the Sams Teach Yourself SQL in 10 Minutes, Third Edition – Ben Forta; and in about a day you’ll be half way towards mastery. But if you don’t value your time, perhaps you’re still a student rather than a professional, then by all means read this book.
    Amazon User Rating: 1 / 5

    VA:F [1.9.8_1114]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.8_1114]
    Rating: 0 (from 0 votes)
  2. Jeremy Flynn says:

    Maybe not a bad source for an exepienced SQL programmer, but very frustrating for a beginner. There’s no such thing as “generic SQL”; regretfully, it’s vendor-specific and doesn’t really comply ANSI stndards…
    Amazon User Rating: 2 / 5

    VA:F [1.9.8_1114]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.8_1114]
    Rating: 0 (from 0 votes)
  3. Content is excellent, with good examples. I was able to solve a prloblem the very first time I used it. The issue I have is more with Amazon in that I ordered this book in a shipment of 4 others, so it was over a month before I cracked this one open. To my dismay, the binding is not glued on and the book is falling apart. Amazon customer service has not even responded to my three emails asking for resolution.

    Amazon User Rating: 4 / 5

    VA:F [1.9.8_1114]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.8_1114]
    Rating: 0 (from 0 votes)
  4. Danny Peled says:

    This book is awsome!! Dawg, your a sick writer. It helped me through out my course work. The author must be a genius!!!
    Amazon User Rating: 5 / 5

    VA:F [1.9.8_1114]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.8_1114]
    Rating: 0 (from 0 votes)
  5. This is a great product but some of the advanced features weren’t available in SQL Server 2000. I really liked the windowing and hierarchical queries in this book but those features are not available in 2000. For the most part 2000 isn’t used that often anymore but if you are one of the unfortunate to have to use it there will be some compatibility problems with the examples in this book.
    Amazon User Rating: 4 / 5

    VA:F [1.9.8_1114]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.8_1114]
    Rating: 0 (from 0 votes)

Write a review

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>