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 manYou 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 outPowerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES functionPivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result setBucketization, 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 techniquesThe technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a stringWritten 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....
|Number of Pages||:||595 Pages|
|Status||:||Available For Download|
|Last checked||:||21 Minutes ago!|
SQL Cookbook Reviews
good stuff in this bitch
If you NEED to learn the amazingly complex and available functionality in SQL queries, this is the book for you. Simply explained and elegantly detailed, this book is truly a must have for anyone with any level of SQL expertise, from the new beginner to the seasoned veteran.
You too can write SQL like the Jedi of old.
Thumbed through this initially and found some new tricks right away. So far it's been easy to find things for specific problems I need to solve.
The book is well organized and structured from simplest to more complex reciepes. It covers top most used RDBMs that is realy helpfull to be informed about all of them but not only the one you are using. There are a lot of well written descriotions to queries so it is easy to understand if you even do not know some key word usage.I was focused on the Oracle solutions. Great reference book that will teach you a lot of neat tricks. Book contain alot of examples that probably will be used by me in futuere. So I could say for sure that I will be reading it again from time to time.
I read this book cover-to-cover rather than using it in the manner intended. The intention is that, when one has a problem to solve, one would find the most similar problem in the table of contents. The repetition of reading multiple similar solutions by reading the entire book helped solidify the concepts. I've read other reviews here that criticize the SQL Cookbook because using the table of contents in the manner intended might lead to a solution that depends on concepts explained in prior solutions. The solutions are not always self-contained. Such criticisms are valid and are part of the reason that I read the book in its entirety. I have since implemented much of the material in my work and have improved a great deal as a result. Highly recommended.
The book covers many RDBMs, it is categorized by different topics, each topic contains many recipes. The recipes are well organized from most simple to more complex, so it takes you step by step to learn the details of each topic. Also there is a well documented description of queries. I like it a lot! So why I rated it 3/5 ? Because it is boring! And it has many repetitions of same ideas across recipes, and some recipes will not be understood unless you read first the previous recipe which makes it hard to randomly jump to a recipe. But in general it serves as a very good book to learn about SQL different topics and it use-cases in a "problem-solution" approach, with some amazing tricks which bring your 'Aha!' moments ;) ... Worth reading, especially that it won't take so much of your time; because you do not have to read each solution's description if you understand how the solution works.
Focused on the Oracle solutions. Great reference book that will teach you a lot of neat tricks.
great book for those who occasionally use sql, but don't want/need to learn it from head to toe.