SQL--Structured Query Language--is the language all relational databases use to make enquiries. This essential book teaches SQL programming in the shortest possible time. It covers both the ANSI standard as the minimum requirement, and also discusses different implementations. It also serves as a handy reference.
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
BEST BOOK ON SQL FOR BEGINNERS: Do not skip over the theory and the database design. Too many beginners want "samples" to get "rich quick", quick solutions without understanding how a database is built and designed ends up in deadlocks and poor performance. Simplest explanations to SQL you will ever find. If you want to be a professional, this is where you start. If you want to be a hack, go some where else. Joe Celko is the most renowned sql author, his sql puzzle books will keep the smartest data scientists scratching their heads. GO JOE!
Probably not the best book ever written for SQL, let alone for beginners. However, it is the one I used to learn SQL. It covers the basics in a fairly concise manner, enough so to be able to move on to a more advanced book. I read it cover-to-cover, and didn't agonize over the side-tracking or standards discussions. What I wanted was the details on the syntax of the language and an understanding of what the statements do, and that is what was provided along with some basic examples. By the end of the book, I was able to use SQL at a novice level. I'm not sure I'd use this book to teach a class on beginning SQL, but as a quick and dirty read to get a first taste of the language, it fits. P-)
The book starts with installation notes telling reader that instead of using password such and such and id such, as it is described in the software's help, you rathre have to use password "sql" and password "dba". I tried to enter "sql" and "dba" into the password-asking dialog box, and it did not work. Then I realized that it is password "sql" and USERID "dba", and not only it is a misprint, they are listed in a reverse order: first you enter "dba", and second - "sql". That's on the very first page. The page 5 states, that supplied version of Watcom SQL engine will not allow to execute commands CREATE, ALTER, DROP, GRANT or REVOKE. That makes impossible to practice anything you read up to the chapter 5. However, in chapter 6 on p. 162 author offers you to execute command ALTER TABLE, and if you already forgot about page 5, that's a lot of frustration. At this time it helps to return to page 8: "The code in this book has been extensively tested ... so if you encounter an error message ... please thoroughly check that you've typed the code in correctly ... if you don't type in all of the examples, then you may encounter problems later with certain structures or features which haven't been created".
I ordered this book, despite the word "INSTANT" in its title (how "Instant" can SQL get?) only because it was Celko's latest book. This book is below Celko's usual caliber (I consider Joe Celko as one of the leading authorities on SQL and especially writing about SQL). It is intended for the begining/not-so-begining SQL programmer. The intermediate programmer would be happier and more satisfied with Celko's: SQL for Smarties. It is here where you can find the Joe Celko we used to know and admire who wrote for DBMS magazine! I only wish that Celko had written SQL books for begginers back when my generation of programmers were begining to learn the language.
I had a little SQL background before getting this book (background = seeing other SQL code and trying to figure out what it was doing). I bought this book hoping to really learn SQL, but didn't gather too much more from it. Now I have learned SQL more indepth, but still need a good reference book to look up typical "tricks" or common functions. This book is now useless. On the cover it says "exploit your database's full capacity"...which is entirely misleading because most of the exploits are not covered at all in this book. Great for beginner to get to intermediate stage of typical SELECT, INSERT, etc...but if you want to do more than typical, this book is NOT for you.