2Ensuring Your Database Structure Is Sound

“We shape our buildings: thereafter, they shape us.”

—SIR WINSTON CHURCHILL

Most of you reading this book are probably working with an existing database structure implemented on your favorite (I hope) RDBMS program. It’s hard for me to assume, at this point, whether or not you—or the person who developed the database—really had the necessary knowledge and skills or the time to design the database properly. Assuming the worst, you probably have a number of tables that could use some fine-tuning. Fortunately, you’re about ...

Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.