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 $89.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 God We Made

The Threat and Promise of Artificial Intelligence; Quarterly Essay 102

The New Age of Sexism

How the AI Revolution is Reinventing Misogyny

Final Fantasy VII Rebirth

Material Ultimania

Screensaver

A Judgement-Free Guide to Your Child's First Smartphone

The Amazing Generation

Doppelganger

A Trip Into the Mirror World

Careless People

A story of where I used to work

How to Win At Chess

The Ultimate Guide for Beginners and Beyond

Open to Work

How to Get Ahead in the Age of AI

If Anyone Builds It, Everyone Dies

The Case Against Superintelligent AI

The Unofficial Sims Cookbook

From Baked Alaska to Silly Gummy Bear Pancakes, 85+ Recipes to Satisfy the Hunger Need

The Explosive Child: Sixth Edition

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

How We Learn

The New Science of Education and the Brain

Famesick

Super Nintendo

How One Japanese Company Helped the World Have Fun

Python Crash Course

3rd Edition - A Hands-On, Project-Based Introduction to Programming

Final Fantasy IX Picture Book

Vivi and Grandpa's Memories for the Sky

Cisco Networking All-in-One For Dummies

The Infinity Machine

Demis Hassabis, DeepMind and the Quest for Superintelligence

The E-Myth Revisited

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

Microsoft 365 Excel All-in-One For Dummies

Excel for Dummies

The Official Stardew Valley Cookbook

Co-Intelligence

Living and Working with AI

Minecraft - The Complete Handbook Collection

Minecraft

This product is categorised by