What is a composite key?

What is a foreign key?

What is a primary key?

What’s the difference between a view and a materialized view?

What is a view? When would you use one?

What is the purpose of the IN keyword?

What is the purpose of the BETWEEN keyword?

What are the different DML commands in SQL? Give a description of their purpose.

What are the different DDL commands in SQL? Give a description of their purpose.

What is the difference between SQL and T-SQL?