From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Challenge: Create a table

Challenge: Create a table

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial Buy for my team

Challenge: Create a table

“

(upbeat music) - [Instructor] For your next challenge, I'd like you to continue working on the Kinetico database that you set up in the prior challenge. This time, your goal is to add in a new schema and the first data table using SQL commands. First, create a schema called HumanResources. Then create a table for the company's employees in that schema. The employee table should have a column for the employee ID, their first and last name, department, and their hire date. I estimate that this challenge will take about 10 minutes or less to complete and in the next movie I'll show you how I'd accomplished these goals. Good luck.

Contents