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 does data need to be created, it also needs to be maintained by updating or deleting information when necessary. In this chapter, you’ll learn how to take full control of your database with all the necessary CRUD operations. CRUD is a good thing here, so let’s get CRUDy!
What’s for dinner?
You recently moved to the big city of Dataville to attend college at DataU. Your reputation for SQL knowhow spread quickly, and you’ve already made friends with a fellow student and SQL enthusiast named Josh.
As it turns out, you and Josh are both major foodies, but most nights you meet up at the same local burger joint out of habit. You’ve recently gotten bored with their usuals, so you need a better way to decide where to eat.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
