Paperback: 1056 pages
Publisher: Addison-Wesley Professional; 4 edition (October 6, 2006)
Product Dimensions: 7 x 1.9 x 9.1 inches
Shipping Weight: 3.2 pounds (View shipping rates and policies)
Average Customer Review: 4.4 out of 5 stars See all reviews (11 customer reviews)
Best Sellers Rank: #506,930 in Books (See Top 100 in Books) #26 in Books > Computers & Technology > Databases & Big Data > Relational Databases #129 in Books > Computers & Technology > Networking & Cloud Computing > Networks, Protocols & APIs > LAN #250 in Books > Computers & Technology > Databases & Big Data > SQL
I ordered this book through .com when there where no reviews-- took a chance and did it ever pay off. So now i'm writing a review for the next guy who is looking for a good book to get HANDS-ON sql experience with. You should have some understanding of relational databases and a basic understanding of sql to get the maximum from this book, but that's not necessary, first time sql self-teachers stand to benefit greatly from it also. I definitely recommend it to anyone wanting to gain further understanding of SQL and relational databases.
I am an SQL developer who writes queries, especially correlated queries, using SQL Server and the AMS360 (Vertafore) database. This book does not as much about correlated queries as the third edition. Below, I pasted a link to the third edition. Often when I write complex SQL queries, I have to go through several queries to retrieve the correct output. I call this approach of query writing, trial and error. I find the challenge to understanding the tough logic of complex SQL is understanding the SQL interpreter or translator, which is similar to a computer language’s compiler, like the C++ compiler. So, because I know SQL extensively I am able to get the complex queries to work, but I get them to work usually through several trials and errors. The chapter that helps me the most in the 3rd edition of this book is chapter 13, but to understand this chapter I had to do most of the exercises in almost all previous chapters including chapter 13, where the exercises include those in each chapter and at the end of each chapter.http://www..com/Introduction-SQL-Mastering-Structured-Language/dp/0201596180/ref=sr_1_2?s=books&ie=UTF8&qid=1418137338&sr=1-2&keywords=introduction+to+sql#customerReviews
Found the text to be very very thorough, and the translation from Dutch to be excellent. My only complaint is that some of the code does not run on all servers, and wish the editors had tagged some of the code with tips on which servers the code was for. The book "SQL Cookbook" has that, and wish this book had that too. For example, in one of the last chapters, the discussion on Collections, there is code that introduces the SETOF concept, but does not mention on which SQL implementation it is applicable.
Many times people will look at the screen after typing a sql query containing a distinct aggregation and think... "How the hell did that query bring up this result".Rick F. van der Lans Does an absolutly amazing job at describing in minute detail every nuance and mathmatical thought behind the most basic of sql functions. This book is platform independent, so it doesn't go into great detail in regards to proprietary functions and DBA related issues; however, I would highly recommend it to DBA's, Data Analysts and Programmers. No matter what your skill level, you will get something from this book.-Brad
This book is most comprehensive. I would recommend this book to friends and family. It is exactly as described and I received it about a week before I expected to get it.
This is the SQL book. I highly recommend for anybody who wants to understand how a sql query is doing calculations and in what order. Great book.