Book Detail: SQL-99 Complete, Really : An Example-Based Reference Manual of the New Standard - Bookware

Home FAQs New Arrivals Specials Pricing & Shipping Location Corporate Services Why Choose Bookware?

Search:

Call our store: 9922 6266 (from within Sydney) or 1800 734 567 (from outside Sydney)

.NET

Cisco

Java

ASP

ITIL

Linux

SAP

MCITP

MCTS

Economics and Business

Accounting

Business Information Systems

Finance

TAX

Law

Nursing

Medical

SQL-99 Complete, Really : An Example-Based Reference Manual of the New Standard

by: Peter Gulutzan and Trudy Pelzer

Notify me when in stock

On-line Price: $106.00 (includes GST)

Paperback w/ CD package 1078

15%Off Retail Price

You save: $19.00

TBA - Subject to Change. Price/availability/options for all orders will be confirmed by reply email before processing.

Retail Price: $125.00
Publisher: CMP BOOKS,May-99
Category: SQL PROGRAMMING Level: B/I/A

ISBN: 0879305681
ISBN13: 9780879305680

Add to Shopping Cart

Key Benefits:

The first comprehensive description of the new SQL-99 standard!

A complete reference to all the CLI functions, information--schema tables, and status codes

A working database demonstration, with C as the host programming language

Includes a 300-page HTML glossary of SQL terms

Get a head start with this definitive reference manual to the new standards for syntax, data structures, and retrieval processes of SQL-99. SQL-99 Complete, Really reveals the new ANSI standard for SQL in its entirety. The implementation of each element is thoroughly illustrated by examples. You get an insider's perspective on:

Syntax - each is fully illuminated with diagrams, tables, and hundreds of examples

Objects - the structure of SQL catalogs, the use of character sets, and the transfer of SQL approximate numbers to other programming languages

Background - the meaning of NULLs and the effect of set theory on database design

Practice - style tips used by SQL experts; common and uncommon pitfalls

Law - vendor products' compliance with the official ISO/IEC 9075:1999 standard

SQL-99 Complete, Really features the most complete published description of SQL's CALL level interface, encompassing prototypes, parameters, notes, comparison with ODBC functions, and example code - including complete programs with C or other languages as hosts. The companion CD-ROM contains several more appendices (including a 300-page HTML glossary of SQL terms) and a non-crippled 100%-standard-SQL DBMS.

'This book tells you everything you want to know (and some stuff you don't) about SQL ... provides easy-to-understand tips ... ' PC Techniques, on the authors' previous book, Optimizing SQL

Peter Gulutzan and Trudy Pelzer are the principals of Ocelot Computing Services in Alberta, Canada. They provide SQL database software products and consulting services. They each have more than a decade of experience working with SQL and have produced both SQL-89 and SQL-92 versions of a DBMS for Windows systems. They have collaborated on two previous books, Optimizing SQL and Optimizing C with Assembly Code.

Table of Contents

Preface

Who Should Read this Book?

What's In It?

Chapter 1 Introduction

How To Read This Book

How to Read SQL Syntax

What is SQL?

SQL Conformance

SQL Statement Classes

SQL Rule Evaluation Order

Chapter 2 General Concepts

Set Theory

Recap: The Relational Model

The SQL-environment

SQL Objects

SQL Data Types

SQL Language Elements

Chapter 3 Numbers

Numeric s

Numeric s

IEEE Binary Floats

Numeric Operations

Choosing the Right

Dialects

The SQL Library

Chapter 4 Bit Strings

s

Bit string s

Bit Operations

Chapter 5 Binary Strings

s

BLOB s

BLOB Operations

Chapter 6 Characters

What is a Character?

