From the course: Learning SQL Programming
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Solution: Practice working with data - SQL Tutorial
From the course: Learning SQL Programming
Solution: Practice working with data
(upbeat music) - [Instructor] Let's take a look at my solutions to this challenge. I've used one statement here to add the two people, and if you used one statement each, that's fine too. I'll run this, and then let's take a look at what's in the database now. I have 1,002 rows returned, and down here at the bottom, there's my two new entries. Because I didn't provide a value for Walter's age, that's null, but the database has stored these records for us. Here in DB Browser, I'll click to save. Let's move on to the changes that we need to make. Bonnie Brooks has let us know that she would like to change her choice of souvenir from a hat to a shirt, so we need to take care of that. To do that, this is the statement that I wrote. But before I run that, I should check to make sure there's only one person with that name. I'll select this query to run it, and there's just one person with this name, looks good. So I'll run…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.