Effective SQL: 61 Specific Ways to Write Better SQL, First Edition

Contents

Foreword

Acknowledgments

About the Authors

About the Technical Editors

Introduction

A Brief History of SQL

Database Systems We Considered

Sample Databases

Where to Find the Samples on GitHub

Summary of the Chapters

Chapter 1: Data Model Design

Item 1: Verify That All Tables Have a Primary Key

Item 2: Eliminate Redundant Storage of Data Items

Item 3: Get Rid of Repeating Groups

Item 4: Store Only One Property per Column

Item 5: Understand Why Storing Calculated Data Is Usually a Bad Idea

Item 6: Define Foreign Keys to Protect Referential Integrity

Item 7: Be Sure Your Table Relationships Make Sense

Item 8: When 3NF Is Not Enough, Normalize More

Item 9: Use Denormalization for Information Warehouses

Chapter 2: Programmability and Index ...