Book description
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 to mention lost productivity.This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you’ll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you’ll be coding more quickly, writing more efficient code, and applying the full power of SQL
• Filled with the insights of one of the world’s leading SQL authorities - noted for his knowledge and his ability to teach what he knows.
• Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance).
• Presents clear guidance for selecting and correctly applying the right table technique.
Table of contents
- Copyright
- The Morgan Kaufmann Series in Data Management Systems
- Preface
- SQL Is Declarative, Not Procedural
- Hardware, Data Volume, and Maintaining Databases
- Data Access and Records
- Lookup Tables
- Auxiliary Tables
- Views
- Virtual Tables
- Complicated Functions via Tables
- Temporal Tables
- Scrubbing Data with Non-1 N F Tables
- Thinking in SQL
- Group Characteristics
- Turning Specifications into Code
- Using Procedure and Function Calls
- Numbering Rows
- Keeping Computed Data
- Triggers for Constraints
- Procedural and Data-Driven Solutions
Product information
- Title: Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
- Author(s):
- Release date: January 2008
- Publisher(s): Morgan Kaufmann
- ISBN: 9780080557526
You might also like
book
Codeless Data Structures and Algorithms : Learn DSA Without Writing a Single Line of Code
In the era of self-taught developers and programmers, essential topics in the industry are frequently learned …
book
Effective Python: 90 Specific Ways to Write Better Python, 2nd Edition
Updated and Expanded for Python 3 It’s easy to start developing programs with Python, which is …
book
The Pragmatic Programmer: your journey to mastery, 20th Anniversary Edition, 2nd Edition
"One of the most significant books in my life." —Obie Fernandez, Author, The Rails Way "Twenty …
book
Fundamentals of Software Architecture
Salary surveys worldwide regularly place software architect in the top 10 best jobs, yet no real …