Table of Contents Back Cover
Synopsis by Dean Andrews In this book, outspoken database magazine columnist Joe Celko waxes philosophic about fundamentalconcepts in database design and development. He points out misconceptions and plain ol' mistakes commonly made while creating databases including mathematical calculation errors, inappropriate key field choices, date representation goofs and more. Celko also points out the quirks in SQL itself. A detailed table-of-contents will quickly route you to your area of interest.
Table of Contents JoeCelko’s Data and Databases: Concepts in Practice - 4 Preface - 6 Chapter 1 - The Nature of Data - 13 Chapter 2 - Entities, Attributes, Values, and Relationships - 23 Chapter 3 - Data Structures - 31 Chapter 4 - Relational Tables - 49 Chapter 5 - Access Structures - 69 Chapter 6 - Numeric Data - 84 Chapter 7 - Character String Data - 92 Chapter 8 - Logic and Databases - 104 Chapter 9 - Temporal Data- 123 Chapter 10 - Textual Data - 131 Chapter 11 - Exotic Data - 135 Chapter 12 - Scales and Measurements - 146 Chapter 13 - Missing Data - 151 Chapter 14 - Data Encoding Schemes - 163
Chapter 15 - Check Digits - 163 Chapter 16 - The Basic Relational Model - 178 Chapter 17 - Keys - 188 Chapter 18 - Different Relational Models - 202 Chapter 19 - Basic Relational Operations - 205 Chapter20 - Transactions and Concurrency Control - 207 Chapter 21 - Functional Dependencies - 214 Chapter 22 - Normalization - 217 Chapter 23 - Denormalization - 238 Chapter 24 - Metadata - 252 References - 258
Back Cover Do you need an introductory book on data and databases? If the book is by Joe Celko, the answer is yes. Data & Databases: Concepts in Practice is the first introduction torelational database technology written especially for practicing IT professionals. If you work mostly outside the database world, this book will ground you in the concepts and overall framework you must master if your data-intensive projects are to be successful. If you’re already an experienced database programmer, administrator, analyst, or user, it will let you take a step back from your work andexamine the founding principles on which you rely every day -- helping you work smarter, faster, and problemfree. Whatever your field or level of expertise, Data & Databases offers you the depth and breadth of vision for which Celko is famous. No one knows the topic as well as he, and no one conveys this knowledge as clearly, as effectively -- or as engagingly. Filled with absorbing war stories andno-holdsbarred commentary, this is a book you’ll pick up again and again, both for the information it holds and for the distinctive style that marks it as genuine Celko. Features: • • • Supports its extensive conceptual information with example code and other practical illustrations. Explains fundamental issues such as the nature of data and data modeling and moves to more specific technicalquestions such as scales, measurements, and encoding. Offers fresh, engaging approaches to basic and not-so-basic issues of database programming, including data entities, relationships and values, data structures, set operations, numeric data, character string data, logical data and operations, and missing data. Covers the conceptual foundations of modern RDBMS technology, making it an ideal choicefor students. About the Author
Joe Celko is a noted consultant, lecturer, writer, and teacher, whose column in Intelligent Enterprise has won several Reader’s Choice Awards. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on the DBMS CompuServe Forum, and, of course, his war stories, which provide real-world insight into SQL...