Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

Nonfiction, Computers, Programming, Programming Languages, General Computing
Cover of the book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL by Joe Celko, Elsevier Science
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Joe Celko ISBN: 9780080557526
Publisher: Elsevier Science Publication: January 22, 2008
Imprint: Morgan Kaufmann Language: English
Author: Joe Celko
ISBN: 9780080557526
Publisher: Elsevier Science
Publication: January 22, 2008
Imprint: Morgan Kaufmann
Language: English

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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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.

More books from Elsevier Science

Cover of the book Algae Based Polymers, Blends, and Composites by Joe Celko
Cover of the book Dynamical Systems by Joe Celko
Cover of the book Media and Information Literacy by Joe Celko
Cover of the book Electrical Drives for Direct Drive Renewable Energy Systems by Joe Celko
Cover of the book Maximum Principles for the Hill's Equation by Joe Celko
Cover of the book Haschek and Rousseaux's Handbook of Toxicologic Pathology by Joe Celko
Cover of the book Practical Web Analytics for User Experience by Joe Celko
Cover of the book Endosome Signaling Part A by Joe Celko
Cover of the book Heat Exchanger Design Guide by Joe Celko
Cover of the book Amniote Origins by Joe Celko
Cover of the book Altmetrics for Information Professionals by Joe Celko
Cover of the book Handbook of Alkali-Activated Cements, Mortars and Concretes by Joe Celko
Cover of the book Freshwater Fishes by Joe Celko
Cover of the book Medical and Health Genomics by Joe Celko
Cover of the book Scientific Foundations of Biochemistry in Clinical Practice by Joe Celko
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy