Chapter 9 SQL Data Types


Not everything that counts can be counted, and not everything that can be counted counts.

  --Albert Einstein

Welcome to the first of three chapters in this book about database design. If you’ve followed along faithfully until now, well done. Several chapters were needed to cover the SELECT statement in detail, so that we could gain an appreciation for how tabular data is extracted from the database, filtered, summarized, presented, and sequenced. Now it’s time to turn our attention to the challenges of creating database tables.

Creating tables is straightforward, with only a few tricky aspects to watch out for. These are encountered primarily when deciding how tables should be related to each other, ...

Get Simply SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.