Implementation

• What are the four types of query?

  Select, Insert, Update, Delete
• Select statement outline?

  SELECT

  FROM

  WHERE

  ORDER BY
• How do you select everything?

  *
• Insert statement outline?

  INSERT INTO

  VALUES
• Update statement outline?

  UPDATE

  SET

  WHERE
• Delete statement outline?

  DELETE FROM

  WHERE
• What do you need when linking two tables?

  Equi-join
• How do you lay out an equi-join?

  WHERE table1.primarykey = table2.foreignkey
• What do you need at the end of every query?

  ;