Understanding the New SQL: A Complete Guide / Edition 1

Paperback (Print)
Buy New
Buy New from BN.com
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
  • All (20) from $1.99   
  • New (6) from $59.28   
  • Used (14) from $1.99   


An effective introduction to SQL, and a comprehensive reference for years to come. As the editor of the 1992 standard, Jim Melton is an authority on the language and its new features. Using a highly readable, conversational style, he and Alan Simon 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.

• A tutorial on basic relational database concepts.

• A clear explanation of the differences between SQL-89 and SQL-92.

• A retail video and music store as an example that develops with the SQL presentation.

• Coverage of international character sets.

"...clearly describes practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design...written by an authority on the language at its new features."

Read More Show Less

Product Details

Meet the Author

Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and is a representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative to ANSI INCITS Technical Committee H2 for Database and a US representative to ISO/IEC JTC1/SC32/WG3 (Database Languages). In addition, Jim has participated in the W3C's XML Query Working Group since 1998 and is currently co-Chair of that Working Group. He is also Chair of the WG's Full-Text Task Force, co-Chair of the Update Language Task Force, and co-editor of two XQuery-related specifications. He is the author of several SQL books.

Alan Simon is a leading authority on data warehousing and database technology. He is the author of 26 books, including the previous edition of this book and the forthcoming Data Warehousing and Business Intelligence for e-Commerce, available from Morgan Kaufmann Publishers in early 2001. He currently provides data warehousing-related consulting services to clients.

Read More Show Less

Table of Contents

1 Introduction to SQL-92
2 Getting Started with SQL-92
3 Basic Table Creation and Data Manipulation
4 Basic Data Definition Language (DDL)
5 Values, Basic Functions, and Expressions
6 Advanced Value Expressions: CASE, CAST, and Row Value Expressions
7 Predicates
8 Working with Multiple Tables: The Relational Operators
9 Advanced SQL Query Expressions
10 Constraints, Assertions, and Referential Integrity
11 Accessing SQL from the Real World
12 Cursors
13 Privileges, Users, and Security
14 Transaction Management
15 Connections and Remote Database Access
17 Diagnostics and Error Management
18 Internationalization Aspects of SQL-92
19 Information Schema
20 A Look to the Future
A Designing SQL-92 Databases
B A Complete SQL-92 Example
C The SQL-92 Annexes: Differences, Implementation-Defined and Implementation-Dependent Features, Deprecated Features, and Leveling
D Relevant Standards Bodies
E Status Codes
F The SQL Standardization Process
G The Complete SQL-92 Language

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted March 25, 2000

    A very useful source of information

    This is a very useful book, and every professional user of SQL should read it. The authors demonstrate a clear understanding of the subject matter, and their writing style, with good examples, down-to-earth explanations, and the occasional touch of humor, is simply enjoyable. A particularly helpful feature of this book, is that syntax is shown in easy-to-read railroad diagrams. It would have been helpful if the index was organized in such a way that one could immediately locate the railroad diagram for a given SQL statement. A separate list of railroad diagrams would also be nice. And although I consider heavy reliance on defaults to be bad programming practice, I would have appreciated it if just a quick look at a railroad diagram told me what defaults, if any, applied for the statement in question. Any author of books or articles must have his or her target audience in mind. For example, what may be an excellent article for a trade magazine, would almost certainly be rejected by a scientific journal. Thus, when judging this book one must keep in mind the perspective of its authors. If you are looking for an academic textbook with emphasis on scientific rigor, then this book will disappoint you. It is pretty obvious that is not what this book was meant to be. If, on the other hand, you want a practically oriented book that will help you do your job in a better way, then this is a great place to start. Having worked with databases and related technologies for 18 years, I have seen so many books where the number of pages outweigh the knowledge of their authors by a factor of 2 or more (and just in case there are any publishers out there listening; computer professionals are sick and tired of having to read through hundreds of pages of blah-blah-blah in order to find the information we are looking for). This book is different. It contains 394 pages of ordinary chapters, followed by 133 pages of appendices, and the signal-to-noise ratio in all these pages is excellent. If you are an application programer, a database administrator, or some other kind of database practitioner, and you are serious about your work, then there are some books I would consider more or less mandatory reading. This is one of them.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)