SQL Functions Programmer's Reference
Arie Jones, Ryan K. Stephens, Ronald R. Plew, Robert F. Garrett, Alex Kriegel - Collection Programmer's reference
Résumé
- 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
L'auteur - Arie Jones
Arie Jones dirige une équipe d'experts en planification, conception, développement et gestion des environnements de bases de données et d'applications.
L'auteur - Ryan K. Stephens
Ryan Stephens et Ron Plew spécialisés dans les technologies de bases de données. Ils ont écrit plus d'une douzaine de livres sur Oracle, SQL et la conception de bases de données.
L'auteur - Ronald R. Plew
Ryan Stephens et Ron Plew spécialisés dans les technologies de bases de données. Ils ont écrit plus d'une douzaine de livres sur Oracle, SQL et la conception de bases de données.
L'auteur - Robert F. Garrett
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.
L'auteur - Alex Kriegel
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.
Sommaire
- 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
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Wrox Press |
Auteur(s) | Arie Jones, Ryan K. Stephens, Ronald R. Plew, Robert F. Garrett, Alex Kriegel |
Collection | Programmer's reference |
Parution | 18/05/2005 |
Nb. de pages | 760 |
Format | 19 x 23,5 |
Couverture | Broché |
Poids | 1140g |
Intérieur | Noir et Blanc |
EAN13 | 9780764569012 |
ISBN13 | 978-0-7645-6901-2 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse