- Series: Programmer to Programmer
- Paperback: 790 pages
- Publisher: Wrox; 1 edition (April 29, 2005)
- Language: English
- ISBN-10: 0764569015
- ISBN-13: 978-0764569012
- Product Dimensions: 7.4 x 1.8 x 9.2 inches
- Shipping Weight: 2.4 pounds
- Average Customer Review: 6 customer reviews
- Amazon Best Sellers Rank: #677,781 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
SQL Functions Programmer's Reference (Programmer to Programmer) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Garth Brooks: The Anthology Part 1 | Limited Edition
A great gift for country music fans, The Anthology Part 1 includes CDs containing the music of Garth's first five years, and behind-the-scenes photographs and stories never before made public. Learn more
From the Back Cover
SQL 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®, SQL Server, Sybase, DB2®, and MySQL®, database design and management for some of the world's largest corporations and government agencies.
What you will learn from this book
- How to cross-reference different SQL implementations and integrate data from different vendor products
- Ways to create custom functions using vendors' procedural extensions
- Numerous SQL implementations, such as ANSI SQL, Oracle®, Microsoft® SQL Server®, Sybase, MySQL®, IBM®DB2®, and PostgreSQL
- How the internationally standardized SQL 99 functions are implemented in various vendor-specific products
- User-defined functions built with proprietary procedural extensions
- Expert guidance on moving from one RDBMS to another
Who this book is for
This 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.
About the Author
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
I certainly would caution anyone to remember that this is a reference book. Do not try to read through this from cover to cover. You may skim through a lot of the sections to see what is available but I would not flip through it more than that. It is best used for getting what you need and getting out and back to the keyboard.
I suppose it could be a book for anyone from beginner to expert since it is just a function reference. If you are not able to easily access the internet to look up a function quickly or do not have the BOL installed for some reason then this is an adequate alternative.
Yes, they even explain the "proper" way to pronounce SQL (SEE-kwuhl). Only recruiters, COOs, and Jr developers say Es-Queue-El. The only thing more annoying than that is someone using a GUID as a primary key. ;)
There were small annoyances here and there:
For example, I find it strange that authors thought it necessary to give their version of pronunciation ":(otherwise known as SQL and pronounced "SEE-kwul") " for what is clearly not a beginner book; and I pronounce it "ess-que-ell" as many of my colleagues do)
Same goes for the first few chapters where authors have chosen to show examples of a basic queries, connect to database syntax etc. UNIX shell function example (p.14) was rather a dubious choice - why not C? VB? Java? Perl? Most database application developers are not familiar with the shell scripts, and could not care less.
It really would help me if the book covered creation of the user defined functions with Java and .NET (available in Oracle, DB2 UDB, PostgreSQL (Java), MSSQL Server, IBM DB2 UDB (.Net/C#); the book only covers Sybase where function created in Java 1.1... Reporting issues (chapter 19) seem torn out of some other book, and badly fitted into SQL Functions...The subject of Regular Expressions was hardly paid any attention, save for the fact that such thing does exist; MSSQL Server, for instance, provides access to OLE interface of its scripting engine Regex implementation. On the other hand, I was delighted to see PostgreSQL included.