Job-Ready SQL in an Afternoon - Altering Tables

The video tutorial explains how to use the SQL 'Alter Table' command to modify database tables. It covers adding, dropping, and modifying columns, including changing data types. The tutorial emphasizes the importance of understanding situational needs and encourages using online resources for specific queries.

What command is used to add a new column to an existing table?

Describe the process of removing a column from a table.

How can you change the data type of an existing column in a table?

What considerations should be taken into account when altering a table?

Explain the importance of using a semicolon at the end of SQL commands.