What`s In It for Me?

Chapter 7 Character Strings

Character String s

Character String s

Character String Operations

Character Strings and Character Sets

Character Strings and Collations

Dialects

Chapter 8 Temporal Values

Some Preliminaries

Temporal s

Temporal Operations

Dialects

The SQL Library

Chapter 9 Boolean Values

s

Boolean s

Boolean Operations

Chapter 10 Collection Types

Collection s

Collection Operations

Comprehensive Example

Chapter 11 Row Types

Row s

Row Operations

Comprehensive Example

Chapter 12 Reference Types

Reference s

Reference Operations

Chapter 13 NULL s

Representing Missing Data with NULL

The Meaning of NULL

Three-Valued Logic

Nullability

The Duplicate Loophole

Fun with NULL s

Problems For Optimizers

Nulloclasts vs. Nullodules

Chapter 14 SQL Clusters

Cluster

Chapter 15 AuthorizationIDs

CREATE ROLE Statement

Privilege

GRANT Statement

Data Control

REVOKE Statement

DROP ROLE Statement

What Privileges Do I Have?

Violating the Security System

User Functions

Dialects

Chapter 16 SQL Catalogs

Catalog

Catalog Names

The Information Schema

Chapter 17 SQL Schemas

Schema

CREATE SCHEMA Statement

DROP SCHEMA Statement

Chapter 18 SQL Tables and Views

Base Table

View

Table Names

Column

CREATE TABLE Statement

ALTER TABLE Statement

DROP TABLE Statement

CREATE VIEW Statement

Getting More Out Of Views

DROP VIEW Statement

DECLARE TABLE Statement

Dialects

Chapter 19 SQL Domains

Domain

CREATE DOMAIN Statement

ALTER DOMAIN Statement

DROP DOMAIN Statement

Frequently-Used Numeric Domains

Chapter 20 SQL Constraints and Assertions

Constraint

Constraint Descriptors

Constraint Definition

Constraint--type -- UNIQUE Constraint

Constraint--type -- PRIMARY KEY Constraint

Constraint--type -- FOREIGN KEY Constraint

Constraint--type -- NOT NULL Constraint

Constraint--type -- CHECK Constraint

CREATE ASSERTION Statement

Interlocking References

Dropping Constraints

DROP ASSERTION Statement

Dialects

Chapter 21 SQL Character Sets

Character Set

CREATE CHARACTER SET Statement

DROP CHARACTER SET Statement

Chapter 22 SQL Collations

Collation

CREATE COLLATION Statement

DROP COLLATION Statement

Chapter 23 SQL Translations

Translation

CREATE TRANSLATION Statement

DROP TRANSLATION Statement

Chapter 24 SQL Triggers

Trigger

CREATE TRIGGER Statement

Activation of Triggers

Trigger Examples

Triggers versus Constraints

DROP TRIGGER Statement

Dialects

Chapter 25 SQL-Invoked Routines

Routine

CREATE PROCEDURE/FUNCTION/METHOD Statement

Routine Parameters

Invoking Routines

Routine Examples

RETURN Statement

External Routines

ALTER ROUTINE/PROCEDURE/FUNCTION/METHOD Statement

DROP ROUTINE/PROCEDURE/FUNCTION/METHOD Statement

Dialects

Chapter 26 PSM; Not Just Persistent Stored Modules

Persistent Stored Modules

CREATE MODULE Statement

ALTER MODULE Statement

DROP MODULE Statement

BEGIN ... END Compound Statement

SIGNAL Statement

RESIGNAL Statement

Program Control

Should Everything be in SQL?

Dialects

Chapter 27 User-Defined Types

UDTs

UDT Example

Columns Based on UDTs

Defining a Typed Table Based on a UDT

CREATE TYPE Statement

CREATE TABLE Statement

CREATE CAST Statement

CREATE ORDERING Statement

Other Processes for Object/Relational Users

Is Object/Relational Really Object-Oriented?

Dialects

Chapter 28 Introduction to SQL-Data Operations

Chapter 29 Simple Search Conditions

Truth Values

SELECT Statement

Predicates

Search Conditions

SQL's

Dialects

Chapter 30 Searching with Joins

Joined Tables

Syntax Rules

Dialects

Chapter 31 Searching with Subqueries

Subquery Syntax

Scalar Subqueries

Row Subqueries

Table Subqueries

Quantified Comparisons

Predicates

Joins versus Subqueries

Subquery Examples

Subquery Tips

Dialects

Chapter 32 Searching with Set Operators

Set Operation Syntax

Result Names and ORDER BY

Result s and Compatibility

Set Operation Examples

Updatability

Recursive Unions

Dialects

Chapter 33 Searching with Groups

GROUP BY Clause

Set Functions

HAVING Clause

Views of Groups

Dialects

Chapter 34 Sorting Search Results

ORDER BY Clause

Dialects

Chapter 35 Changing SQL-data

The SQL-data Change Statements

INSERT Statement

UPDATE Statement

DELETE Statement

Data Change Operations

Dialects

Chapter 36 SQL Transactions

Initiating Transactions

Terminating Transactions

Using Savepoints

Transaction Tips