Head First SQL, 2nd Edition

Chapter 1. Databases and Tables: Organizing Your Information

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 1st chapter of the final book. Please note that the GitHub repo will be made active later on.

If you have comments about how we might improve the content and/or examples in this book, or if you notice missing material within this chapter, please reach out to the editor at [e-mail].

It’s time to bring order to your data. These days, just about every aspect of life involves data: the applications on your phone, the appearance of your social media feed, and even those detailed notes you take about your flossing habits. But all that information can only be useful if it’s arranged in a meaningful way so you can find what you want, when you want it.

You need a system to help you store and organize your data, and you need it now. Tables allow you to establish law and order and to craft your bits of info into rich assets, ready to be mined for insights. So turn the page, come on in, and get ready to enjoy the orderly world of relational databases.

Defining your data

Abby’s created quite a large assortment of notebooks, scraps of paper, and other ...