O'Reilly logo

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition by Michael J. Hernandez, John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required