RELATIONAL DATABASES & SQL • ABOUT RELATIONAL DATABASES • ELEMENTS OF SQL

CHOOSING A SQL & PL/SQL INTERFACE • ABOUT DATABASE CONNECTIONS • ABOUT BIND VARIABLES • USING SQL DEVELOPER • USING SQL*PLUS • USING APPLICATION EXPRESS

BUILDING A SELECT STATEMENT • ABOUT THE SELECT STATEMENT • USING ALIAS NAMES

RESTRICTING DATA WITH THE WHERE CLAUSE • ABOUT LOGICAL OPERATORS • EQUALITY OPERATOR • BOOLEAN OPERATORS • NULL & BETWEEN OPERATORS • IS [NOT] NULL Operator • [NOT] BETWEEN Operator • FINDING TEXT STRINGS • [NOT] LIKE Operator • REGEXP_LIKE() • IN OPERATOR

SORTING DATA WITH THE ORDER BY CLAUSE • ABOUT THE ORDER BY CLAUSE • MULTIPLE COLUMN SORTS • SPECIFYING THE SORT SEQUENCE • ABOUT NULL VALUES WITHIN SORTS • USING COLUMN ALIASES

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

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

USING THE SET OPERATORS • ABOUT THE SET OPERATORS • SET OPERATOR EXAMPLES

SUMMARY FUNCTIONS • ABOUT SUMMARY FUNCTIONS • SUMMARY FUNCTIONS WITH DISTINCT

USING SUB-QUERIES • ABOUT SUB-QUERIES • STANDARD SUB-QUERIES • CORRELATED SUB-QUERIES

AGGREGATING DATA WITHIN GROUPS • ABOUT SUMMARY GROUPS • FINDING GROUPS WITHIN THE BASE TABLES • SELECTING DATA FROM THE BASE TABLES • SELECTING GROUPS FROM THE RESULT TABLE

BUILD SIMPLE SQL*PLUS REPORTS • FORMAT COLUMN OUTPUT WITH COLUMN • DEFINING REPORT BREAKS WITH BREAK • PRODUCE SUBTOTALS WITH COMPUTE

USE DATA DEFINITION LANGUAGE TO CREATE & MANAGE TABLES • CREATE TABLE STATEMENT • NOT NULL • DEFAULT • ALTER TABLE STATEMENT • DROP TABLE STATEMENT • SUPPORTIVE STATEMENTS • DESCRIBE • RENAME

USE DATA MANIPULATION LANGUAGE TO MANIPULATE DATA • ABOUT THE INSERT STATEMENT • ABOUT THE DELETE STATEMENT • ABOUT THE UPDATE STATEMENT • ABOUT TRANSACTIONS • ROLLBACK • COMMIT • SAVEPOINT • SET TRANSACTION • TRUNCATE TABLE • COMPLEX TABLE REFERENCES

APPENDIX A • REFERENCE INFORMATION • SQL DDL STATEMENT REFERENCE • SQL DML STATEMENT REFERENCE • SQL TRANSACTION CONTROL STATEMENT REFERENCE • SQL OPERATORS REFERENCE