SQL Cookbook
"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. ", 8404950, 0596009763, 9780596009762

Kurs