View Larger Image	Joe Celko Morgan Kaufmann, Paperback, 3rd edition, Published August 2005, 808 pages, ISBN 0123693799
	List Price: $57.95 Our Price: $41.50 You Save: $16.45 (28% Off)
	Availability: Out-Of-Stock

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

• Joe Celko's Trees and Hierarchies in SQL for Smarties; Joe Celko, $28.95, 29% Off!
• Joe Celko's SQL Programming Style; Joe Celko, $25.50, 29% Off!
• Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions; Thomas Kyte, $30.50, 39% Off!
• Oracle PL/SQL Programming, 4th Edition; Steven Feuerstein, et al, $40.50, 38% Off!

• Databases : SQL

• Morgan Kaufmann

• Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums.
  
• Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.
  
• Offers tips for working around system deficiencies.
  
• Continues to use war stories--updated!--that give insights into real-world SQL programming challenges.

This book is a classic, and this revision will merely solidify its position.
--Rudy Limeback

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, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques

Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.

In the third edition, Joe features new examples and update to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics.

Table of Contents

Part I: Data Relational Model Basics Keys and uniqueness

Normalization Practical Hints for Normalization

Practical Hints for Denormalization

Encoding and scales Implementations

Generator functions

Part II: DDL (Data Declaration Language)

Part III: DML (Data Manipulation Language)

1. Numeric Data in SQL

2. Temporal Datatypes in SQL

3. Character Datatypes in SQL

4. Other Expressions

5. Table Operations

6. INSERT INTO Statement

7. The UPDATE Statement

8. Comparison or Theta Operators

9. Valued Predicates

10. LIKE and SIMILAR TO Predicates

11. BETWEEN and OVERLAPS Predicates

12. The [NOT] IN Predicate

13. [NOT] EXISTS() Predicate

14. Quantified Subquery Predicate

15. The Simple SELECT Statement

16. OUTER JOINs

17. Old versus New JOIN syntax

18. Bin Packing

19. VIEWs

20. TEMPORARY TABLEs

21. Partitioning Data

22. Grouping Operations

23. Aggregate Functions

24. Other Aggregate Functions

25. Auxiliary Tables

26. Statistics in SQL

27. Regions, Runs, Gaps, Sequences and Series

28. Array Structures in SQL

29. Set Operations

30. Subsets

31. Trees in SQL

32. Graphs in SQL

33. Optimizing Code

About the Author

Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on the DBMS CompuServe Forum, his column in Intelligent Enterprise (which won several Reader’s Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko’s SQL for Smarties: Advanced SQL Programming, Joe Celko’s SQL Puzzles and Answers, and Joe Celko’s Trees and Hierarchies in SQL for Smarties, all published by Morgan Kaufmann.

Sep 16, 2006     Chandra Babu from Australia
Amazing Book
Who ever works in SQL Must Have ,I know Celko For longtime, He is My role model and the way in which wrote the book is more informative and explorative. Cheers to Celko, Chandra Babu Australia

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account