Customer Reviews

SQL: The Complete Reference

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

 

 

The title of this book says it all: it's an extremely complete reference to the SQL language. It covers the SQL-89 and SQL2 standards and indicates the features found in SQL2 but not in SQL-89. It covers not only basic SQL data definition, queries, and updates, but also advanced topics such as transaction processing, security, embedded SQL, stored procedures, and object-oriented databases. It also explains how some of the more popular DBMSs vary from or extend standard SQL.

There are some places where the information on SQL is not quite complete. For example, the section on data types doesn't give the sizes of the integer types. As another reviewer mentioned, the section on built-in functions doesn't provide enough information to use some of the more rarely used functions. But these omissions are minor; overall, the completeness of information on SQL is quite impressive.

If you're totally new to relational databases, and you need to design a database schema, you'll want to also get a book on database modeling and normalization, because these topics are not covered. But if you know relational databases or merely need to write queries and updates on an existing database, this book will be more than adequate.

In addition, if you want to access a database from Java or Perl, you'll also want a book on JDBC or DBI, respectively. Perhaps a future edition of the book will cover these topics in the SQL APIs chapter, but they're probably too new to have made it into this edition.

This book needs a re-write to bring it up to the latest SQL standards. If you are still using Pre-SQL92 systems, this book is a pretty good reference.

However, it leaves out important new information such as the new JOIN syntax.

I recommend you check other texts to ensure this is the *one* that you want.

First let me tell you why NOT TO BUY this book: You want to learn how to create SQL statements- there are lots of SQL manuals that are better, and easier to use as a reference because they are lighter in pounds. You want to learn advanced issues in creating a database- if you are that advanced you should buy a book about the particular issue you need help with.

Now let me to you WHY TO BUY this book: If you are just building databases complex enough to get into real trouble (and that happens a lot sooner than you may think) you must read this book. It gives an overview of all the problems you need to think about. Very simple databases can get into trouble if you aren't very careful about data integrity and security. This book will raise warning-flags in your head- to find out what do about those warning-flags, however, you may need to go to a book specifically about your application or problem.

I had no previous experience in SQL and I needed to learn it fast for my job. I chose this book because it got good reviews, and I have no regrets that I bought it. The book is excellent for beginners as well as intermediate level programmers. The material is presented clearly and logically, and explanations and examples are very helpful. I would highly recommend this book to everyone who wants to learn SQL as well as to everyone who is looking for a good reference book.

This is the best SQL reference I have come across. It covers all aspects of programming in SQL as well as how SQL works under the hood. The material is written in a lucid manner so every topic is accessible. It can be used as a beginner's text, too, but its strength is really in its complete coverage and accuracy.

I found the CD-ROM excellent because it let me try out MS SQL Server 7, Oracle8, Sybase and IBM's DB2.

This book gives practical examples in a clear and concise manner. I recommend it highly to anyone who needs to get up to speed on their SQL and database skills.

This book covers the DDL and DML instructions of SQL. It also has a reference to brands like Sybase, Microsoft and Oracle. This a very easy book and the examples showed are very, very helpful. I use this book in all my Databases, SQL and Visual InterDev courses, 'cause it has a good introduction to the SQL standards. If you want a good reference to SQL, I recommend this book !!!

The book is merely a re-package of the first edition; and what makes things worse - none of the errors of the first one were ever fixed:(it still claims, for instance that Oracle's stored procedures params must be declared as VARCHAR(10) - i.e. it must be sized; such syntax could not possibly compile),some examples do not compile..... Appendix shows installation of Informix,DB2 UDB 5.2, Oracle 8 and MS SQL Server 7.0 - from the first edition,while this second edition's disk includes only SQL Server 2000, DB2 7.1 and MySQL; this had undermined my trust in the "up-to-date content", claimed by the preface and the cover. As in the previous edition, it concentrates on the standard SQL, much of which has nothing to do with implementations (e.g. DOMAIN keyword). Chapter on functions lists 7, 9 (?)functions - out of hundreds implemented by RDBMS!

To be true, the book was spiced up with several new chapters on XML, EJB etc - a mile wide, an inch deep in coverage...I'd be better off buying separate books on the subject. I wish I could return it. If you cannot avoid it - buy the first edition and save tens of dollars; or - better yet - look for a different book.

I was forced to buy this book for a database class. I didn't fully appreciate it until I took a programming job and found myself using SQL quite a bit. This book lives up to its name, as it is truly a complete listing of all the concepts in SQL. It gives quality examples of how to use embedded SQL, dynamic SQL, and standard SQL. The authors are to be commended as this book is truly easy to read and quite informative. If you are interested at all in working with database programming, I can't recommend this SQL book high enough!! Plus, there is software included on the CD for many DBMS (Oracle, SQL Server, and others), which makes this book a good value.

This book is, at the same time, too complete and not complete enough. The entire back half of it deals with things I'll never need, but when it came time to learn the functions, there was hardly any discussion. I've noted that this is the major gripe of other people as well.

Still, it's many, many, many simple examples are very helpful to a novice/intermediate user such as myself, and I've found it easy to follow because of them.