SQL 1999
Understanding Relational Language Components
Résumé
Features
- Gives authoritative coverage from an expert team that includes the editor of the SQL-92 and SQL:1999 standards.
- Provides a general introduction to SQL that helps you understand its constituent parts, history, and place in the realm of computer languages.
- Explains SQL:1999's more sophisticated features, including advanced value expressions, predicates, advanced SQL query expressions, and support for active databases.
- Explores key issues for programmers linking applications to SQL databases.
- Provides guidance on troubleshooting, internationalization, and changes anticipated in the next version of SQL.
- Contains appendices devoted to database design, a complete SQL:1999 example, the standardization process, and more.
Contents
- Preface
- Database and technology foundatiojns
- Introduction to SQL: 1999
- Basic table creation and data manipulation
- Basic data definition language (DDL)
- Values, basic functions, and expressions
- Advanced value expressions: CASE, CAST, and row value expressions
- Predicates
- Working with multiples tables: the relatioanl operators
- Advanced SQL query expressions
- Constaint, assertions, and referential integrity
- Active database and triggers
- Accessing SQL from the real world
- Cursors
- Privileges, users, and security
- Transaction management
- Connections and remote database access
- Routines and rotine invocation (functions and procedures)
- Dynamic SQL
- Call-level interface (cli)
- Diagnostic and error management
- Internationalization aspects of SQL: 1999
- Information schema
- A look to the future
- Appendixes
- Index
L'auteur - Jim Melton
Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative to ANSI NCITS Technical Committee H2 for Database and a US representative to ISO/IEC JTCI/SC32/WG3. He was the editor of SQL-92 and the recently published SQL:1999 suite of standards, and is the author of several SQL books.
L'auteur - Alan R. Simon
Alan R. Simon is a leading authority on data warehousing and database technology. He is the author of 26 books, including SQL:1999-Understanding Relational Language Components and currently provides data-warehousing-related consulting services.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Morgan Kaufmann |
Auteur(s) | Jim Melton, Alan R. Simon |
Parution | 01/06/2001 |
Nb. de pages | 895 |
Format | 18,7 x 23,4 |
Couverture | Broché |
Poids | 1534g |
Intérieur | Noir et Blanc |
EAN13 | 9781558604568 |
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