1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to SQL Server

Exercise

Insert

This exercise consists of two parts: In the first, you'll create a new table very similar to the one you created in the previous interactive exercise. After that, you'll insert some data and retrieve it.

You'll continue working with the Chinook database here.

Instructions 1/2

undefined XP
    1
    2
  • Create a table called tracks with 2 VARCHAR columns named track and album, and one integer column named track_length_mins. Then SELECT all columns from your new table using the * shortcut to verify the table structure.