Oracle

A Brief History of Oracle
Introduction to Terms
Oracle Configurations
Roles of Database Administrator
Exploring the Oracle Architecture
Architecture Q&A
Architecture Quiz


SQL

A Brief History of SQL
Dr. Codd's 12 Rules
An Overview of SQL
The SELECT Statement
Expressions, Conditions, and Operators
Functions: Molding the Data You Retrieve
Clauses in SQL
Joining Tables
Sub Query
Manipulating Data

Design and Build a Database
Creating Views and Indexes
Controlling Transactions
Database Security
Advanced SQL Topics
Cursors
Creating and Using Stored Procedures
Designing and Using Triggers
Embedded SQL
Streamlining SQL Statements for Improved Performance
Using Views to Retrieve Useful Information from the Data Dictionary
Using SQL to Generate SQL Statements