SQL Functions Programmer's Reference

SQL Functions Programmer's Reference

2 (1 rating by Goodreads)
By (author)  , By (author)  , By (author)  , By (author)  , By (author) 

List price: US$39.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


Gives programmers two-in-one coverage, with both a "how-to" on SQL functions and a complete SQL functions reference - SQL is the standard language for database queries; this book's advanced coverage helps programmers write their own SQL functions - Covers both the internationally standardized SQL 99 functions and the hundreds of additional functions introduced by vendors, including the subtle variations required to successfully migrate or interoperate between vendor products - Covers the latest versions of the major relational database management system (RDMS) applications: Microsoft SQL Server, Oracle, IBM DB2, and MySQL
show more

Product details

  • Mixed media product | 790 pages
  • 188 x 233.7 x 48.3mm | 1,111.31g
  • New York, United States
  • English
  • 0764569015
  • 9780764569012

Back cover copy

SQL FunctionsSQL functions are special commands for manipulating data. The international SQL standard defines many functions implemented by all major RDBMS vendors. This comprehensive SQL functions reference enables you to quickly master SQL function data manipulation in any database.First, the book presents the basics you need to use standard SQL functions with any database. Then the expert authors take you into the core reference material for built-in and user-defined SQL functions in each major RDBMS product. Packed with examples, you'll immediately learn to apply standard functions and extend your power with functions you define.You'll learn all of this from a core author team from Perpetual Technologies, Inc. These experts have extensive experience with Oracle(R), SQL Server, Sybase, DB2(R), and MySQL(R), database design and management for some of the world's largest corporations and government agencies.What you will learn from this bookHow to cross-reference different SQL implementations and integrate data from different vendor productsWays to create custom functions using vendors' procedural extensionsNumerous SQL implementations, such as ANSI SQL, Oracle(R), Microsoft(R) SQL Server(R), Sybase, MySQL(R), IBM(R)DB2(R), and PostgreSQLHow the internationally standardized SQL 99 functions are implemented in various vendor-specific productsUser-defined functions built with proprietary procedural extensionsExpert guidance on moving from one RDBMS to anotherWho this book is forThis book is for the SQL programmer or software developer of any level who needs to effectively retrieve data from a relational database or integrate applications with RDBMS implementations.Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.
show more

Table of contents

Acknowledgments. Introduction. Chapter 1: Exploring Popular SQL Implementations. Chapter 2: Functions: Concept and Architecture. Chapter 3: Comparison of Built-in SQL Functions by Vendor. Chapter 4: SQL Procedural Extensions and User-Defined Functions. Chapter 5: Common ANSI SQL Functions. Chapter 6: Oracle SQL Functions. Chapter 7: IBM DB2 Universal Database (UDB) SQL Functions. Chapter 8: Microsoft SQL Server Functions. Chapter 9: 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. Appendix A: Built-in Function Cross-Reference Table. Appendix B: ANSI and Vendor Keywords. Appendix C: ANSI and Vendor Data Types. Appendix D: Database Permissions by Vendor. Appendix E: ODBC and Stored Procedures and Functions. Appendix F: JDBC and Stored Procedures/Functions. Glossary. Index.
show more

About Arie Jones

Arie Jones is a senior database administrator for Perpetual Technologies, Inc. (www.perptech.com). He holds a master's degree in physics from Indiana State University and also works as the chief Web architect/DBA for the USPFO for Indiana. Arie's main specialty is in developing .NET-based database solutions for the government. He and his wife and family live outside of Indianapolis, Indiana. Ryan Stephens is the president and CEO of Perpetual Technologies, Inc. (www.perptech.com), an Indianapolis-based IT firm specializing in database technologies. Ryan has been working with SQL and databases for 15 years and has held the positions of project manager, database administrator, and programmer/analyst. Ryan has been teaching database courses for local universities since 1997 and has authored several internationally published books on topics such as database design, SQL, database architecture, database administration, and Oracle. Ryan enjoys discovering new ways to optimize the use of technology to streamline business operations, as well as empowering others to do the same. Ryan and his wife live in Indianapolis with their three children. Ronald R. Plew is vice president and CIO for Perpetual Technologies, Inc. (www.perptech.com) in Indianapolis, Indiana. Ron is a Certified Oracle Professional. He has coauthored several internationally published books on SQL and database technology. Ron is also an adjunct professor for Vincennes University in Indiana, where he teaches SQL and various database courses. Ron holds a bachelor of science degree in business administration/management from Indiana Institute of Technology out of Fort Wayne, Indiana. Ron recently retired from the Indiana Army National Guard, where he served as a programmer/analyst. His hobbies include automobile racing, chess, golf, and collecting Indy 500 memorabilia. Ron resides in Indianapolis with his wife Linda. Bob Garrett is the software development manager at Perpetual Technologies, Inc. (www.perptech.com). Bob's languages of preference are Java, C++, and English. He has extensive experience integrating applications with relational databases. Bob has a degree in computer science and mathematics from Purdue University, and lives with his wife and daughter near Indianapolis. Alex Kriegel is a professional database systems analyst with a major manufacturing firm in Oregon. He has more than 10 years of database experience working with Microsoft SQL Server, Oracle, DB2, Sybase, and PostgreSQL both as developer and DBA. Alex has a bachelor of science degree in solid-state physics from State Polytechnic Institute of Minsk, Belarus, and has earned the Microsoft Certified Solution Developer (MCSD) accreditation. He is the author of SQL Bible. Alex wrote the first draft of approximately two-thirds of this book.
show more

Rating details

1 ratings
2 out of 5 stars
5 0% (0)
4 0% (0)
3 0% (0)
2 100% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X