Joe Celko's Thinking in Sets

Auxiliary, Temporal, and Virtual Tables in SQL

By: Joe Celko

Write A Review

22 January 2008 | Edition Number 1

At a Glance

No. of Pages
384

Dimensions(cm)
23.5 x 19.05 x 2.01

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

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

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Computing & I.T.

Co-Existence

The Next Phase of AI

You Are Here

The Official Guidebook

God AI

Boom or Doom? What to Expect When Machines Outsmart Us

Claude For Dummies

The Legend of Zelda

Tears of the Kingdom--Secrets of the Zonai

Minecraft Annual 2027

Videogame Architecture

Building Virtual Spaces

Site Reliability Engineering

How Google Runs Production Systems

Data Science For Dummies

4th Edition

The Art of Explanation

How to Communicate with Clarity and Confidence

The New Dark Ages

The End of Reading and the Dawn of a Post-Literate Society

Tech Bros

The New Age of Sexism

How the AI Revolution is Reinventing Misogyny

The Legend of Zelda: Tears of the Kingdom--Secrets of the Zonai (Hero's Edition)

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

If Anyone Builds It, Everyone Dies

The Case Against Superintelligent AI

The Explosive Child: Sixth Edition

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

Enshittification

Why Everything Suddenly Got Worse and What To Do About It

The Reverse Centaur's Guide to Life After AI

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

Digital Freedom

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

Pokecology

An Illustrated Guide To Pokemon Ecology

Nexus

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

Careless People

A story of where I used to work

How to Win At Chess

The Ultimate Guide for Beginners and Beyond

The New Rules of AI Search

SEO for visibility in ChatGPT, Google Gemini and Generative Search

This product is categorised by