Offers solutions to 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. This edition teaches various advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQ[...]

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not[...]

"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, 15 years later and in its fourth edition, this classic reference still reigns supreme as the only book written by a SQL master that tea[...]

Joe Celko's Complete Guide to NoSQL provides a complete overview of non-relational technologies so that you can become more nimble to meet the needs of your organization. As data continues to explode and grow more complex, SQL is becoming less useful for querying data and extracting meaning. In this[...]

A guide to mastering the two challenging aspects of developing database applications in SQL. It illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. It covers SQL-92 and SQL:1999. It includes grap[...]

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[...]

Do you need an introductory book on data and databases? If the book is by Joe Celko, the answer is yes. Data and Databases: Concepts in Practice is the first introduction to relational database technology written especially for practicing IT professionals. If you work mostly outside the database [...]