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

ENHANCING GROUPS WITH ROLLUP & CUBE • USING ROLLUP • USING CUBE

USING THE CASE EXPRESSION

SQL FUNCTIONS: CHARACTER • STRING FORMATTING FUNCTIONS • ASCII CODES FUNCTIONS • PAD & TRIM FUNCTIONS • STRING MANIPULATION FUNCTIONS • STRING COMPARISON FUNCTIONS • PHONETIC SEARCH FUNCTIONS

SQL FUNCTIONS: NUMERIC • ABOUT THE NUMERIC FUNCTIONS • NULL VALUE FUNCTIONS

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

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

DATABASE OBJECTS: DATA DICTIONARY STORAGE • ABOUT THE DATA DICTIONARY • OBJECT-SPECIFIC DICTIONARY VIEWS • USER_UPDATABLE_COLUMNS • UNDERSTANDING THE DATA DICTIONARY STRUCTURE

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

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

DATABASE OBJECTS: SECURITY • USER PASSWORDS • OBJECT SECURITY

DATA INTEGRITY USING CONSTRAINTS • ABOUT CONSTRAINTS • NOT NULL CONSTRAINT • CHECK CONSTRAINT • UNIQUE CONSTRAINT • PRIMARY KEY CONSTRAINT • REFERENCES CONSTRAINT • DEFINING CONSTRAINTS ON EXISTING TABLES

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

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

OPTIONAL - ADVANCED SQL*PLUS REPORTS • REPORT-1 • REPORT-2 • SOLUTIONS • REPORT-1 • REPORT-2

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

OPTIONAL - SQL*PLUS SESSION CONTROL • CONTROLLING SYSTEM VARIABLES • SET • SHOW