Joe Celko's SQL for Smarties, 5/e : Advanced SQL Programming (Paperback)

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, 20 years later and in its fifth 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 fifth 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 with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You'll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions.

• New to the 5^th Edition:
  • Downloadable data sets, code samples, and vendor-specific implementations!
  • Overview of the bitemporal model
  • Extended coverage of descriptive statistic aggregate functions
  • New chapter covers flaws in DDL
  • Examination of traditional acid versus base transaction models
  • Reorganized to help you navigate related topics with ease
• Expert advice from a noted SQL authority and award-winning columnist Joe Celko, who served on the ANSI SQL standards committee for over a decade
• Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is SQL 92 or SQL 2011
• Offers tips for working around deficiencies and gives insight into real-world challenges

《SQL for Smarties》被譽為第一本專門探討高級技巧的書籍，旨在將有經驗的SQL程式設計師培養成專家。現在，20年過去了，這本經典參考書已經出版第五版，仍然是唯一一本由SQL大師撰寫的書籍，教導程式設計師和實踐者成為SQL大師！這不僅僅是一些技巧和技術，還提供了解決舊有和新的挑戰的最佳解決方案。Joe Celko傳達了你需要思考的方式，以便在SQL編程工作中獲得最大的效益，無論是在正確性還是性能方面。在第五版中，Joe提供了新的例子，以反映ANSI/ISO標準，讓任何人都可以使用它。他還更新了數據元素名稱，以符合新的ISO-11179規則，同樣採用基於經驗的教學風格，使之成為今天的經典之作。你將學習到撰寫常見查詢的新方法，例如尋找覆蓋、分區、數據中的運行、拍賣和庫存、關聯分割等等。《SQL for Smarties》解釋了SQL編程的一些原則，以及代碼。新的一章討論了DDL中的設計缺陷，例如屬性拆分、非正規論壇冗余和tibbling。還介紹了傳統的acid與base事務模型，這在NoSQL產品中很受歡迎。你將了解計算列和約束中的DEFERRABLE選項。本版新增了對雙時間模型的概述，並對描述性統計聚合函數進行了更長的討論。書籍最後概述了適用於專有4GL供應商擴展的SQL/PSM。

第五版的新特點包括：
- 可下載的數據集、代碼示例和特定供應商的實現！
- 雙時間模型的概述
- 對描述性統計聚合函數的擴展覆蓋
- 新章節涵蓋DDL中的缺陷
- 比較傳統的acid與base事務模型
- 重新組織，以便您輕鬆尋找相關主題

這本書還提供了SQL權威和屢獲殊榮的專欄作家Joe Celko的專業建議。Joe Celko在ANSI SQL標準委員會任職超過十年。本書教授了許多高級技巧，可在任何產品、任何SQL環境中使用，無論是SQL 92還是SQL 2011。它提供了解決不足之處的技巧，並深入洞察現實世界中的挑戰。