SQL Functions Programmer’s Reference

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