SQL99 JOIN TECHNIQUES • CROSS JOINS • NATURAL JOINS • INNER JOINS • OUTER JOINS • ANTI JOINS • USING NAMED SUBQUERIES

ENHANCING GROUPS WITH ROLLUP & CUBE

USING THE CASE EXPRESSION

SQL FUNCTIONS: CHARACTER • WHAT ARE THE SQL FUNCTIONS? • CHARACTER FUNCTIONS • About GREATEST(), LEAST()

SQL FUNCTIONS: NUMERIC

SQL FUNCTIONS: DATE • DATE FORMAT FUNCTIONS • DATE ARITHMETIC FUNCTIONS

DATABASE OBJECTS: RELATIONAL VIEWS • ABOUT RELATIONAL VIEWS • UPDATING VIEW DATA • MAINTAINING VIEW DEFINITIONS • ALTER VIEW • DROP VIEW

DATABASE OBJECTS: DATA DICTIONARY STORAGE • USER_UPDATABLE_COLUMNS • UNDERSTANDING THE DATA DICTIONARY STRUCTURE

DATABASE OBJECTS: INDEXES • ABOUT INDEXES • USE B-TREE INDEXES

DATABASE OBJECTS: OTHER OBJECTS • CREATING AN APPLICATION SCHEMA • MORE ABOUT CREATING TABLES • DEFINING SEQUENCES • ALTER SEQUENCE & DROP SEQUENCE • ALTER SEQUENCE • DROP SEQUENCE • ABOUT SYNONYMS • DROP SYNONYM • CREATE SCHEMA AUTHORIZATION

DATABASE OBJECTS: SECURITY • USER ID PASSWORDS • OBJECT SECURITY

DATA INTEGRITY USING CONSTRAINTS • NOT NULL CONSTRAINT • CHECK CONSTRAINT • UNIQUE CONSTRAINT • PRIMARY KEY CONSTRAINT • REFERENCES CONSTRAINT

MANAGING CONSTRAINT DEFINITIONS • MANAGING CONSTRAINTS • RENAMING & DROPPING CONSTRAINTS • ENABLING & DISABLING CONSTRAINTS • DEFERRED ENFORCEMENT • SET CONSTRAINTS • HANDLING CONSTRAINT EXCEPTIONS • DATA DICTIONARY STORAGE

OPTIONAL – ADVANCED SQL*PLUS REPORTS • BREAK • COMPUTE • COLUMN • TTITLE & BTITLE

OPTIONAL – BUILDING SQL*PLUS SCRIPTS • USING SQL*PLUS VARIABLES • DEFINE & UNDEFINE • ACCEPT • PROMPT • PAUSE