Ebook307 pages6 hours
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
By Joe Celko
Rating: 3 out of 5 stars
3/5
()
About this ebook
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
Author
Joe Celko
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
Read more from Joe Celko
Joe Celko's SQL Puzzles and Answers Rating: 4 out of 5 stars4/5Joe Celko's SQL for Smarties: Advanced SQL Programming Rating: 3 out of 5 stars3/5Joe Celko's SQL Programming Style Rating: 4 out of 5 stars4/5Joe Celko's Analytics and OLAP in SQL Rating: 4 out of 5 stars4/5Joe Celko's Trees and Hierarchies in SQL for Smarties Rating: 0 out of 5 stars0 ratingsJoe Celko's Data, Measurements and Standards in SQL Rating: 0 out of 5 stars0 ratings
Related to Joe Celko's Thinking in Sets
Related ebooks
Physical Database Design: The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More Rating: 5 out of 5 stars5/5Relational Database Design Clearly Explained Rating: 5 out of 5 stars5/5Database Modeling and Design: Logical Design Rating: 0 out of 5 stars0 ratingsRelational Database Design and Implementation Rating: 5 out of 5 stars5/5Information Modeling and Relational Databases Rating: 0 out of 5 stars0 ratingsRelational Database Design and Implementation: Clearly Explained Rating: 0 out of 5 stars0 ratingsData Architecture: A Primer for the Data Scientist: A Primer for the Data Scientist Rating: 5 out of 5 stars5/5Data-Oriented Programming: Reduce software complexity Rating: 4 out of 5 stars4/5Data Mining: Know It All Rating: 0 out of 5 stars0 ratingsFuzzy Modeling and Genetic Algorithms for Data Mining and Exploration Rating: 5 out of 5 stars5/5Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data Rating: 0 out of 5 stars0 ratingsSQL Demystified Rating: 3 out of 5 stars3/5Data Mining: Concepts and Techniques Rating: 4 out of 5 stars4/5Oracle Data Warehouse Tuning for 10g Rating: 5 out of 5 stars5/5Designing Data-Intensive Web Applications Rating: 4 out of 5 stars4/5Data Science and Big Data Analytics: Discovering, Analyzing, Visualizing and Presenting Data Rating: 0 out of 5 stars0 ratingsData Lake Development with Big Data Rating: 0 out of 5 stars0 ratingsJoe Celko's Trees and Hierarchies in SQL for Smarties Rating: 0 out of 5 stars0 ratingsJoe Celko's Data, Measurements and Standards in SQL Rating: 0 out of 5 stars0 ratingsSQL Server 2016 Developer's Guide Rating: 0 out of 5 stars0 ratingsAn Introduction to Data Base Design Rating: 0 out of 5 stars0 ratingsDatabase Design: Know It All Rating: 5 out of 5 stars5/5100+ SQL Queries T-SQL for Microsoft SQL Server Rating: 4 out of 5 stars4/5Practical SQL Rating: 4 out of 5 stars4/5SQL Server 2017 Integration Services Cookbook Rating: 0 out of 5 stars0 ratingsQuerying with SQL T-SQL for Microsoft SQL Server Rating: 3 out of 5 stars3/5SQL Server MVP Deep Dives Rating: 0 out of 5 stars0 ratingsSql Simplified:: Learn to Read and Write Structured Query Language Rating: 0 out of 5 stars0 ratingsOrganizing Information: Principles of Data Base and Retrieval Systems Rating: 4 out of 5 stars4/5
Programming For You
Java for Beginners: A Crash Course to Learn Java Programming in 1 Week Rating: 5 out of 5 stars5/5Game Development with Unreal Engine 5: Learn the Basics of Game Development in Unreal Engine 5 (English Edition) Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Coding All-in-One For Dummies Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5HTML & CSS: Learn the Fundaments in 7 Days Rating: 4 out of 5 stars4/5C# Programming from Zero to Proficiency (Beginner): C# from Zero to Proficiency, #2 Rating: 0 out of 5 stars0 ratingsPython Programming : How to Code Python Fast In Just 24 Hours With 7 Simple Steps Rating: 4 out of 5 stars4/5Python: For Beginners A Crash Course Guide To Learn Python in 1 Week Rating: 4 out of 5 stars4/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5Learn JavaScript in 24 Hours Rating: 3 out of 5 stars3/5Python QuickStart Guide: The Simplified Beginner's Guide to Python Programming Using Hands-On Projects and Real-World Applications Rating: 0 out of 5 stars0 ratingsPYTHON: Practical Python Programming For Beginners & Experts With Hands-on Project Rating: 5 out of 5 stars5/5Python Machine Learning By Example Rating: 4 out of 5 stars4/5Problem Solving in C and Python: Programming Exercises and Solutions, Part 1 Rating: 5 out of 5 stars5/5Python Data Structures and Algorithms Rating: 5 out of 5 stars5/5Linux: Learn in 24 Hours Rating: 5 out of 5 stars5/5The Unofficial Guide to Open Broadcaster Software: OBS: The World's Most Popular Free Live-Streaming Application Rating: 0 out of 5 stars0 ratingsPython GUI Programming Cookbook - Second Edition Rating: 5 out of 5 stars5/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5
Reviews for Joe Celko's Thinking in Sets
Rating: 3 out of 5 stars
3/5
2 ratings0 reviews
Book preview
Joe Celko's Thinking in Sets - Joe Celko
Enjoying the preview?
Page 1 of 1