Database Design

• Database Models
• Beginnings
• Some Introductory Terminology
• Codd’s 12 Rules
• Normalization
• First Normal Form
• Higher Order Normal Forms

Oracle Standard Interfaces

• Sql
• Viewing A Sample Table
• The Graphical User Interface
• The Web-Based Interface
• Describe

The Sample Database

• The Entity Relationship Model
• Entity Relationship Diagrams
• The Sample Database
• Er Diagram For Sample Database
• Creating The Sample Data
• Viewing Sample Data
• Data Types Of The Sample Data

Data Definition Language

• Categories Of Sql Statements
• Oracle Datatypes
• The Create Statement
• The Drop Command
• The Alter Command
• Integrity Constraints
• Entity Integrity Constraints
• Referential Integrity Constraints
• Modifying Table To Use Constraints
• Checking Constraints
• The Data Dictionary

Data Manipulation Language

• Dml Statements
• The Select Statement
• The Insert Statement
• The Delete Statement
• The Update Statement

Transaction Control

• Transactions
• Command Classification
• Savepoints
• The Set Transaction Command

 Groups

• SQL Statements
• GROUP BY Clause
• HAVING Clause
• Order of a SELECT Statement

SQL Operators

• Simple Selects
• Comparison Operators
• In And Not In Operators
• Between Operator
• The Like Operator
• Logical Operators
• Is Null And Is Not Null
• Any
• All

SQL FUNCTIONS

• Introduction
• The DISTINCT Keyword
• Aliases
• Miscellaneous Functions
• Mathematical Functions
• String Functions
• Date Functions
• Conversion Functions
• Pseudo Columns

 Joining Tables

• Joins
• Inner Joins
• Equi-Join
• Table Aliases
• Outer Joins
• Right Outer Join
• Left Outer Join
• Full Outer Join
• Oracle-Specific Syntax for Outer Joins

 Set Operators

• Introduction
• Selection Criteria
• Union
• Union All
• Intersect
• Minus

 SQL Subqueries

• Introduction
• Using a Subquery with a DML Statement
• Typical Subqueries
• Subquery Operators
• Standard vs. Correlated Subqueries
• Correlated Subquery Example
• Predicate Operators