Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL Cookbook

Buy
SQL Cookbook, 9780596009762 (0596009763), O'Reilly, 2005

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.
(HTML tags aren't allowed.)

PowerPoint 2007 All-in-One Desk Reference For Dummies (Computer/Tech)
PowerPoint 2007 All-in-One Desk Reference For Dummies (Computer/Tech)
7 books in 1—your key to PowerPoint success!

Your one-stop guide to perfect presentations with PowerPoint 2007

Everybody uses PowerPoint, right? How can you make your presentations pop? Check this handy reference with its easy-to-use minibooks! Once you get going with all the cool new...

Arthroscopic and Endoscopic Spinal Surgery: Text and Atlas
Arthroscopic and Endoscopic Spinal Surgery: Text and Atlas
The term “minimally invasive spinal surgery” was coined in early 1990 following publication of the first edition of this text entitled Arthroscopic Microdiscectomy: Minimal Intervention in Spinal Surgery, and subsequent establishment of the International Society for Minimal Intervention in Spinal Surgery (ISMISS) under...
Proceedings of the 20th Congress of the International Ergonomics Association (IEA 2018): Volume IX: Aging, Gender and Work, Anthropometry, Ergonomics ... in Intelligent Systems and Computing)
Proceedings of the 20th Congress of the International Ergonomics Association (IEA 2018): Volume IX: Aging, Gender and Work, Anthropometry, Ergonomics ... in Intelligent Systems and Computing)

This book presents the proceedings of the 20th Congress of the International Ergonomics Association (IEA 2018), held on August 26-30, 2018, in Florence, Italy. By highlighting the latest theories and models, as well as cutting-edge technologies and applications, and by combining findings from a range of disciplines including...


How to Improve the Results of Peripheral Nerve Surgery (Acta Neurochirurgica Supplement)
How to Improve the Results of Peripheral Nerve Surgery (Acta Neurochirurgica Supplement)
All over the world research is being undertaken to improve the treatment outcome of peripheral nerve lesions. Questions over questions arise. Is autologous nerve grafting still the gold standard for bridging defects? Have alternative techniques for overcoming defects of peripheral nerves reached a level to replace...
Next Generation Transport Networks: Data, Management, and Control Planes
Next Generation Transport Networks: Data, Management, and Control Planes

Covering past, present and future transport networks using three layered planes written by experts in the field.

Targeted at both practitioners and academics as a single source to get an understanding of how transport networks are built and operated

Explains technologies enabling the next generation transport...

Xml: A Primer
Xml: A Primer

You spend hours designing and formatting your Web pages to look just right, but when users log on to your site -- wham! -- all your carefully formatted data is scattered helter-skelter across the page! Now theres no need to curse the quirks of HMTL. Instead, skip over all those cumbersome and redundant HTML tags and jump to the head of the...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy