SQL Server Course for Beginners with 100+ examples - Create a Table

The video tutorial demonstrates how to create a new database and table in SQL Server. It begins with creating a database named 'Amiddb' and entering it using the 'use' command. The tutorial then guides viewers through creating an 'employee' table with columns for ID, employee name, city, and salary, specifying data types for each. The process concludes with executing the commands and verifying the table's creation in the object explorer.

What command is used to create a new database in SQL Server?

• CREATE DATABASE

• CREATE TABLE

• INSERT INTO

• SELECT DATABASE

Before creating a table, what must you do after creating a database?

• Export the database

• Delete the database

• Rename the database

• Use the database

Which command is used to start creating a new table in SQL Server?

• CREATE DATABASE

• ALTER TABLE

• CREATE TABLE

• DROP TABLE

What data type is used for the 'ID' column in the employee table?

• VARCHAR

• CHAR

• TEXT

• INT

How many columns were added to the employee table in the tutorial?

• Two

• Three

• Four

• Five