What is the relational model?

What are the relational algebra operations?

How would you create a table and what data types are available?

How would you alter the tables structure once created?

How would you write an advanced query with filtering / wildcards / grouping and sorting?

How do you Insert/Update/Delete data from a table

Primary Keys - Enforce Entity Integrity
Foreign Keys - Enforce Referential Integrity

What is a candidate key? An alternate key?

How do you join tables to retrieve data from multiple tables?

How do you create a legal value constraint for a table?

What are the types of joins available?

What is the purpose of creating an index and how does it work?

What is a View and how is it different than a table?

How would tables implement a relationships:
 - one to one
 - one to many
 - many to many

What is a union statement, and what do the queries need to have to be union compatible?

What is the make-a-table (select into) query?

What is a Stored Procedure? How would create one?

What is a User Defined Function? How would you create one?

What is a Trigger? How does it work?

How do you normalize tables to 3NF?