



Author(s) : Arie Jones, Ryan K. Stephens, Ronald R. Plew, Robert F. Garrett, Alex Kriegel
Publisher : Wrox
Year : Apr 2005
ISBN 10 : 0764569015
ISBN 13 : 9780764569012
Language : English
Pages : 790
File type : PDF
Size : 2.7 MB
This book is a complete SQL functions reference for all of the major RDBMS vendors in today’s market. The SQL implementations covered in this book include ANSI SQL, Oracle, Microsoft SQL Server, Sybase, IBM Universal Database (UDB) DB2, MySQL, and PostgreSQL. As a SQL programmer, you will find that there is a growing need to effectively use SQL functions, yet there are few resources to serve as an aid. You will also encounter the need to cross-reference different SQL implementations, at times having to integrate data between, say, Oracle and SQL Server.
Migrations of data from one implementation to another is also very common in data warehousing environments, and as organizations make the commitment to go with another vendor’s relational database management system (RDBMS) to better support evolving business needs. This book is the necessary tool to facilitate expedient function referencing, cross-referencing between implementations, creating userdefined functions (UDFs), and providing tips and examples for applying the use of functions to real-world data-retrieval situations.
This book is for the SQL programmer, and any software developer who has a need to effectively retrieve data from a relational database, or to integrate applications with RDBMS implementations. Database administrators and other database users will also discover great value. This book is for readers of all levels, and has been organized in an easy-to-understand format that allows quick search and reference. This book is packed with realistic examples, allowing the reader to immediately apply SQL functions concepts to the job at hand.
Although the intent of this book is not to teach you SQL, the introductory chapters we have provided serve as an introduction to the world of SQL, explaining basic SQL concepts and describing how to use SQL to query a database, either with or without the use of functions. The trailing chapters of this book show numerous applications of SQL functions in the modern database world.
TABLE OF CONTENT:
Chapter 01 - Exploring Popular SQL Implementations
Chapter 02 - Functions: Concept and Architecture
Chapter 03 - Comparison of Built-in SQL Functions by Vendor
Chapter 04 - SQL Procedural Extensions and User-Defined Functions
Chapter 05 - Common ANSI SQL Functions
Chapter 06 - Oracle SQL Functions
Chapter 07 - IBM DB2 Universal Database (UDB) SQL Functions
Chapter 08 - Microsoft SQL Server Functions
Chapter 09 - Sybase ASE SQL Built-In Functions
Chapter 10 - MySQL Functions
Chapter 11 - PostgreSQL Functions
Chapter 12 - ANSI SQL User-Defined Functions
Chapter 13 - Creating User-Defined Functions in Oracle
Chapter 14 - Creating User-Defined Functions with IBM DB2 UDB
Chapter 15 - Creating User-Defined Functions Using Microsoft SQL Server
Chapter 16 - Creating User-Defined Functions in Sybase SQL
Chapter 17 - Creating User-Defined Functions in MySQL
Chapter 18 - Creating User-Defined Functions in PostgreSQL
Chapter 19 - Reporting and Ad Hoc Queries
Chapter 20 - Using Functions for Migrating Data
Chapter 21 - Using Functions to Feed a Data Warehouse
Chapter 22 - Embedded Functions and Advanced Uses
Chapter 23 - Generating SQL with SQL and SQL Functions
Chapter 24 - SQL Functions in an Application
Chapter 25 - Empowering the Query with Functions and Views
Chapter 26 - Understanding the Impact of SQL Functions on Query and Database Performance
Chapter 27 - Useful Queries from the System Catalog
>> Download here <<
password:
ganelon

The Big Book of Being Rude
Jonathon Green, "The Big Book of Being Rude"
ISBN:0304363685
Pages: 384
PDF
With more than 7,000 zingers, the right crushing retort is always at hand!
No more thinking of an apt reply after it's too late: just store up a collection of choice rejoinders from over 1,000 ways to call somebody a fool and 600 ways to say someone's acting stupid. Pick from hundreds of little-known terms for know-it-alls, egotists, flatterers, and nags. Really want to hit below the belt?
Try a politically incorrect insult that zaps somebody for being too fat or thin, too young or old, or too socially unacceptable, sexually inept, or spiritually impoverished. So from now on, the weird, fussy, boring, loathsome and intolerable, or merely irritating had better watch out!
Homepage
[www.worldretailstore.com]
Download
[rapidshare.com]
12582 KB
[rapidshare.com]
12582 KB
[rapidshare.com]
12582 KB
[rapidshare.com]
12058KB