REVIEW - Joe Celko's SQL for Smarties - Advanced SQL Programming Second Edition


Title:

Joe Celko's SQL for Smarties

Advanced SQL Programming Second Edition

Author:

Joe Celko

ISBN:

Publisher:

Morgan Kaufmann (2000)

Pages:

553pp

Reviewer:

Roger N Lever

Reviewed:

June 2000

Rating:

★★★☆☆


a very useful book for those people who want to understand SQL in greater depth and to appreciate what it can do.

For a large number of developers working with databases is a bread and butter activity. SQL is the language for querying databases and if you want to advance beyond "select 'item' from table where x=y" then this is a potential candidate.

Using primarily the ANSI SQL-92 standard, the author covers the topics you would expect - database design, normalisation, datatypes and null, expressions (

select, join, group by
...) and aggregate functions (count, sum...) and also advanced topics such as arrays, sets, subsets, graphs and optimisation. The text is well laid out with clear case examples, explanations and SQL. However, beginners with databases/SQL will want to start with a different book for more introductory level material.

For those who have a reasonable working knowledge of SQL there will be plenty of material to get your teeth into and plenty of example SQL to experiment with on those complex problems that you have probably dealt with by using simple SQL followed by programmatic manipulation. For instance the section on trees provides SQL to find leaf nodes, or perform subtree insertion or deletion.

One point that came out a number of times is that the various vendors have not fully implemented SQL-92. It would have been useful to have a topic header with a level of vendor compliance. However that is a very minor quibble on what is a very useful book for those people who want to understand SQL in greater depth and to appreciate what it can do.


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.