Relational Database and SQL Overview

Review of Relational Database Terminology
Introduction to SQL
Oracle Versioning and History
Logical and Physical Storage Structures
Connecting to a SQL Database
Datatypes
Sample Database

Using Oracle SQL*Plus

SQL*Plus
The SQL Buffer
Buffer Manipulation Commands
Running SQL*Plus Scripts
Tailoring Your SQL*Plus Environment
Viewing Table Characteristics
SQL*Plus Substitution Variables
Interactive SQL*Plus Scripts

SQL Queries - The SELECT Statement

The SELECT Statement
The CASE...WHEN Statement
Choosing Rows with the WHERE Clause
NULL Values
Compound Expressions
IN and BETWEEN
The LIKE Operator
Creating Some Order

Scalar Functions

SQL Functions
Using SQL Functions
String Functions
Numeric Functions
Date Functions
Conversion Functions
Date Formats

SQL Queries - Joins

Selecting from Multiple Tables
Joining Tables
Self Joins
Outer Joins
Types of Outer Joins

Aggregate Functions and Advanced Techniques

Subqueries
Correlated Subqueries
The EXISTS Operator
The Aggregate Functions
Grouping Rows
ROLLUP and CUBE
Combining SELECT Statements

Data Manipulation and Transactions

The INSERT Statement
The UPDATE Statement
The DELETE Statement
Transaction Management
Concurrency
Explicit Locking
Data Inconsistencies
Loading Tables From External Sources

Data Definition and Control Statements

Standard Datatypes
Defining Tables
Constraints
Inline Constraints
Modifying Table Definitions
Deleting a Table Definition
Controlling Access to Your Tables

Indexes

Indexes
B-tree Indexes
Reverse Key and Unique Indexes
Function-Based Indexes
Bitmap Indexes
Index-Organized Tables
Managing Indexes

Other Database Objects

Views
Creating Views
Updateable Views
Sequences
Synonyms
Global Temporary Tables

Formatting Reports with SQL*Plus

Page Formatting
Computations
SQL*Plus Options for Formatting
Saving the Output

Appendix A - The Data Dictionary

Introducing the Data Dictionary
DBA, ALL, and USER Data Dictionary Views
Some Useful Data Dictionary Queries