|
|
Document Details
SQL Functions Programmers Reference
Description: 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
| Name |
SQL Functions Programmers Reference |
| Keywords |
|
| Filesize |
2.64 MB |
| Google Ads |
|
| Filetype |
rar (Mime Type: application/x-rar) |
| Creator |
Everybody |
| Created On: |
11/11/2007 00:00 |
| Viewers |
Everybody |
| Maintained by |
Zinho |
| Hits |
165 Hits |
| Last updated on |
12/31/1969 16:00 |
| Homepage |
|
| CRC Checksum |
|
| MD5 Checksum |
|
You need to login to download texts/tools. Register here, it's fast and free!
|
|
|
