Head First SQL, 2nd Edition

Chapter 8. Alter Changing and Optimizing

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 8th 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].

Wish you could correct your mistakes or make upgrades? Well, now’s your chance. If your table’s check engine light is on, consider making some improvements. You can use the ALTER command to apply all the lessons you’ve been learning about database design to tables you created days, months, or even years ago. Even better, you’re able to do it without affecting your underlying data. By the time you’re through with this overhaul chapter, you’ll also know about other ways you can optimize your data storage and turbocharge your query speed. And you’ll encounter string functions and table aliasing to refurbish your old clunker tables into dazzling beauties in mint–normal–condition. It’s time to put on your mechanic overalls and give your data a tune-up.

Summer camp chaos

The year is off to ...