RELATIONAL DATABASES & SQL ABOUT relational databases ELEMENTS of SQL

CHOOSING A SQL& PL/SQL INTERFACE ABOUT database connections ABOUT bind variables USING SQUL 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 operations EQUALITY operator BOOLEAN operators NULL & between operators IS (not) null operator (NOT) between operator FINDING text strings (NOT) like operator REGEXP_like() IN operator ABOUT the order by clause MULTIPLE column sorts SPECIFYING the sort sequence ABOUT null values within sorts USING column aliases PSEUDO columns & functions USING rowed USING rownum USING the functions SYSDATE USER & IUD USING the dual table SESSIONTIMEZONE function JOINING tables ABOUT joins INNER join REFLEXIVE join NON-KEY join OUTER join

USING THE SET UP OPERATORS ABOUT the set operators SET operator examples

SUMMARY FUNCTIONS ABOUT summary functions SUMMARY operator examples

USING SUB-QUERIES ABOUT sub-queries STANDARD sub-queries CORRELATED sub-queries

AGGGREGATING DATA WITHIN GROUPS ABOUT summary groups FINDING groups within the base tables SELECTIONS data from the base tables SELECTIONG groups from the result tables

BUILD SIMPLE SQL*PLUS RESORTS 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

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 UNDERSTAND 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 CREATE schema authorization

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

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

ADVANCED SQL*PLUS REPORTS BREAK COMPUTE COLUMN TTITLE & BTITLE

OPTIONAL-BUILDING SQL*PLUS SCRIPTS USING SQL*plus variables DEFINE and undefined ACCEPT PROMPT PAUSE

OPTIONAL -SQL*PLUS SESSION CONTROL CONTROLLING system variables SET SHOW