REVIEW - Introduction to SQL - Mastering the Relational Database Language


Title:

Introduction to SQL

Mastering the Relational Database Language

Author:

Rick F. van der Lans

ISBN:

Publisher:

Addison-Wesley Professional (2007)

Pages:

1026pp

Reviewer:

James Roberts

Reviewed:

August 2007

Rating:

★★☆☆☆


This book is designed as an tutorial for SQL. It does a good job of explaining the functionality of SQL in a step by step manner. Each of the points explained by the book is liberally illustrated with examples and student exercises. In particular the book does very well in highlighting the behaviour of null columns - explicitly highlighting how nulls are handled in its explanation of individual SQL features. Query syntax is formally described as it is introduced (BNF), which is also echoed in the appendix.

As the introduction highlights, there is a wide selection of SQL implementations, each of which takes a different compromise with respect to the standard. The author picks MySQL as a reasonably full and available example SQL engine - and does a good job of highlighting areas where other implementations are substantially different. The book comes with a CD containing a version of MySql and the WinSQL user interface tool. In my opinion these are a good pair of tools to use for learning the basics of SQL.

On the downside, I found the book's style difficult to skim read - many of the points are introduced by example, and are not highlighted typographically. Although this is quite reasonable for the tutorial function of the book, it would make it less useful as a reference book after the first reading. Also, I found that on some of the non-interactive elements (transaction control and isolation levels for example) the book was a little hazy and could have been a little better explained.

However, as a basic introduction to SQL this is a pretty good book - although as it comes in at over 1000 pages, I would probably recommend a book on weightlifting as a necessary precondition to its use.


Book cover image courtesy of Open Library.





Your Privacy

By clicking "Accept Non-Essential Cookies" you agree ACCU can store non-essential cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

Current Setting: Non-Essential Cookies REJECTED


By clicking "Include Third Party Content" you agree ACCU can forward your IP address to third-party sites (such as YouTube) to enhance the information presented on this site, and that third-party sites may store cookies on your device.

Current Setting: Third Party Content EXCLUDED



Settings can be changed at any time from the Cookie Policy page.