SQL Lecture: Data Definition Language Part1

This video is a recorded lecture from an undergraduate Database course at McMaster University.
In this video, we learn the basics of SQL Data Definition Language (DDL).
DDL refers to set of commands to create and modify the structure of database objects (e.g., tables, views, schemas, indexes, etc.). The goal of DDL is to enable the implementation of the relational schema as an actual relational database. Example commands are: CREATE, ALTER, DROP

Below is the video timestamp:
00:00:00 Quick review of previous session: primary key (PK) and foreign key (FK)
00:05:55 Intro to SQL
00:09:54 Intro to Data Definition Language (DDL)
00:17:40 SQL Data Types
00:21:30 Create or define a table in SQL (define columns, data types, PK and FKs)
00:37:00 Data Entry (Insert data) into a SQL table (including integrity control check when inserting data)
00:48:37 Alter table structure in Microsoft SQL Server
00:53:32 Delete a table from database

**********Practical Part: Practice using SQL Server**********
Important Note: The assumption is that you already installed the Microsoft SQL Server Management Studio on your computer (or you have access to a SQL server).
Also, if you are not a student in my class at McMaster, you can skip the first few minutes in the practical part (starting 00:55:35 until 00:56:45) which is only for students in my class to guide them to access the SQL server on a virtual lab (the SQl server resides on university servers).
00:56:45 Practice what we learnt using SQL Server :)