SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.
New to the fourth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO—11179 rules and he expands coverage of SSD, parallel processors and how new hardware will change how SQL works, all with the same experience-based teaching style that made the previous editions the classics they are today.
A compendium of tips and tricks for advanced SQL programming, with coverage of database and data design, data types, and operations on tables, in an informal, conversational style. The bulk of the book covers predicates and logical operators of SQL, and complex queries. SQL-89 features now supported by commercial RDBMSs are discussed, as well as SQL-92 and how it's being implemented in current and future database products. An appendix offers source code for six check-digit programs. Annotation c. Book News, Inc., Portland, OR (booknews.com)