You need to be able to:

• Implement relational database using SQL Data Definition Language (DDL) and Data Manipulation Language (DML) to match the design.
• Describe, exemplify, and implement the following SQL operations:
  • CREATE statement:
    • CREATE DATABASE
    • CREATE TABLE
    • constraints:
      • primary key
      • foreign key
      • not null
      • check
      • auto increment
  • DROP statement:
    • DROP DATABASE
    • DROP TABLE
  • HAVING clause of the SELECT statement
  • subqueries used with the WHERE clause of SELECT statements
  • data types:
    • varchar
    • integer
    • float
    • date
    • time
  • logical operators:
    • IN
    • NOT
    • BETWEEN
    • ANY
    • EXISTS