From the course: Learning Azure SQL Querying
Join today to access over 24,600 courses taught by industry experts.
Solution: Update the product price - Azure Tutorial
From the course: Learning Azure SQL Querying
Solution: Update the product price
(upbeat music) - [Instructor] First, let's write a SELECT statement so that we can see the current list price of all the helmets and make sure our conditional is correct before we make any changes to the database. I'm going to start a new query tab and I'm going to type SELECT * FROM Product, the Products table. And then for my conditional, I'm going to type WHERE Name LIKE, and then I'm going to do a wild card search for "Helmet." Your query results should only include the products that are described as helmets. Helmets are also listed in the database as a product category, so bonus points if you joined in the ProductCategory table and selected out the records this way. That query would look something like this. We didn't give the test records that we previously inserted a product category, so it will be missing from this list, but you can always use one of the other methods to select it out if you want. But since a…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
