Your first table
1. Welcome
CREATE TABLE basics
Entity Relationship Diagrams (ERD)
DROP - how to remove a table

Instruction

Welcome to the course Creating Tables in SQL. We assume that you already know how to use tables in a database: how to create queries and how to modify data in them. If not, why don't you check out our previous courses first? We have a course on SQL queries and another one about data operations in SQL.

In this course, you're going to learn how to create tables. You're now going to create your very first table. See that SQL code on the right? You may not understand it yet, but don't worry. We'll explain the instructions in this course.

Exercise

Peter loves toys and he decided to open a museum of childhood in his city. In the museum, he wants to show various kinds of toys from the past, coming from all over the world.

As you can see, he has already written some code. This code is going to create a table where he will store data about all of his exhibits. Why don't you help him create it? Press Run and check code to see how the table is created.

Stuck? Here's a hint!

Don't do anything special, just press Run and check code to create the table.

Console

Code editor

Result

TableConsole