Rating: 
Summary: Easy Reading Practical Advice
Review: I consider this the best book around for introducing yourself to SQL. It is easy to read, written in plain English and explains jargon and terminology unique to SQL. Although SQL does have a background in logic and mathematics, most practitioners work more by intuition and experience than set theory. The authors give clear practical advice and detailed explanations of all aspects of the SQL language and how they are used. They explain the theory behind relational databases plainly and to a detail necessary to understand what you are doing. Common mistakes and answers to questions gleaned from the net round out the book. The is the best SQL book by far, well written and edited, with sensitive typesetting and pleasing cover art. The only thing it lacks is a web based approach to database querying. Although it supplies an excellent example by taking your through the building of a book store database (!) the examples are more generic with an older enterprise orientation. For the specifics of building database driven web sites lookup one of the good books on PHP or ASP programming.
Rating:
Summary: Clearly written introduction to SQL with pertinent examples
Review: SQL appears simple, but can easily confuse a beginner. This book has excellent examples of SQL-92 to demonstrate effective SQL commands for the major RDBMSs. It also shows common mistakes and how to avoid them. There is a lot of hand-holding throughout the book, and I found the explanations deliberate and well thought out. But it is not padded with fluff. I've seen books twice as thick and half as effective. Good definitions, queries and results. Topics covered include database design, creating and filling a database, selecting data, sorting, grouping, joins, subqueries, views, an overview of security, transactions, performance, and integrity, real world business problems, and how to avoid mistakes. I read it cover to cover twice and practiced the examples (except the views, which you can't use with the included Sybase SQL Anywhere). This book lays a good foundation to build upon. Possible follow-up books include "Introduction to SQL" by Rick van der Lans (published 1999) and "Joe Celko's SQL for Smarties" by (guess who) (publ. 2000). Good luck!
Rating:
Summary: The best for learning concepts and structure
Review: Outstanding book for beginner looking to learn SQL from scratch. Thrown into an SQL job with no experience whatsoever, this book helped me become functional in a very short period of time. Provides sound fundamental concepts which will help lead to more efficient procedures, scripts, web-design, etc.
Rating:
Summary: Simply the best entry-level SQL learning tool
Review: Forget about the complaints that this book is just about Sybase SQL. Any book that tries to teach SQL has to use a vendor software as a tool to convey the concepts. This one happens to be using Sybase Anywhere. But it really doesn't matter. Imagine yourself learning how to drive, do you really care whether the car is Honda Accord or Toyota Camry? As long as you don't boycott Japanese product, your only concern should be whether the person sitting next to you is a good driver and teacher!This book is the best SQL teacher I've ever met. Granted, before reading this book, I've already had graduate level courses on relational database and years of working experience in using several big name vendor databases, but I still learned a lot from this one in both conceptual and technical senses. And because of that, I can tell with 100% confidence that this book teaches SQL in the most efficient and general way - it introduces key SQL concept in a crystal clear manner; it teaches basic SQL syntax in the most standard form as possible and reminds you of the vendor specific variations diligently wherever they occur; it presents the full picture from database design principle to FAQs of daily SQL usages in easy and concise language. It's simply the best SQL book for beginners. For experienced SQLers, this book can serve as a field guide to help you maintain a clear big picture of core SQL when you start to get lost in the forest of numerous vendor specific DBMS products. Oh, do you really care about the minor typos and the shabby free SQL Anywhere software comes with the book? (p.s., it works with limited functions). Again, your car may have scratches and some fancy functions of the stereo may not work, but as long as your purpose is to learn how to drive and you have a good teacher sitting next to you, it doesn't matter at all. I'm amazed by how good a teacher the authors are. Having taught myself, I know how difficult teaching could be. The authors of this book really know how to teach - teaching is art, they are masters. I salute them.
Rating:
Summary: Good Beginning Book
Review: I have been programming for over 15 years, and I have never had the need to venture into the world of SQL, until early 2001. At that time I started looking for a basic book to help me understand the SQL syntax. I finally purchased this book in Jan 2002; by this time I had a rough understanding of SQL, but would have been hard pressed to write any useful statements. I typically used Access to create the statement and then copied it into my code. After reading this book I feel able to write most any SQL statement, and to be able to understand the current ones in the code. I also found the answer to several syntax problems that I had: why I would get an error with an SQL statement the had a aggregate function and I was trying to select a column value as well. I would recommend this book to any beginner who needs to have a better understanding of SQL. The only draw back, for me, was that the book concentrates on the SyBase version of SQL; however, there is a chart in the back of the book that list syntax for four different version of SQL: SyBase, Microsoft, Informix, and Oracle.
Rating:
Summary: Very Well Written
Review: So many authors of technical books know the material, but don't know how to convey it clearly and concisely to others. These authors do. I highly recommend this book.
Rating: 
Summary: Acceptable teaching book, poor reference manual
Review: I have had this book for a year now and pretty much hate it. It is not a "handbook". It is not a book that is good for reference. This book is good if you do not know any SQL and want to do a cover to cover reading. This book's index is horrific and its content remedial (only the most basic of queries are discussed), so do not plan on using the book as a reference beyond that. The book should be titled "Read This Once Through to Learn Basic SQL". It is not a handbook and it is not practical, so it's name is quite the misnomer.
Rating:
Summary: One of the best.
Review: I have been using and referring to this book for years. It is easy to find examples of what I'm looking for. There were no attempts to make this book any thicker than necessary. There are very few good SQL books out there. The books are either too simple or they try to thicken the book with garbage. This one is right on target.
Rating:
Summary: GREAT INTRO BOOK
Review: This was one of the best written INTRO books I have seen. I say INTRO, because it does not cover everything I wanted, but I don't mind because I also liked the fact that it wasn't 600+ pages. SQL is too dry to spend that much time reading about it. Just download an evaluation of SQL Server 7 and the CD the book comes with has a script to create the database. Just copy/paste the script into Query Analyzer and you're done(you may have to troubleshoot a little). Or you can enter it by hand which I found to be much more useful for me to learn SQL. Anyway, GOOD INTRO BOOK. BUY IT.
Rating:
Summary: Excellent Introduction to Relational Databases and SQL
Review: If you know nothing about databases, this book is a great place to start. It explains what a relational database is, how to design and create one, and how to perform updates and queries. It covers just about everything you'll need to know, such as normalization, outer joins, security, and transaction processing. Even though the book sticks with the basics, it covers everything that most SQL programmers will need to know. One weakness of the book is that it doesn't distinguish which features are part of SQL-89, which are part of SQL2 (aka SQL-92). For some features, such as outer joins, implementation-specific syntax is given without the standard SQL syntax. Because of this, it may be more difficult for readers of this book to write SQL that will work on many different databases. An important thing to note about this book is that it covers only SQL. That means it doesn't cover stored procedure dialects, embedded SQL, or SQL APIs such as ODBC, JDBC, or DBI. If you're going to actually use SQL, you'll need another reference that explains how to interface with a SQL database.
|
