skip to content
A guide to the SQL standard : a user's guide to the standard database language SQL Preview this item
ClosePreview this item
Checking...

A guide to the SQL standard : a user's guide to the standard database language SQL

Author: C J Date; Hugh Darwen
Publisher: Reading, Mass. : Addison-Wesley, 1997
Edition/Format:   Print book : English : 4. editionView all editions and formats
Database:WorldCat
Summary:
A tutorial guide and a reference that describes the official standard version of the database language SQL. The five major parts include Introduction, Some preliminaries, Data definition and manipulation, Data control and Advanced topics.
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Document Type: Book
All Authors / Contributors: C J Date; Hugh Darwen
ISBN: 0201964260 9780201964264
OCLC Number: 464448560
Notes: På omslaget: Covers CLI and PSM
Description: xxii,522 s.
Contents: (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. 18. Temporary Tables. Introduction. Type 1: "Declared" Temporary Tables. Types 2 and 3: "Created" Temporary Tables. 19. Character Data. Introduction. Properties of Character Strings. Character Sets and Collations. Data Types. Literals. Scalar Operators and Functions. Assignments and Comparisons. Character Sets For Identifiers. 20. Dynamic Sql. Introduction. What is The Problem? Statement Preparation and Execution. SQL Descriptor Areas. Cursor Operations. Session Defaults. 21. Information Schemas. Introduction. Information Schema Tables. 22. Exception Handling. Status Codes. The Diagnostics Area. 23. Call-Level Interface. Introduction. What is The Problem? CLI Routines and Parameters. CLI Resources and Related Matters. Statement Preparation and Execution. CLI Descriptor Areas. Placeholders. Retrieval Operations. Exception Handling. A Sample "SQLCLIH" File. A Sample CLI Application. APPENDIXES. A. An Sql Grammar. Introduction. Sessions, Connections, and Transactions. Data Definition. Modules. Data Manipulation. Table Expressions. Conditional Expressions. Constraints. Dynamic Sql. Scalar Expressions. Get Diagnostics. Miscellaneous. B. Language Levels and Conformance. Introduction. Intermediate Sql. Entry Sql. SQL Flagger. C. Sql/92 Vs Sql/89. Introduction. Extensions. Incompatibilities. Deprecated Features. D. Some Outstanding Issues. Introduction. The Issues. E. Persistent Stored Modules. Introduction. Overview. Routines, Modules, and Schemas. Type Precedence. Subject Routine Determination. SQL Control Statements. Exception Handling. External Routines. Miscellaneous Topics. F. An Overview of Sql3. Introduction. Data Definition and Manipulation. Functions and Operators. Integrity. Security. Transactions. G. References and Bibliography. 0201964260T04062001

Abstract:

A comprehensive treatment of SQL, this edition of the text is revised and updated to cover all current components and features of SQL since 1992.  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/464448560> # A guide to the SQL standard : a user's guide to the standard database language SQL
    a schema:CreativeWork, schema:Book ;
    library:oclcnum "464448560" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/836680031#Place/reading_mass> ; # Reading, Mass.
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/mau> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/836680031#Topic/edb_standarder> ; # Edb-standarder
    schema:about <http://id.worldcat.org/fast/1102869> ; # SQL (Computer program language)
    schema:about <http://experiment.worldcat.org/entity/work/data/836680031#Topic/database> ; # Database
    schema:about <http://id.worldcat.org/fast/1085675> ; # Query languages (Computer science)
    schema:about <http://experiment.worldcat.org/entity/work/data/836680031#Topic/sql> ; # SQL
    schema:bookEdition "4. edition" ;
    schema:bookFormat bgn:PrintBook ;
    schema:contributor <http://viaf.org/viaf/12463739> ; # Hugh Darwen
    schema:contributor <http://viaf.org/viaf/101729193> ; # C. J. Date
    schema:datePublished "1997" ;
    schema:description "A tutorial guide and a reference that describes the official standard version of the database language SQL. The five major parts include Introduction, Some preliminaries, Data definition and manipulation, Data control and Advanced topics." ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/836680031> ;
    schema:inLanguage "en" ;
    schema:name "A guide to the SQL standard : a user's guide to the standard database language SQL" ;
    schema:productID "464448560" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/464448560#PublicationEvent/reading_mass_addison_wesley_1997> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/836680031#Agent/addison_wesley> ; # Addison-Wesley
    schema:workExample <http://worldcat.org/isbn/9780201964264> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/464448560> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/836680031#Agent/addison_wesley> # Addison-Wesley
    a bgn:Agent ;
    schema:name "Addison-Wesley" ;
    .

<http://experiment.worldcat.org/entity/work/data/836680031#Place/reading_mass> # Reading, Mass.
    a schema:Place ;
    schema:name "Reading, Mass." ;
    .

<http://id.worldcat.org/fast/1085675> # Query languages (Computer science)
    a schema:Intangible ;
    schema:name "Query languages (Computer science)" ;
    .

<http://id.worldcat.org/fast/1102869> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)" ;
    .

<http://viaf.org/viaf/101729193> # C. J. Date
    a schema:Person ;
    schema:familyName "Date" ;
    schema:givenName "C. J." ;
    schema:name "C. J. Date" ;
    .

<http://viaf.org/viaf/12463739> # Hugh Darwen
    a schema:Person ;
    schema:familyName "Darwen" ;
    schema:givenName "Hugh" ;
    schema:name "Hugh Darwen" ;
    .

<http://worldcat.org/isbn/9780201964264>
    a schema:ProductModel ;
    schema:isbn "0201964260" ;
    schema:isbn "9780201964264" ;
    .

<http://www.worldcat.org/title/-/oclc/464448560>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/464448560> ; # A guide to the SQL standard : a user's guide to the standard database language SQL
    schema:dateModified "2015-05-05" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.