SQL

1999 - Understanding Relational Language Components

By: Jim Melton, Alan Simon

Write A Review

Paperback | 18 May 2001 | Edition Number 2

At a Glance

Paperback
928 Pages

Edition Type
Revised

Dimensions(cm)
24.41 x 16.99 x 4.65

Paperback

RRP $170.95

$156.99

or 4 interest-free payments of $39.25 with

Ships in 5 to 7 business days

This book is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent distillation of the details required to put it to work. Written to accommodate both novice and experienced SQL users, SQL:1999 focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. Throughout, the authors illustrate features and techniques with clear and often entertaining references to their own custom database, which can be downloaded from the companion Web site.

* Gives authoritative coverage from an expert team that includes the editor of the SQL-92 and SQL:1999 standards.
* Provides a general introduction to SQL that helps you understand its constituent parts, history, and place in the realm of computer languages.
* Explains SQL:1999's more sophisticated features, including advanced value expressions, predicates, advanced SQL query expressions, and support for active databases.
* Explores key issues for programmers linking applications to SQL databases.
* Provides guidance on troubleshooting, internationalization, and changes anticipated in the next version of SQL.
* Contains appendices devoted to database design, a complete SQL:1999 example, the standardization process, and more.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $0.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Software Engineering Databases Database Software Programming & Scripting Languages

Preface
Database and Technology Foundations	p. 1
Introduction to SQL:1999	p. 23
Basic Table Creation and Data Manipulation	p. 59
Basic Data Definition Language (DDL)	p. 83
Values, Basic Functions, and Expressions	p. 113
Advanced Value Expressions: CASE, CAST, and Row Value Expressions	p. 165
Predicates	p. 179
Working with Multiple Tables: The Relational Operators	p. 223
Advanced SQL Query Expressions	p. 265
Constraints, Assertions, and Referential Integrity	p. 355
Active Databases and Triggers	p. 395
Accessing SQL from the Real World	p. 411
Cursors	p. 447
Privileges, Users, and Security	p. 469
Transaction Management	p. 511
Connections and Remote Database Access	p. 533
Routines and Routine Invocation (Functions and Procedures)	p. 541
Dynamic SQL	p. 569
Call-Level Interface (CLI)	p. 625
Diagnostics and Error Management	p. 683
Internationalization Aspects of SQL:1999	p. 701
Information Schema	p. 715
A Look to the Future	p. 741
Designing SQL:1999 Databases	p. 747
An SQL:1999 Application Example	p. 757
The SQL:1999 Annexes	p. 775
Relevant Standards Bodies	p. 817
Status Codes	p. 825
The SQL Standardization Process	p. 833
Index	p. 845
About the Authors	p. 895
Table of Contents provided by Blackwell. All Rights Reserved.

SQL

1999 - Understanding Relational Language Components

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Computing & I.T.

God AI

Boom or Doom? What to Expect When Machines Outsmart Us

Minecraft Annual 2027

Digital Freedom

A guide to less screen time for safer, happier and healthier families

Enshittification

Why Everything Suddenly Got Worse and What To Do About It

The Reverse Centaur's Guide to Life After AI

How to Think About Artificial Intelligence Before It's Too Late

Tech Bros

The Art and Lore of Dead by Daylight

Design Unlimited

Visual Communication and Storytelling with Generative Design and Data

How to Win At Chess

The Ultimate Guide for Beginners and Beyond

Microsoft 365 Excel For Dummies

For Dummies (Computer/Tech)

The Legend of Zelda

Tears of the Kingdom--Secrets of the Zonai

If Anyone Builds It, Everyone Dies

The Case Against Superintelligent AI

Empire of AI

Inside the reckless race for total domination

The Legend of Zelda: Tears of the Kingdom--Secrets of the Zonai (Hero's Edition)

Tears of the Kingdom-Secrets of the Zonai (Hero's Edition)

The Explosive Child: Sixth Edition

A New Approach for Understanding and Parenting Easily Frustrated, Chronically Inflexible Children

The New Age of Sexism

How the AI Revolution is Reinventing Misogyny

Cisco Networking All-in-One For Dummies

The Infinity Machine

Demis Hassabis, DeepMind and the Quest for Superintelligence

The E-Myth Revisited

Why Most Small Businesses Don't Work and What to Do About It

The Official Stardew Valley Cookbook

Designing Dataâ"Intensive Applications 2e

The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

The Art of Endless Legend 2

The Algebra of Wealth

A Simple Formula for Success

The Amazing Generation

This product is categorised by