+612 9045 4394
SQL : 1999 - Understanding Relational Language Components - Jim Melton


1999 - Understanding Relational Language Components

Paperback Published: 1st June 2001
ISBN: 9781558604568
Number Of Pages: 893

Share This Book:


or 4 easy payments of $54.99 with Learn more
Ships in 7 to 10 business days

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.

* 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.

Database and Technology Foundationsp. 1
Introduction to SQL:1999p. 23
Basic Table Creation and Data Manipulationp. 59
Basic Data Definition Language (DDL)p. 83
Values, Basic Functions, and Expressionsp. 113
Advanced Value Expressions: CASE, CAST, and Row Value Expressionsp. 165
Predicatesp. 179
Working with Multiple Tables: The Relational Operatorsp. 223
Advanced SQL Query Expressionsp. 265
Constraints, Assertions, and Referential Integrityp. 355
Active Databases and Triggersp. 395
Accessing SQL from the Real Worldp. 411
Cursorsp. 447
Privileges, Users, and Securityp. 469
Transaction Managementp. 511
Connections and Remote Database Accessp. 533
Routines and Routine Invocation (Functions and Procedures)p. 541
Dynamic SQLp. 569
Call-Level Interface (CLI)p. 625
Diagnostics and Error Managementp. 683
Internationalization Aspects of SQL:1999p. 701
Information Schemap. 715
A Look to the Futurep. 741
Designing SQL:1999 Databasesp. 747
An SQL:1999 Application Examplep. 757
The SQL:1999 Annexesp. 775
Relevant Standards Bodiesp. 817
Status Codesp. 825
The SQL Standardization Processp. 833
Indexp. 845
About the Authorsp. 895
Table of Contents provided by Blackwell. All Rights Reserved.

ISBN: 9781558604568
ISBN-10: 1558604561
Series: Morgan Kaufmann Series in Data Management Systems
Audience: General
Format: Paperback
Language: English
Number Of Pages: 893
Published: 1st June 2001
Country of Publication: US
Dimensions (cm): 23.32 x 18.64  x 4.24
Weight (kg): 1.5
Edition Number: 2
Edition Type: Revised