SQL

1999 - Understanding Relational Language Components

By: Jim Melton, Alan Simon

Write A Review

18 May 2001 | Edition Number 2

At a Glance

No. of Pages
928

Edition Type
Revised

Dimensions(cm)
24.41 x 16.99 x 4.65

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

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

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Computing & I.T.

Co-Existence

The Next Phase of AI

AGI Chronicles

The Inside Story of the Race to Create an Artificial Superintelligence

The Blood of Dawnwalker

The Art of the Game

The Legend of Zelda

Tears of the Kingdom--Secrets of the Zonai

Data Empire

How information shaped human history

God AI

Boom or Doom? What to Expect When Machines Outsmart Us

Digital Freedom

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

HBR's 10 Must Reads 2027

The Definitive Management Ideas of the Year from Harvard Business Review (featuring 'The Hidden Beliefs That Hold Leaders Back' by Muriel M. Wilkins)

Tech Bros

The AI Con

How To Fight Big Tech's Hype and Create the Future We Want

The Reverse Centaur's Guide to Life After AI

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

Empire of AI

Inside the reckless race for total domination

Nexus

A Brief History of Information Networks from the Stone Age to AI

Pokecology

An Illustrated Guide to Pokemon Ecology

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)

Careless People

A story of where I used to work

The Explosive Child: Sixth Edition

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

Minecraft Annual 2027

The E-Myth Revisited

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

Analytics Engineering with Microsoft Fabric and Power BI

The Definitive Guide for Building Enterprise-Grade Analytics Solutions

Call of Duty Black Ops Zombies

The Art of Treyarch

The Year in Tech, 2027

The Insights You Need from Harvard Business Review

The Sims: Light-Up Plumbob

With Music!

Minecraft Dungeons II

Sticker Activity Book

This product is categorised by