Wrox - SQL Functions Programmers Reference

This book is a complete SQL functions reference for all of the major RDBMS vendors in today’s market. Structured Query Language (SQL) is the standard language used to communicate with relational databases. SQL is a simple, English-like (yet powerful) language that allows the database user to effectively store, manipulate, and retrieve data from a database. Among the most robust features of SQL is its ability to mine data from a database and flexibly display that data in a format that suits the user’s exact needs. SQL functions comprise a huge part of the SQL language and play a critical role in determining what data is retrieved, how it is retrieved, and how it is to be displayed. Once you learn to query a database with SQL, learning how to intelligently use functions will allow you to quickly master the art of retrieving data from any relational database. This book will contribute to your mastery of effective data retrieval using SQL, regardless of the vendor implementation you are using.

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.

If you have purchased this book, thank you. We know that you will find this book to be an invaluable reference for SQL functions for all the major players in the RDBMS market. If you are considering this book, please take a minute to flip through this reference, making note of the reference material, the trailing chapters describing real-world practical applications of SQL functions, and particularly Appendix A, which cross-references all the functions contained in this book by vendor. You should find this book to be thorough and inclusive of all functions currently available in each of the major RDBMS vendor implementations.