SQL Primer: An Accelerated Introduction to SQL Basics

©  Rahul Batra 2018

Rahul BatraSQL Primerhttps://doi.org/10.1007/978-1-4842-3576-8_7

7. Organizing Your Data

Rahul Batra¹ 

(1)

Gurgaon, Haryana, India

 

Since this is a text meant to teach SQL to people unfamiliar with it, our data has been very simplistic. The number of fields you’d wish to store in your database would be a larger value than the five-column table we saw in earlier chapters. Also, some assumptions were made intrinsically on the kind of data we will store in the table. But this is not always the case in real life.

In reality the data we encounter will be complex, even redundant. This is where the study of data modeling techniques and database design come in. While it is advised that the reader refer to a more comprehensive treatise on ...