Preface

THIS BOOK DEALS with the use of various kinds of SQL programming techniques that make use of tables rather than procedural code. I have been telling people that the biggest obstacle to learning SQL is unlearning procedural programming, but saying that does not show someone who has been thinking in files and procedural code his or her entire career how to do things in a declarative relational language. Hence this book, with actual techniques and an explanation of the thought processes that lead to them.

Like all of my other books, this one is for the working SQL programmer who wants to pick up good SQL programming techniques. It assumes that readers know the language well enough to write code that runs and that they are approaching their ...

Get Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.