Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

M. SimonLeveling Up with SQLhttps://doi.org/10.1007/978-1-4842-9685-1_2

2. Working with Table Design

Mark Simon¹  

(1)

Ivanhoe VIC, VIC, Australia

 

SQL databases are, or at least should be, built on some pretty strong principles. Although these principles are sometimes relaxed in real life, the database will be more reliable and more efficient if they’re followed as far as possible.

In this chapter, we’re going to look at parts of the existing database and how it can be improved using some of those principles. We’ll look at

• The basic understanding of normal tables—tables which have been constructed or reconstructed along the core principles

• Modifying tables ...