SQL Cookbook

Description

*******************************************************************************

SQL Cookbook

*******************************************************************************



-------------------------------------------------------------------------------

General Information

-------------------------------------------------------------------------------

Type.................: Ebook

Part Size............: 690,164 bytes









-------------------------------------------------------------------------------

Post Information

-------------------------------------------------------------------------------

Posted by............: ~tqw~



-------------------------------------------------------------------------------

Release Notes

-------------------------------------------------------------------------------

You need a quick SQL query. Not a lecture. You need SQL Cookbook. There are

160-plus reliable, easy-to-adapt recipes here, for everything from simple record

retrieval to data warehousing. Each one?s presented and explained as simply and

concisely as humanly possible. And (except for one ?bonus? chapter) everything?s

cross-platform: tested for DB2 v. 8, Oracle 10g, PostgreSQL 8, SQL Server 2005,

and MySQL 5.



Want to sort results by substrings? Combine related rows from multiple tables?

Insert a new record? Copy a table definition? List tables in a schema? Extract

initials from a name? Parse an IP address? Compute a running total? Determine

next year?s quarter start/end dates? Fill in missing values in a range? Rank

your results? Pivot result sets into a single row? Build hierarchical queries?

Don?t waste time figuring it out from scratch: It?s all right here.



Are you an SQL novice, journeyman, expert or a non-SQL programmer? If you are,

then this book is for you! Author Anthony Molinaro, has done an outstanding job

of writing a practical book that gives you the reader, a glimpse of what can be

done using SQL outside of what is considered the typical SQL problem domain..

Molinaro, begins by introducing very simple queries. Then, the author introduces

recipes for sorting query results. Next, he introduces recipes for combining

data from multiple tables. The author then introduces recipes for inserting,

updating, and deleting data, respectively. He continues by introducing recipes

for getting at your database metadata. Then, the author introduces recipes for

manipulating strings. Next, he introduces recipes for common number crunching.

He also deals with data arithmetic. The author continues by showing you recipes

for some of the most common date operations you will encounter in a typical work

day. Then, he introduces recipes for identifying values in ranges, and for

creating ranges of values. Next, the author introduces recipes that are crucial

for everyday development and yet sometimes slip through the cracks. He also

introduces queries typically used in warehousing or generating complex reports.

The author continues by introducing you to hierarchical recipes. Finally, the

author focuses on vendor-specific solutions. In this most excellent cookbook,

you will find a collection of common SQL problems and their solutions that

you'll find helpful in your day-to-day work. More importantly, this cookbook

will help you take your SQL skills to the next level.



Table of Contents

1 Retrieving records 1

2 Sorting query results 14

3 Working with multiple tables 28

4 Inserting, updating, deleting 62

5 Metadata queries 83

6 Working with strings 95

7 Working with numbers 155

8 Date arithmetic 188

9 Date manipulation 219

10 Working with ranges 298

11 Advanced searching 325

12 Reporting and warehousing 365

13 Hierarchical queries 441

14 Odds 'n' ends 471

A Window function refresher 525

B Rozenshtein revisited 551



Product Details



* ISBN: 0596009763

* ISBN-13: 9780596009762

* Format: Paperback, 595pp

* Publisher: O'Reilly Media, Incorporated

* Pub. Date: December 2005



-------------------------------------------------------------------------------

Install Notes

-------------------------------------------------------------------------------

CHM File

$$ Buy "SQL Cookbook" on Amazon $$

Download links for "SQL Cookbook":


How to Download
You may need eMule or Bittorrent to download ebook torrents or emule links.

Report Dead Link
Please leave a comment to report dead links, so that someone else may update new links.

1. Ebooks list page : 1544
2. The Anarchy Cookbook! (The Anarchist Cookbook!) uncensored versi
3. [share_ebook] C Cookbook
4. C Cookbook
5. CSS Cookbook
6. ADO Dot NET Cookbook
7. C.plus.plus.Cookbook
8. SQL Cookbook
9. ASP dot NET Cookbook
10. C# 3.0 Cookbook
11. C plus plus Cookbook
12. C Cookbook
13. ASP.dot.NET.Cookbook
14. PHP Cookbook
15. ADO.NET 3.5 Cookbook
16. PHP Cookbook