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
