SQL 1999
Understanding Relational Language Components
895 pages, parution le 01/06/2001
Résumé
This book is the best way to make the leap from SQL-92 to
SQL:1999, but it is much more than just a simple bridge
between the two. The latest from celebrated SQL experts Jim
Melton and Alan Simon, SQL:1999 is a comprehensive,
eminently practical account of SQL's latest incarnation and
a potent distillation of the details required to put it to
work. Written to accommodate both novice and experienced
SQL users, SQL:1999 focuses on the language's
capabilities, from the basic to the advanced, and the ways
that real applications take advantage of them. Throughout,
the authors illustrate features and techniques with clear
and often entertaining references to their own custom
database, which can be downloaded from the companion Web
site.
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
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
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
