SELECT Field(s) FROM database.table (optional) WHERE [Logical_Expression] (optional) GROUP BY [Field(s)] (optional) HAVING [Logical_Expression]
(optional) ORDER BY [Field(s)]
DISPLAY ALL FIELDS:
SELECT * FROM hr.Employees;

*NO QUOTES FOR NUMBERS
*’YYYY-MM-DD’
*IS NULL can be used as WHERE condition

INTERSECTION CONDITION:
SELECT fields FROM database.table
WHERE condition AND condition;
UNION CONDITION:
SELECT fields FROM database.table
WHERE condition OR condition;
RANGE CONDITION:
BETWEEN 5000 AND 10000 or combination of AND & RELATIONAL OPERATORS
NOT (not !=):
WHERE NOT (salary >= 5000 OR job_id = 'IT_PROG') ;
*AND has precedence over OR
USE % AS PLACEHOLDER FOR INDEFINITE NUMBER OF CHARACTERS:
SELECT * FROM hr.employees
WHERE last_name LIKE '%a%a%'
USE _ AS PLACEHOLDER FOR EXACTLY ONE CHARACTER:
SELECT * FROM hr.employees
WHERE last_name LIKE 'Jo_'
LENGTH() FUNCTION:
SELECT first_name, LENGTH(first_name) FROM hr.employees
CREATE TABLE:
CREATE TABLE Animal_Disease (
Animal_ID DECIMAL (6,0),
Disease_ID DECIMAL(6,0),
Date DATE,
Treatment VARCHAR (30),
Caretaker_ID DECIMAL (6,0)
CONSTRAINT AD_PK PRIMARY KEY (Animal_ID, Disease_ID)
CONSTRAINT Caretaker_FK FOREIGN KEY (Caretaker_ID) REFERENCES Caretaker (Caretaker_ID) );
OR
CREATE TABLE Animal_Disease (
Animal_ID DECIMAL (6,0) PRIMARY KEY,
Disease_ID DECIMAL(6,0),
Date DATE,
Treatment VARCHAR (30),
Caretaker_ID DECIMAL (6,0)
CONSTRAINT Caretaker_FK FOREIGN KEY (Caretaker_ID) REFERENCES Caretaker (Caretaker_ID) );

*CAN USE THE ABOVE CONSTRAINT FOR COMPOSITE OR SINGULAR PRIMAR KEYS
CHECK CONSTRAINT:
CHECK (Gender IN ('M', 'F'))
DEFAULT CONSTRAINT:
DEFAULT 'FLEA'
FOREIGN KEY CONSTRAINTS:
ON DELETE SET NULL ON UPDATE SET NULL
ON DELETE CASCADE ON UPDATE CASCADE
DROPPING TABLE:
DROP TABLE tablename
ALTERING