From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Challenge: Add data to a table

Challenge: Add data to a table

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial

Challenge: Add data to a table

“

(upbeat music) - [Instructor] Let's test what you've learned with another challenge. I'd like you to add some data to the Employees table in the KinetEco database that you've been working on. You should add a minimum of three rows for some newly hired employees. The names and other details that you choose don't really matter, so just use the names of your friends or family. Next, one of these employees was promoted, change their record to assign them to a different department. Finally, one of your employees decided to retire early, so I want you to remove their row from the table. One hint before we get started, date values can get entered in a number of different ways depending on your region. For the best results, treat them like text strings with values wrapped in single quotation marks. Then use a four-digit year, two-digit month and a two-digit day, all together with no punctuation. I estimate that this challenge…

Contents