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: Create a table
From the course: Database Foundations: Intro to Databases
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.
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.