From the course: PostgreSQL Essential Training
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Challenge: Create a table - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Challenge: Create a table
(bright upbeat music) - [Narrator] Let's apply what we've seen so far to the first challenge for this course. I'd like you to add a new table to the fruit database and fill in some values. The table will store information about different kinds of berries, including an ID number that you make up, a common name for the berry, as well as the colors when they're ripe. Feel free to add in any additional columns that you'd like, and think about the data types that will be appropriate for that information. Finally, add a few rows of data to the table for your favorite types of berries. This challenge should take about five minutes to complete. In the next movie, I'll show you how I'd approach the challenge. 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.