OReilly SQL Cookbook Dec 2005 eBook
You know the rudiments of the SQL query language, yet you feel
you arent taking full advantage of SQLs expressive power.
Youd like to lea how to do more work with SQL inside the
database before pushing data across the network to your
applications. Youd like to take your SQL skills to the next
Lets face it, SQL is a deceptively simple language to lea,
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. Youll lea
Window functions, arguably the most significant enhancement
to SQL in the past decade. If youre not using these, youre
Powerful, database specific features such as SQL Servers
PIVOT and UNPIVOT operators, Oracles MODEL clause, and
Pivoting rows into columns, reverse pivoting columns into
rows, using pivoting to facilitate inter row calculations, and
Bucketization, and why you should never use that term in
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
The technique of walking a string, which allows you to use
SQL to parse through the characters, words, or delimited
Written in OReillys popular Problem/Solution/Discussion
style, the SQL Cookbook is sure to please. Anthonys 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 whats still available of our days." The SQL
Cookbook moves quickly from problem to solution, saving you
time each step of the way.
amazon/exec/obidos/tg/detail/ /0596009763/
BUY OReilly SQL Cookbook Dec 2005 eBook 10$
TAGS buy OReilly SQL Cookbook Dec 2005 eBook, order OReilly SQL Cookbook Dec 2005 eBook, low price OReilly SQL Cookbook Dec 2005 eBook
Niciun comentariu:
Trimiteți un comentariu