SQL Clearly Explained, Second Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback)

~ Jan L. Harrington (Author) "MySQL is a open-source database management system (DBMS) that runs under Windows and many versions of UNIX..." (more)
Key Phrases: primary key expression, from order lines, traditional join syntax, John Jones, John Smith, John Doe (more...)

Editorial Reviews

Book Description

Second Edition of a classic, revised to cover SQL:1999.

Product Description

This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including
· formulating SQL queries,
· understanding how queries are processed by the DBMS,
· maximizing performance,
· using SQL to enter, modify, or delete data,
· creating and maintaining database structural elements, and
· embedding SQL in applications.


Features
· Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.
· Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.
· Web enhanced with extra features available online at www.mkp.com.

* Second edition of classic SQL handbook
* Updated to cover changes in the SQL language standard (SQL:1999)
* Includes CD with MySQL software

See all Editorial Reviews

Product Details

• Paperback: 352 pages
• Publisher: Morgan Kaufmann; 2 edition (April 25, 2003)
• Language: English
• ISBN-10: 1558608761
• ISBN-13: 978-1558608764
• Product Dimensions: 9.1 x 7.3 x 0.7 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars  See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #1,111,969 in Books (See Bestsellers 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 (Miami, FL) - 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.