RELATIONAL DATABASES & SQL • ABOUT RELATIONAL DATABASES • ELEMENTS OF SQL
USING SQL*PLUS • ABOUT SQL*PLUS • USING THE MS WINDOWS SQL*PLUS TOOL • USING THE ISQL*PLUS WEB TOOL • ENTERING COMMANDS & SYNTAX
BUILDING A SELECT STATEMENT • ABOUT THE SELECT STATEMENT • SELECTING COLUMNS • USING ALIAS NAMES
BUILDING A WHERE CLAUSE • ABOUT LOGICAL OPERATORS • EQUALITY OPERATOR • BOOLEAN OPERATORS • NULL & BETWEEN OPERATORS • FINDING TEXT STRINGS • IN OPERATOR
ORDERING THE RESULT TABLE • ABOUT THE ORDER BY CLAUSE • MULTIPLE COLUMN SORTS • SPECIFYING THE SORT SEQUENCE • ABOUT NULL VALUES WITHIN SORTS • USING COLUMN ALIASES
PSEUDO COLUMNS & FUNCTIONS • ABOUT PSEUDO COLUMNS & FUNCTIONS • USING ROWID • USING ROWNUM • USING THE FUNCTIONS • USING THE DUAL TABLE • SESSIONTIMEZONE FUNCTION
JOINING TABLES • ABOUT JOINS • INNER JOIN • REFLEXIVE JOIN • NON-KEY JOIN • OUTER JOIN
USING SET OPERATORS • ABOUT THE SET OPERATORS • SET OPERATOR EXAMPLES
SUMMARY FUNCTIONS • ABOUT SUMMARY FUNCTIONS • SUMMARY FUNCTIONS WITH DISTINCT
USING SUBQUERIES • ABOUT SUBQUERIES • STANDARD SUBQUERIES • CORRELATED SUBQUERIES
CREATING & SELECTING GROUPS • ABOUT SUMMARY GROUPS • FINDING GROUPS WITHIN THE BASE TABLES • SELECTING DATA FROM THE BASE TABLES • SELECTING GROUPS FROM THE RESULT TABLE
SQL*PLUS COMMANDS • ABOUT SQL*PLUS COMMANDS • MORE ABOUT SCRIPT FILES • INVOKING OPERATING SYSTEM COMMANDS • SAVING SESSION OUTPUT
BUILD SIMPLE SQL*PLUS REPORTS • ABOUT THE SQL*PLUS REPORT FEATURES • SESSION OUTPUT WITH SET • FORMAT COLUMN OUTPUT WITH COLUMN • DEFINING REPORT BREAKS WITH BREAK • PRODUCE SUBTOTALS WITH COMPUTE
SQL DATA DEFINITION LANGUAGE • ABOUT SQL DDL • CREATE TABLE STATEMENT • ALTER TABLE STATEMENT • DROP TABLE STATEMENT • SUPPORTIVE STATEMENTS
SQL DATA MANIPULATION LANGUAGE • ABOUT SQL DML • ABOUT THE INSERT STATEMENT • ABOUT THE DELETE STATEMENT • ABOUT THE UPDATE STATEMENT • ABOUT TRANSACTIONS • TRUNCATE TABLE • COMPLEX TABLE REFERENCES
