SQL Clearly Explained, Second Edition

Author: Jan Harrington, Jan L. Harrington
List Price: $45.95
Our Price: Click to see the latest and low price
ISBN: 1558608761
Publisher: Morgan Kaufmann (April, 2003)
Edition: Paperback
Sales Rank: 657,703
Average Customer Rating: 4.29 out of 5

Buy now directly from Amazon.com - Purchase this book, safely and securely from the largest book dealer on the Internet, Amazon.com

Customer Reviews

Rating: 5 out of 5
Good start for those new to SQL
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.


Rating: 1 out of 5
Not very foresighted
The book doesn't teach you how to create tables until the latter part, so that when you run the SQL script (CREATES.TXT), you'd be left hanging if you got errors (as I did with MS SQL 7.0).

I don't know what the author was thinking, but if the book is truly for beginners, then she should have provided more details on the creation of the example files right at the beginning of the book, or perhaps different SQL script versions for the more popular SQL Servers out there.

I had spent 4 days out of town and seriously read this book without a PC at the time, only to be disappointed that I could not create the tables in the book when I came back. Being a beginner in SQL, I wasn't exactly sure where to go from there.

So here I am now, shopping for another book. Disappointing.


Rating: 5 out of 5
Excellent Intermediate SQL Book
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.

Similar Products

· Managing and Using MySQL (2nd Edition)
· Relational Database Design Clearly Explained, Second Edition
· SQL in a Nutshell: A Desktop Quick Reference

Return To Main Computer Book IndexSearch Our Entire Computer Book Catalog