This video explains how to use the CREATE TABLE statement of the Structured Query Language (SQL). It is the first in a series about a subset of SQL known as the Data Definition Language (DDL), which can be used to create and modify the table structures within a relational database. It includes examples of how to use CREATE TABLE to make a new table while specifying the names and data types of the new columns. It also explains how a new table can be created by copying an existing table, and its data, with a SELECT statement. In addition, column properties such as DEFAULT and NOT NULL are covered. This video goes on to explain how to create a table with a primary key column, and how to establish a relationship between two tables by means of a FOREIGN KEY constraint.