 SQL Instant Reference, 2nd Edition
ISBN: 978-0-7821-2539-9
Paperback
388 pages
March 2000
US $29.99
 Add to Cart
This price is valid for United States. Change location to view local pricing and availability. This is a Print-on-Demand title. It will be printed specifically to fill your order. Please allow an additional 1-2 days delivery time for paperbacks, and 3-5 days for hardcovers. The book is not returnable.
|
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.
