Joe Celko's SQL for Smarties

by Celko, Joe

• ISBN13: 9780123820228
• ISBN10: 0123820227
• Edition: 4th
• Format: Paperback
• Copyright: 2010-10-18
• Publisher: Morgan Kaufmann Pub

Summary

The SQL Standards are revised every five years and this revision is necessary to keep pace with the language. Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The object-relational set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the fourth edition.Bottom line, this is the must-have book devoted to the advanced SQL techniques needed to turn an experienced SQL programmer into an expert and it has established itself as the classic for budding SQL masters.KEY FEATURESExpert advice from a noted SQL authority and award-winning columnist who has given ten years service to the ANSI SQL standards committeeTeaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL 92 or SQL 2008 environmentOffers tips for working around deficiencies and gives insight into real-world challenges