From the course: Database Foundations: Intro to Databases
Join today to access over 24,800 courses taught by industry experts.
Challenge: Add data to a table
From the course: Database Foundations: Intro to Databases
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…
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.