Sql: 1999 Understanding Relational Language Components

Name: Sql: 1999 Understanding Relational Language Components
Price: 34.64 USD
Availability: InStock
ISBN: 9781558604568

ISBN-10: 1558604561

ISBN-13: 9781558604568

Edition: 2nd 2001

Authors: Jim Melton, Alan R. Simon

List price: $99.95

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $34.64

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Jim Melton and Alan R. Simon provide a thorough introduction to the new features of SQL-99 and explain how to implement these features in a wide range of applications.

Book details

List price: $99.95
Edition: 2nd
Copyright year: 2001
Publisher: Elsevier Science & Technology
Publication date: 5/30/2001
Binding: Paperback
Pages: 893
Size: 7.32" wide x 9.21" long x 1.50" tall
Weight: 3.388
Language: English

Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and is a representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative to ANSI INCITS Technical Committee H2 for Database and a US representative to ISO/IEC JTC1/SC32/WG3 (Database Languages). In addition, Jim has participated in the W3C's XML Query Working Group since 1998 and is currently co-Chair of that Working Group. He is also Chair of the WG's Full-Text Task Force, co-Chair of the Update Language Task Force, and co-editor of two XQuery-related specifications. He is the author of several SQL books.



Preface



Database and Technology Foundations



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 Multiple Tables: The Relational Operators



Advanced SQL Query Expressions



Constraints, Assertions, and Referential Integrity



Active Databases and Triggers



Accessing SQL from the Real World



Cursors



Privileges, Users, and Security



Transaction Management



Connections and Remote Database Access



Routines and Routine Invocation (Functions and Procedures)



Dynamic SQL



Call-Level Interface (CLI)



Diagnostics and Error Management



Internationalization Aspects of SQL:1999



Information Schema



A Look to the Future



Designing SQL:1999 Databases



An SQL:1999 Application Example



The SQL:1999 Annexes



Relevant Standards Bodies



Status Codes



The SQL Standardization Process


Index


About the Authors