Customer Reviews

SQL Clearly Explained

5 star:		(6)
4 star:		(1)
3 star:		(0)
2 star:		(0)
1 star:		(1)

 

 

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.

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.)

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.

I like this book - this is the first book on SQL that clearly explains not only the concepts of SQL and relational databases, but also gives a lot of examples. Perfect book not only for the beginners but also as a reference for advanced programmers. If you need to get understanding of SQL in one day, become SQL guru in a week, and get a good table reference - this book is for you.

This is one of the best SQL books I've read (and I've read many) because it explains the set theory concepts that underlie database design. After reading this book I have a much better appreciation for the SQL mechanism and I am much more creative with how I use it.

This book is interesting to read, well presented and extremely useful. I recommend it for any SQL beginner, and for intermediate-level SQL users who would like a fresh angle on database design and function.

This book is very simple and is geared toward beginners, does not present advance concepts provides a general idea

This book explains SQL very clearly indeed, as the title implies.

I knew a bit of SQL before I started reading this book, so the first 50-odd pages didn't teach me much, but they still made me understand a few things here and there more thoroughly. I got my copy yesterday, and I'm at around page 100 now. For a technical book, it's quite easy to go through, in my opinion, even though it's rich in quality content.

The book is extremely well organised, and the chapters flow from one to the next smoothly. There are lots of examples which always clearly back up the explanations. Also, the example database in this book is consitently used, i.e. you do not have completely different examples everywhere which would only make things confusing.

There are a few minor typos here and there, but even so, I still rate this book 5/5.

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.