SQL DATA DEFINITION LANGUAGE • CREATE TABLE STATEMENT • NOT NULL • DEFAULT • ALTER TABLE S_BLELT • DROP TABLE STATEMENT • DESCRIBE • RENAME • ADDITIONAL DATABASE OBJECTS

USING THE SQL*PLUS TOOL • SESSION CONTROL COMMANDS • BUFFER CONTROL COMMANDS • SQL BUFFER EDITING COMMANDS

SQL DATA MANIPULATION LANGUAGE • ABOUT THE SELECT STATEMENT • ABOUT THE INSERT STATEMENT • ABOUT THE DELETE STATEMENT • ABOUT THE UPDATE STATEMENT • ABOUT TRANSACTIONS • COMPLEX TABLE REFERENCES • BUILDING A SELECT CLAUSE • SELECTING COLUMNS • USING ALIAS NAMES

BUILDING A WHERE CLAUSE • EQUALITY OPERATOR • BOOLEAN OPERATORS • NULL & BETWEEN OPERATORS • FINDING TEXT STRINGS • IN OPERATOR

ORDERING THE RESULT TABLE • MULTIPLE COLUMN SORTS • SPECIFYING THE SORT SEQUENCE • ABOUT NULL VALUES WITHIN SORTS • USING COLUMN ALIA_N

PSEUDO COLUMNS & FUNCTIONS • USING ROWID • USING ROWNUM • USING THE FUNCTIONS • SYSDATE • USER & UID • USING THE DUAL TABLE

JOINING TABLES • ABOUT JOINS • INNER JOIN • REFLEXIVE JOIN • NON-KEY JOIN • OUTER JOIN

USING SET OPERATORS • SET OPERATOR EXAMPLES • PERFORMING A FULL OUTER JOIN

SUMMARY FUNCTIONS

USING SUBQUERIES • STANDARD SUBQUERIES • CORRELATED SUBQUERIES • CREATING & SELECTING GROUPS • FINDING GROUPS WITHIN THE BASE TABLES • SELECTING DATA FROM THE BASE TABLES • SELECTING GROUPS FROM THE RESULT TABLE

CREATING & USING RELATIONAL VIEWS

CREATING & USING INDEXES & SYNONYMS

UNDERSTANDING THE DATA DICTIONARY

BUILD SIMPLE SQL*PLUS REPORTS • SESSION CONTROL WITH SET • FORMAT COLUMN OUTPUT WITH COLUMN • PRODUCE SUBTOTALS WITH COMPUTE