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 UNIX and Linux Forensic Analysis DVD Toolkit by Joe Celko
Cover of the book Epigenetics by Joe Celko
Cover of the book Freeze-Drying of Pharmaceutical and Food Products by Joe Celko
Cover of the book Windows 2012 Server Network Security by Joe Celko
Cover of the book Analytical Methods for Coal and Coal Products by Joe Celko
Cover of the book Advances in Chemical Engineering by Joe Celko
Cover of the book Methods in Extracellular Matrix Biology by Joe Celko
Cover of the book Design of Nanostructures for Theranostics Applications by Joe Celko
Cover of the book Theory of Approximate Functional Equations by Joe Celko
Cover of the book Land Plants - Trees by Joe Celko
Cover of the book Advances in Marine Biology by Joe Celko
Cover of the book Recent Advances in the use of Drosophila in Neurobiology and Neurodegeneration by Joe Celko
Cover of the book Neuromodulation by Joe Celko
Cover of the book Improving Changeover Performance by Joe Celko
Cover of the book Essentials of Oil and Gas Utilities 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