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.

Challenge: Add new customer

Challenge: Add new customer - SQL Tutorial

From the course: Complete Your First Project in SQL

Start my 1-month free trial Buy for my team

Challenge: Add new customer

“

(light electronic music) - [Instructor] It's time for a challenge. H+ Sport has gained a new customer name, Jane Patterson, that has purchased some of their mineral waters. It is your job to add her information into the customer database to ensure the customer records stay updated. For this task, it is best to use an INSERT statement, like you did in the video where you learned how to insert a new product into a SQL data table. You will use the format displayed here for your INSERT Statement. This includes specifying the columns and associated values to insert into each column. Make sure you insert data into the customer data table for each of these columns. The columns you will need to list out are: CustomerID, FirstName, LastName, Email, Phone, Address, City, State, and Zipcode You will notice here that these are notated exactly how they are in the SQL database, so again, make sure the way you are spelling and capitalizing these columns are the same. For the values for each of these…

Contents