A guide to the SQL standard : a user's guide to the standard database language SQL / C.J. Date with Hugh Darwen.
By: Date, C. J
.
Contributor(s): Darwen, Hugh
.
Material type: ![materialTypeLabel](/opac-tmpl/lib/famfamfam/BK.png)
![](/opac-tmpl/bootstrap/images/filefind.png)
![](/opac-tmpl/bootstrap/images/filefind.png)
Item type | Current library | Call number | Copy number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|---|
General Lending | MTU Bishopstown Library Lending | 005.756 (Browse shelf(Opens below)) | 1 | Available | 00071015 |
Browsing MTU Bishopstown Library shelves, Shelving location: Lending Close shelf browser (Hides shelf browser)
Enhanced descriptions from Syndetics:
franca database management; it provides the basis for systems interoperability, application portability, client/server operation, distributed database, and more, and is supported by just about every DBMS on the market today. SQL2 - or, to give it its official name, the International Standard Database language SQL (1992) - represents a major set of extensions to the earlier SQL standard. For a start, the new specification is well over 600 pages, compared with less than 100 for the original version. No database professional can afford to ignore it. Features *Thorough revision of the official ANSI standard for SQL. * Covers all important new SQL2 features including extensive integrity support, powerful new operators, national and international character data support and comprehensive date and time support. * Continues the tradition of careful, clear, and accurate explanations of complex technical material Features New to this Edition * Covers extensive integrity support, powerful new operators, national and international character data support, all features of SQL2; comprehensive date and time support and clear explanation of the complexitites of Dynamic SQL, all features of SQL2. * P
Includes bibliographical references (pages 509-512) and index.
Part I: Introduction -- Why SQL is Important -- An Overview of SQL -- Part II: Some Preliminaries -- Basic Language Elements -- Catalogs and Schemas -- Connections, Sessions and Transactions -- Binding Styles -- Part III: Data Definition and Manipulation -- Scalar Objects, Operators and Expressions -- Data Definition: Domains and Base Tables -- Data Manipulation: Noncursor Operations -- Data Manipulation: Cursor Operations -- Table Expressions -- Conditional Expressions -- Views -- Part IV: Data Control -- Integrity -- Security -- Part V: Advanced Topics -- Missing Information and Nulls -- Dates and Times -- Temporary Tables -- Character Data -- Dynamic SQL -- Information Schemas -- Exception Handling -- Call-Level Interface.
Table of contents provided by Syndetics
- (Most chapters begin with "Introduction".)
- I Introduction
- 1 Why Sql is Important
- Background
- Is a Standard Desirable?
- 2 An Overview of Sql
- Introduction
- Data Definition
- Data Manipulation
- Cursor Operations
- Views
- Security and Integrity
- Recovery and Concurrency
- Schemas and Catalogs
- Sessions and Connections
- II Some Preliminaries
- 3 Basic Language Elements
- SQL Language Characters
- Tokens and Separators
- Key Words
- Identifiers and Names
- Scope of Names
- Notation
- 4 Catalogs and Schemas
- The SQL-Environment
- Catalogs
- Schemas
- 5 Connections, Sessions, and Transactions
- SQL-Agents SQL-Connections SQL-Sessions
- SQL-Transactions
- 6 Binding Styles
- Introduction
- The Module Language
- Embedded Sql
- Direct Sql
- III Data Definition and Manipulation
- 7 Scalar Objects, Operators, and Expressions
- Introduction
- Data Types
- Literals
- Scalar Operators and Functions
- Aggregate Functions
- Assignments and Comparisons
- 8 Data Definition: Domains and Base Tables
- Introduction
- Domains
- Base Tables
- 9 Data Manipulation: Noncursor Operations
- Introduction
- Single-Row Select
- Insert
- Searched Update
- Searched Delete
- 10 Data Manipulation: Cursor Operations
- Introduction
- Cursors
- Cursor-Based Manipulation Statements
- A Comprehensive Example (Module Version)
- A Comprehensive Example (Embedded SQL Version)
- 11 Table Expressions
- Introduction
- Join Expressions
- Table References
- Unions, Differences, and Intersections
- Table Primaries
- Select Expressions
- Derived Table Column Names
- 12 Conditional Expressions
- Introduction
- General Remarks
- Comparison Conditions
- Between and Like Conditions
- In and Match Conditions
- All-or-any Conditions
- Exists Conditions
- Unique Conditions
- A Final Remark
- 13 Views
- Introduction
- Data Definition Operations
- Data Manipulation Operations
- The Check Option
- IV Data Control
- 14 Integrity
- Introduction
- Domain Constraints
- General Constraints
- Base Table and Column Constraints
- Foreign Keys
- Deferred Constraint Checking
- 15 Security
- Introduction
- Authorization Identifiers
- Privileges and Access Rules
- Grant and Revoke
- The Grant Option
- Restrict Vs Cascade
- V Advanced Topics
- 16 Missing Information and Nulls
- Introduction
- Effect of Nulls on Scalar Expressions
- Effect of Nulls on Conditional Expressions
- Effect of Nulls on Table Expressions
- Effect of Nulls on Integrity Constraints
- A Recommendation
- 17 Dates and Times
- Introduction
- Data Types
- Literals
- Time Zones
- Data Conversion
- Scalar Operators and Functions
- Assignments and Comparisons
Excerpt provided by Syndetics
Author notes provided by Syndetics
C. J. Date is an independent author, lecturer, researcher, and consultant specializing in relational database systems, a field he helped pioneer. Among other projects, he was involved in technical planning for the IBM products SQL/DS and DB2. He is best known for his books, in particular, An Introduction to Database Systems (7th edition, Addison-Wesley, 2000), the standard text in the field, which has sold well over half a million copies worldwide. Mr. Date is widely acknowledged for his ability to explain complex technical material in a clear and understandable fashion.
Hugh Darwen has been involved in software development since 1967 as an employee of IBM United Kingdom, Ltd. He has been active in the relational database arena since 1978. He was one of the chief architects and developers of an IBM relational product called Business System 12, a product that faithfully embraced the principles of the relational model. He has been an active participant in the development of SQL international standards since 1988.
0201964260AB04062001