Includes index.

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 fifth edition are: examples to reflect the ANSI/ISO standards so anyone can use it; data element names to meet new ISO-11179 rules; new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. The book explains principles of SQL programming as well as code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. Other topics include: traditional acid versus base transaction models, now popular in NoSQL products; computed columns and the deferrable options in constraints; bi-temporal model; overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions. --

College of Engineering and Computer Studies