Joe Celko's Thinking in Sets

Auxiliary, Temporal, and Virtual Tables in SQL

By: Joe Celko

Write A Review

Paperback | 22 January 2008 | Edition Number 1

At a Glance

Paperback
384 Pages

Dimensions(cm)
23.5 x 19.05 x 2.01

Paperback

RRP $58.95

$57.75

or 4 interest-free payments of $14.44 with

Ships in 5 to 7 business days

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.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Databases Programming & Scripting Languages

SQL Is Declarative, Not Procedural	p. 1
Hardware, Data Volume, and Maintaining Databases	p. 29
Data Access and Records	p. 37
Lookup Tables	p. 51
Auxiliary Tables	p. 65
Views	p. 87
Virtual Tables	p. 117
Complicated Functions via Tables	p. 137
Temporal Tables	p. 155
Scrubbing Data with Non-1NF Tables	p. 191
Thinking in SQL	p. 215
Group Characteristics	p. 235
Turning Specifications into Code	p. 255
Using Procedure and Function Calls	p. 273
Numbering Rows	p. 287
Keeping Computed Data	p. 297
Triggers for Constraints	p. 301
Procedural and Data Driven Solutions	p. 323
Index	p. 349
Table of Contents provided by Blackwell. All Rights Reserved.

Joe Celko's Thinking in Sets

Auxiliary, Temporal, and Virtual Tables in SQL

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Computing & I.T.

The Infinity Machine

Demis Hassabis, DeepMind and the Quest for Superintelligence

The God We Made

The Threat and Promise of Artificial Intelligence; Quarterly Essay 102

The Reverse Centaur's Guide to Life After AI

How to Think About Artificial Intelligence Before It's Too Late

Careless People

A story of where I used to work

Empire of AI

Inside the reckless race for total domination

If Anyone Builds It, Everyone Dies

The Case Against Superintelligent AI

Nexus

A Brief History of Information Networks from the Stone Age to AI

Design Unlimited

Visual Communication and Storytelling with Generative Design and Data

How to Win At Chess

The Ultimate Guide for Beginners and Beyond

The Explosive Child: Sixth Edition

A New Approach for Understanding and Parenting Easily Frustrated, Chronically Inflexible Children

Final Fantasy VII Rebirth

Material Ultimania

Destiny

Grimoire Anthology Vol. V

Cisco Networking All-in-One For Dummies

The Amazing Generation

The E-Myth Revisited

Why Most Small Businesses Don't Work and What to Do About It

Confident Data Skills

Master the Fundamentals of Working with Data and Supercharge Your Career

Social Research Methods

4th Edition

Destiny Grimoire Anthology, Volume VI

Partners in Light

The Legend of Zelda

Tears of the Kingdom-Secrets of the Zonai (Hero's Edition)

Digital Freedom

A guide to less screen time for safer, happier and healthier families

Open to Work

How to Get Ahead in the Age of AI

Observability Engineering

Achieving Production Excellence

Little Blue Dot

How the Global Positioning System Shaped the Modern World

The Art of The Last of Us

Last of Us

This product is categorised by