Introduction to the Fifth Edition - Joe Celko's SQL for Smarties, 5th Edition [Book]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. He also updates data element names to meet new ISO rules with the same experience-based teaching style that made the previous editions the classics they are today.
[PDF] Joe Celko's SQL for Smarties Fifth Edition: Advanced SQL Programming (The Morgan Kaufmann
The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management s morgan kaufmann series, most-read sql authors, ansi sql standards, data management systems, sql information. Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioner's guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topi morgan kaufmann series, data management systems, database programmer. 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.
This is a must-read book for any SQL programmer, covering advanced topics in an understandable way. Since the first edition twenty years ago, this book has been aimed at taking experienced SQL programmers and giving them the extras to make them experts. While the title of the book refers to advanced SQL programming, Celko starts with the underlying structures — the data declaration features. He has chapters discussing databases versus file systems, transactions and concurrency control, tables, keys, normalization, views, and other schema objects. One of the best chapters in this part of the book covers DDL flaws that you should avoid, starting with tibbling.
Joe Celko is an American relational database expert from Austin, Texas. He had been a full-time statistician for several years. He is credited with coining the term lasagna code and popularizing Michael J. Celko achieved his undergraduate and first master's degrees in math at Georgia State University. He also has a second master's degree in computer science from Georgia Tech.