Amazon.com Customer Reviews
THIS AUTHOR IS SERIOUS!!!........within 10 minutes you can teach yourself a new language - Review written on February 21, 2008
Rating: 5 out of 5
3 customers found this review helpful.
SQL in 10 minutes?? ......I thought this guy was kidding. He wasn't. The main reason why I couldn't get a job was because I didn't know SQL, within one hour I read the book, tried all the examples, wrote SQL on my resume, applied for a job and got the job the next day requiring SQL experience :)
This language is so easy to learn, it feels more like an application than a programming language. It seems as though the whole language is really just 3 words, select, from & where, although I'm still new and theres probably a tonne more but I didn't need to know that to get the job.
Compare it to learning c,c++, Fortran and other languages for the first time where you learn to define variables, learn the functions, test cases, inputs, outputs, etc, etc. SQL you pretty much type in the inputs and you receive the outputs...its a really intuitive language, anyone can start learning within minutes. Highly recommend this book, its also probably the best quick reference out there if you need to solve a particular problem.
A nice summary if you learned from the bottom up. - Review written on July 30, 2007
Rating: 4 out of 5
2 customers found this review helpful, 1 did not.
I learned my SQL by supporting the SQL of others, reading MSDN, and working with DBAs for new queries. I never made much of SQL since I often had DBAs I was told to use or used APIs that built SQL (now such as Kodo JDOQL).
However, I since also have to debug JDOQL, that means reading SQL traces. So... I needed a cheap, concise book with easy to follow examples. This book did that, and gave me thinking points to start with "what ifs" for scenarios and failure cases.
Also, it provided a simple, non-wind-bagged explanation of joins that sticks with me. Turns out I have been doing implicit INNER JOINS for years without knowing the fancy terminology for the "equijoin".
It is not the SQL bible, but it is not over-priced liked one. It is not a replacement for your DBMSs reference manual, as it often defers to the documentation for "further details". It is fast paced and practical. It does cover several DBMSs to some degree.
If you are a hard core DBA this is not it, but if you are developer who wants to take some power back from your DBAs, understand query traces, and write some useful queries that don't over exploit DBMS X's Stored Procedure syntax... this book may be useful.
If you... - Review written on October 10, 2006
Rating: 5 out of 5
13 customers found this review helpful.
Update (Dec 1, '06): updates marked with >>>
-don't know which program you will be using for SQL and have no knowledge of SQL commands, this book is directed at you and you should get it.
-know which program you will be using, get a book on your specific program, because there is enough variation between the programs that another book will serve you much better.
>>>I think I will change this recommendation -- if you don't know SQL, consider this book regardless of which program you are working with.
-are familiar with a few commands in SQL, look for a different book because you will probably breeze through this book and not gain nearly as much as if your time was spent reading something else.
I was in the first category and found this book to be an excellent introduction. With the exception of 2-3 of the 18 lessons, this book is quite clear...those 2-3 lessons just take a bit more time getting familiar with the concepts. You won't find yourself breezing through the chapters in 10 minutes each, with the possible exception of the first 5 or so, but the lessons do only take about 20 minutes on average and are straight-forward.
>>>The book teaches by example, which I'm typically not a big fan of, but this book pulled it off well.
So, if you are brand new to SQL and don't know what program you will be using, buy this book and take an hour each day for a week to read it.
>>>If you are new to SQL, consider buying this book, but... you may also benefit from the free tutorial on w3schools . com, which is found under the PHP section. Having now done some MySQL for a website, I can certainly say this book is useful and I gained from its pages but I would also recommend the free tutorial before purchasing (both because it is free and because it is actually a very good tutorial on both PHP and MySQL).
David de Leon - Review written on July 29, 2006
Rating: 4 out of 5
7 customers found this review helpful.
I like this book, I've read it about 3 times. I typed in most of the examples in MS Access 2000, and most of them worked, except those involving transactions, views and cursors. The examples using SELECT queries (including the FROM, WHERE, GROUP BY, HAVING, ORDER BY clauses), IN keyword, UNION keyword, BETWEEN keyword, subqueries, aggregate functions, INSERT, UPDATE, and CREATE TABLE, DELETE TABLE, and DROP TABLE worked just fine. Sometimes I had to tweak them, but there were no major hassles in getting them to work.
What I did not like about the book is that it did not properly identify some concepts as being non-ANSI SQL concepts. For example, triggers, savepoints, and indices are not a part of ANSI SQL. The book did not seem to properly identify them as such. To identify what is not a part of ANSI SQL, I recommend SQL Instant Reference, by Martin Grubner. It is also a small book, great at identifying the full syntax of SQL statements, but short on examples.
SAMS Teach Yourself SQL in 10 Minutes does not give a comprehensive overview of ANSI SQL, but I was never under the impression that it would. But it does give a great start at using SQL, and focuses on the workhorse of SQL - the SELECT statement. I heartily recommend it for the beginner.