Fine-Tuning Tables
Tables serve as the basis for any SQL query you create. You’ll soon find that poorly designed tables pose data integrity problems and are difficult to work with when you create multi-table SQL queries. Because of this, you must make certain that your tables are structured as efficiently as possible so that you can easily retrieve the information you need.
What’s in a Name? (Part Two)
In the section on fields, you learned how important it is for a field to have an appropriate name and why you should give serious thought to naming your fields. In this section, you’ll learn that the same applies to tables as well. By definition, a table should represent a single subject. If it represents more than one subject, it should be divided ...
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second 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.
