Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Tables in SQL

Revision
1. Quick revision of creating tables

Instruction

Hello again! Before we move on to another big part, let's devote a tiny bit of our time to review. We want to make sure you know the basics inside out.

So, how do we create tables? Let's review it quickly:

CREATE TABLE game (
   id int,
   name varchar(32)
);

As you can see, we created a table named game with the columns called

  • id of type int and
  • name of type varchar(32).
Nothing particularly surprising, right?

Exercise

Now we're going to make a quick review of all the data types used to create columns. Are you ready? Click the Next exercise button!