From the course: Complete Your First Project in SQL

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

How to add a new product

How to add a new product - SQL Tutorial

From the course: Complete Your First Project in SQL

Start my 1-month free trial Buy for my team

How to add a new product

“

- [Instructor] Most retail stores cycle through the products they sell. H+ Sport is no different and continues to create new products to meet the needs of their customers. In particular, they want to expand their popular mineral water product line to add a new flavor option for their customers to choose from. H+ Sport plans to add a new great flavor option in the smaller bottle size to see if customers are interested in this new flavor. As H+ Sports data analysts, they need you to update their product database to allow salespeople to select it when creating orders for this new product. Let's head over to Codespaces to add this new product. Before you add the product though, let's take a moment to look at the product table. Here you can view the current mineral water products available to customers. You can see there are a variety of mineral water flavors available, such as blueberry, mango, peach, and strawberry. There are also two size options with corresponding prices and the status…

Contents