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

7. Organizing Your Data

Rahul Batra1 
(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 ...

Get SQL Primer: An Accelerated Introduction to SQL Basics 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.