Head First SQL, 2nd Edition

Chapter 5. CRUD Operations Controlling Your Data

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

Figure 5-1.  

Ready to have complete control over your data? The commands you’re about to learn will round out your knowledge, revealing you for the SQL powerhouse you truly are. You can already create any database you’d like, even one for nearby restaurants so you don’t have to keep those 39 takeout menus in your kitchen’s junk drawer anymore. You can add data about your favorite dives and diners and look up late-night joints that are open 24/7.

But what happens if your local hangout changes its hours of operation? Or–horror–what if it closes all together and you need to remove it from your data? Not only do databases need to be created, they also need to be maintained by updating or deleting information when necessary. In this chapter, you’ll learn how to take full control of your ...