SQL Clearly Explained [Paperback]

Jan L. Harrington (Author)

Book Description

ISBN-10: 012326426X | ISBN-13: 978-0123264268 | Publication Date: May 11, 1998 | Edition: 1st

Written with both beginner and intermediate database developers in mind, this clear, concise guide teaches readers about the relationships between the distribution of data in a database and the way in which queries of various types are processed. SQL (structured query language) is a complete data manipulation language for relational databases that allows users to modify database structure (tables, views, and indexes), as well as modify and retrieve data. The book teaches not only SQL syntax but also explains the proper structure of SQL queries and how a query affects the SQL processor and system performance.



* Covers proper structure of SQL queries
* Teaches readers how to produce a desired result and minimize burden on SQL command processors
* Shows readers how to modify data and database structure for ease of use and increased efficiency

Editorial Reviews

Book Description

Second Edition of a classic, revised to cover SQL:1999. --This text refers to an out of print or unavailable edition of this title.

From the Back Cover

Written with both beginner and intermediate database developers in mind, this clear, concise guide teaches readers about
the relationships between the distribution of data in a database and the way in which queries of various types are
processed. SQL (structured query language) is a complete data manipulation language for relational databases that allows
users to modify database structure (tables, views, and indexes), as well as modify and retrieve data. The book teaches not
only SQL syntax but also explains the proper structure of SQL queries and how a query affects the SQL processor and
system performance.

Key Features:

Covers proper structure of SQL queries

Teaches readers how to produce a desired result and minimize burden on SQL command processors

Shows readers how to modify data and database structure for ease of use and increased efficiency

See all Editorial Reviews

Product Details

• Paperback: 279 pages
• Publisher: Morgan Kaufmann; 1st edition (May 11, 1998)
• Language: English
• ISBN-10: 012326426X
• ISBN-13: 978-0123264268
• Product Dimensions: 9.2 x 7.3 x 0.9 inches
• Shipping Weight: 14.4 ounces
• Average Customer Review: 4.4 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #3,181,480 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

11 of 11 people found the following review helpful:

5.0 out of 5 stars Good start for those new to SQL, April 19, 2000

By 

David Tanis - See all my reviews

This review is from: SQL Clearly Explained (Paperback)

I am more of a user than an IT person, and I found this book very useful and easy to follow. The author has filled this book with examples of queries, and taken the time to discuss some of the more technical aspects of SQL such as data modification, database structure and indexes. So from basic data extraction tecnhiques to an overview of the inner-workings of SQL, this book is a success.

11 of 11 people found the following review helpful:

5.0 out of 5 stars The right book to get started in SQL programming, August 20, 1999

By A Customer

This review is from: SQL Clearly Explained (Paperback)

This is the right book for the total SQL newbie. After the intro chapter, the author wastes no time in diving into the difficult topic of data retrieval and spends three well-written chapters on this topic, explaining the operations in a clear and easily understood manner. One big example is used throughout the book, that of an "online" bookstore database. For a SQL (pronounced 'sequel') newbie like me, this book was perfect in its coverage and treatment. Again, the book's clarity is superb.

Two flaws: 1) a number of typos and errors, esp. in the chapters on retrieval, which can confuse the reader; 2) intro to relational database is rather skimpy, IMHO.

But it deserves a five-star rating. Very highly recommended. (I bought this book so I could embed SQL in ASP pages.)

8 of 8 people found the following review helpful:

5.0 out of 5 stars Excellent Intermediate SQL Book, August 24, 1999

By A Customer

This review is from: SQL Clearly Explained (Paperback)

This is an excellent book on SQL. It begins with the basic syntax of SQL statements such as SELECT, INSERT, UPDATE, and DELETE and then covers more intermediate concepts such as joining, string manipulation, and date/time arithmetic. The most rewarding section was the two chapters on embedded and dynamic SQL. It's hard enough to find a good SQL book that covers embedded SQL at all, and this one explains it so well...from declaring cursors to allocating descriptors to fetching rows. This is a well-rounded, well-written text.