SQL

CREATE DATABASE

CREATE USER

CREATE TABLE

DROP - Deletes a table, database or user

GRANT - Grants access/privalages to users

• INSERT INTO - Makes a new row in the table and adds the values suppplied in

E.g. INSERT INTO Customer (CustomerID, Email Address)

VALUES ('ABC1', 'fredbloggs@haha.com')

• UPDATE - Changes values in a table using a calculation

E.g. UPDATE Item

SET (UnitPrice * 2)

• DELETE - Deletes a row in a table

E.g. DELETE ItemPrice FROM Item