eBooks-it.org Logo
eBooks-IT.org Inner Image

Joe Celko's Thinking in Sets

Auxiliary, Temporal, and Virtual Tables in SQL

Joe Celko's Thinking in Sets Image

Book Details:

Publisher:Morgan Kaufmann
Series: Morgan Kaufmann
Author:Joe Celko
Published:Feb 05 2008
Posted:Nov 19 2014
Book format:PDF
Book size:7.17 MB

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.

Download Link:

Related Books:

Joe Celko's Data and Databases

Concepts in Practice
Joe Celko's Data and Databases Image
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 world, this book will ground you in the concepts and overall framework you must master if your data-intensive projects are to be successful. If you're already an experienced database programmer, administrator, analyst, or user, it will let you take a step back from your work and examine the founding principles on which you rely every day-helping you to work smarter, faster, and problem-free. Whatever your field or level of expertise, Data and Databases offers...

Joe Celko's Trees and Hierarchies

In SQL for Smarties
Joe Celko's Trees and Hierarchies Image
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 topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999. Includes graph theory and programming techniques. Running examples throughout the book help illustrate and tie concepts together. Loads of code, available for download from www.mkp.com....

2007 - 2021 © eBooks-IT.org