• Author:
  • Gruber, Martin
• Subject:
  Computer Programming / Software Development
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  16/03/2000
• Price:
  $44.99
• <  Buy this book  >

Find the Explanation You Need--Quickly, Easily, Every Time

If you use SQL to program, administer, or query databases, SQL Instant Reference is an essential desktop resource. Inside, you'll find complete, alphabetical coverage of all SQL statements, plus detailed explanations of common statement elements. You also get a special section covering SQL99 and a glossary of relevant terms. No other SQL reference packs so much useful information into such a handy format.

Martin Gruber is a recognized SQL expert and is also the author of Understanding SQL and the soon-to-be-published Mastering SQL. He is a freelance writer, teacher, and consultant based in the San Francisco Bay Area.

Introduction.

Part I: Introduction to SQL.

SQL: An Overview.

The Fundamentals of SQL and Relational Databases.

A Relational Database Primer.

Joining Tables.

Basics of the SQL Language.

Overview of the SQL Standards.

Notable Features of Standard SQL.

Part II: SQL Statement Reference.

ALLOCATE CURSOR.

ALLOCATE DESCRIPTOR.

ALTER DOMAIN.

ALTER TABLE.

CLOSE.

COMMIT WORK.

CONNECT.

CREATE ASSERTION.

CREATE CHARACTER SET.

CREATE COLLATION.

CREATE DOMAIN.

CREATE SCHEMA.

CREATE TABLE.

CREATE TRANSLATION.

CREATE VIEW.

DEALLOCATE DESCRIPTOR.

DEALLOCATE PREPARE.

DECLARE CURSOR.

DECLARE LOCAL TEMPORARY TABLE.

DELETE.

DESCRIBE.

DISCONNECT.

DROP ASSERTION.

DROP CHARACTER SET.

DROP COLLATION.

DROP DOMAIN.

DROP SCHEMA.

DROP TABLE.

DROP TRANSLATION.

DROP VIEW.

EXECUTE.

EXECUTE IMMEDIATE.

FETCH.

GET DESCRIPTOR.

GET DIAGNOSTICS.

GRANT.

INSERT.

OPEN.

PREPARE.

REVOKE.

ROLLBACK.

SELECT.

SET CATALOG.

SET CONNECTION.

SET CONSTRAINTS MODE.

SET DESCRIPTOR.

SET NAMES.

SET SCHEMA.

SET SESSION AUTHORIZATION.

SET TIME ZONE.

SET TRANSACTION.

UPDATE.

Part III: Common Elements.

Aggregate Functions.

Authorization IDs.

CASE Expressions.

CAST Expressions.

Collations.

Constraints.

Datatypes.

Datetime Value Functions.

Descriptor Areas.

Numeric Value Functions.

Predicates.

Row and Table Value Constructors.

String Value Functions.

Subqueries.

Value Expressions.

Part IV:

Chapter 1: SQL99: An Overview.

The Structure of the Standard andConformance Levels.

New Types of Data.

Extensions to SQL Statements.

Programmatic Extensions to SQL.

A Quick Overview of Object-OrientedConcepts.

Integrating Objects into the RelationalWorld.

Summary.

Chapter 2: Core SQL99.

What Is Core?

Distinct User-Defined Datatypes (UDTs).

Summary.

Appendix A: Mapping SQL to Other Lanuages.

Ada.

C/C++.

COBOL.

Fortran.

MUMPS.

Pascal.

PL/I.

Appendix B: Specification of the Module Language.

Overview.

Syntax.

Appendix C:Specification of Dynamic SQL.

Appendix D: SQL Linguistic Definitions and Conventions.

Identifiers.

SQL Keywords.

Appendix E: Upgrade Path from SQL92 to Core SQL99.

Core SQL99 Features.

Appendix F: Error Codes.

SQLCODE.

SQLSTATE.

Appendix G: Glossary.

Index.