Explain what each of CREATE TABLE, ALTER TABLE, ALTER COLUMN, and DROP TABLE statements does, and discuss any risk you could face when using these statements.

Explain what each of SELECT, INSERT, UPDATE, and DELETE statements does, and discuss any risk you could face when using these statements.

Identify three types of data models and explain why we need each of these types of models.

Identify three types of table joins and explain why we need each of these joining methods.

Define the purpose of a union statement and explain how it is different than a join. Discuss when you would use a union vs a join and why.

Identify $3$ aggregate functions and explain what each does. Additionally, explain how using aggregate functions will restrict the fields a query can return.

Explain the difference between Static and Dynamic SQL$,$ and explain a how to code a Dynamic SQL statement.

Explain the purpose of an execution plan is and how it will help you refine your query. Additionally, identify the types of information an execution plan will show about a query.

Define what is meant by relational database design and how database design affects retrieving and storing information in a database. Additionally, explain how database normalization is part of database design.

Explain what is database security and why it is important, and identify three types of database security $.$