+612 9045 4394
$7.95 Delivery per order to Australia and New Zealand
100% Australian owned
Over a hundred thousand in-stock titles ready to ship
Understanding the New SQL : A Complete Guide - Jim Melton

Understanding the New SQL

A Complete Guide

Paperback Published: 15th October 1992
ISBN: 9781558602458
Number Of Pages: 536

Share This Book:


or 4 easy payments of $46.94 with Learn more
Ships in 7 to 10 business days

Earn 376 Qantas Points
on this Book

SQL is the way to develop, program, and use database applications. SQL-92 is a major advance over earlier versions, offering the first complete SQL language. DB programmers will have the advantage of knowing that applications written in SQL-92 will be portable to all hardware platforms for many years to come.
As the editor of the new standard, Jim Melton is an authority on the language and its new features. Using a highly readable, conversational style, the authors clearly present the power of SQL. They describe practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design. Beginning with a tutorial on basic relational database concepts, subsequent chapters develop SQL and clarify the differences between SQL-89 and SQL-92. Throughout, a retail video and music store is used as an example that develops with the SQL presentation. The book is enhanced by a complete dynamic SQL example, coverage of international character sets, and a look at future generations of SQL. Whether you're a newcomer to SQL or an experienced programmer using PCs, workstations, mini- or mainframes, Understanding the New SQL is an essential resource for current and future implementation of SQL.

Introduction to SQL-92
Getting Started with SQL-92
Basic Table Creation and Data Manipulation
Basic Data Definition Language (DDL)
Values, Basic Functions, and Expressions
Advanced Value Expressions: CASE, CAST, and Row Value Expressions
Working with Multiple Tables: The Relational Operators
Advanced SQL Query Expressions
Constraints, Assertions, and Referential Integrity
Accessing SQL from the Real World
Privileges, Users, and Security
Transaction Management
Connections and Remote Database Access
Diagnostics and Error Management
Internationalization Aspects of SQL-92
Information Schema
A Look to the Future
Designing SQL-92 Databases
A Complete SQL-92 Example
The SQL-92 Annexes: Differences, Implementation-Defined and Implementation-Dependent Features, Deprecated Features, and Leveling
Relevant Standards Bodies
Status Codes
The SQL Standardization Process
The Complete SQL-92 Language
Table of Contents provided by Publisher. All Rights Reserved.

ISBN: 9781558602458
ISBN-10: 1558602453
Series: The Morgan Kaufmann Data Management Systems
Audience: General
Format: Paperback
Language: English
Number Of Pages: 536
Published: 15th October 1992
Country of Publication: US
Dimensions (cm): 23.85 x 19.36  x 2.54
Weight (kg): 0.97

Earn 376 Qantas Points
on this Book