SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to convey the way you need to think if you really want to get the most out of your SQL programming efforts.Inside, logic- and set-based analyses replace the traditional, procedural approach to problem-solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack. As you catch on to Celko's approach, you'll devour what he has to say about some of SQL's toughest topics: how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much more.This book gives special emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work. If you're serious about SQL, you won't let SQL for Smarties out of your sight. * Presents all-new war stories that give you insight into real-world SQL programming challenges.* Continues to cover SQL-89 but focuses heavily on the SQL-92 standard.* Offers still more undocumented tips for working around system deficiencies.* Teaches scores of advanced techniques that can be used with any product, in any SQL environment.* Offers expert advice from a noted SQL authority and award-winning columnist.

Product Description: For the last three decades, the author has built a reputation for teaching hands-on SQL programming with industry standards and small doses of theory in his series, SQL Programming for Smarties. In this database programming book, he switches the focuses to mathematical foundations...read more

Product Description: Joe Celko has looked deep into the code of SQL programmers and found a consistent and troubling pattern - a frightening lack of consistency between their individual encoding schemes and those of the industries in which they operate...read more

Joe Celko challenges you with his trickiest puzzles and then helps you conquer them with a variety of solutions and explanations. The puzzles are a compilation from Joe's columns in DBMS and Database Programming & Design magazines. They include new, never-before-published puzzles plus new solutions and extra background for previously published puzzles. In his usual entertaining and informative style, Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective. Through the practical, enjoyable puzzles, he introduces immediately useful new techniques and applications for SQL programming, and shows the database programmer how to write and use non-procedural programs.

Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself? If even one answer is yes, then you need this book. A "Manual of Style" for the SQL programmer, this book is a collection of heuristics and rules, tips, and tricks that will help you improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. Based on many years of experience consulting in SQL shops, and gathering questions and resolving his students’ SQL style issues, Joe Celko can help you become an even better SQL programmer.Help you write Standard SQL without an accent or a dialect that is used in another programming language or a specific flavor of SQL, code that can be maintained and used by other people.Enable you to give your group a coding standard for internal use, to enable programmers to use a consistent style.Give you the mental tools to approach a new problem with SQL as your tool, rather than another programming language ― one that someone else might not know!

Product Description: Ken Henderson's three guides to SQL Server have been widely praised by readers and reviewers alike. Now all three of them are available in an attractive, sturdy, specially priced boxed set. The three books included are The Guru's Guide to Transact-SQL, The Guru's Guide to SQL Server Stored Procedures, XML, and HTML, and The Guru's Guide to SQL Server Architecture and Internals...read more

A single volume reference for SQL, Structured Query Language, lists the new SQL 3.0 standard, describes the different extensions that major vendors have added to the standard, shows routines to carry out everyday SQL tasks, and more. Original. (All Users).

(view table of contents)