Customer Reviews

Sams Teach Yourself SQL in One Hour a Day (5th Edition)

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

 

 

A good solid basic book on the fundamentals of structured query language. It is without question targeted and written for the beginner. The book has numerous examples that include showing the query statement, an analysis and the output in both MySQL and Oracle. At 695 pages, not counting the appendix and index, it might appear to be a long book, but a lot of space is taken up with the abundant examples, making the book appear longer than it really is. The 28 lessons do not take long to do. Maybe if someone is brand new to SQL they may take an hour, but normally I found the lessons taking 20 to 30 minutes including the reading the chapter.

My only complaint is that the syntax is in MySQL or Oracle and does not include MSSQL examples.

This book I recommend for every beginners in SQL.
The book is very organized and have a lot of exercises.

My son bought this book as a way to being learning SQL. It was recommended by a DBA. I began skimming to see how well organized it was. This book fails in so many ways:
The copy of the book was run on a copy machine, not a press. Do we need a statement now that books are really printer or you are getting a poor quality copy?
The authors state that the material is based on Oracle with the back cover stating "features exclusive to Oracle..." then goes on to mention that MySQL is also included. It looks like the original book was for Oracle exclusively and then MySQL was added later.
On page 27 the book assumes that the databases used as examples are already installed. I could not find any instructions for installing the material except for some TXT files downloaded from the book's web site. I used the SOURCE command to run these text files. Of course they are not SQL so I had plenty of errors but had enough to work with but by the end of Lesson 2 I quit. I'm looking for something better for him to use.
I will be glad to be corrected if I have missed something here. For all these reasons and more I'm giving the book 1 star.
The most appropriate SQL command for this book is DROP.

Been reading this book now for about 2 weeks and it has plenty of errors... and I can't find anything online with corrections even on the publisher's site which has downloads and online viewing.

This book is for people who want to learn the fundamentals of structured query language (sql) quickly. Through the use of countless examples, this book depicts all the major components of sql, as well as options that are available with various database implementations. You should be able to apply what you learn here to relational databases in a traditional business setting. This book has chosen to use MySQL for hands-on exercises. Over the past decade the landscape of information technology has drastically shifted to a data-centric world. More than ever companies are looking for ways in which they can leverage their own data networks to make intelligent business decisions. This includes the ability to gather, store, and report effectively over possibly large sets of data in multiple formats. So the role of a database administrators and developers has become strategically important in the proper implementation and care of these systems.

It was at stated on the site, i was almost new book, I thought they've sent me anew book instead of a used one.