Database Management System Overview

• What is a Database?
• Types of DBMSs

Introduction to Entity Relationship Modeling

• What is a Data Model?
• Why Use an Entity Relationship Model?

Fundamentals of Relational Database Management Systems

• What is an RDBMS?
• Physical Data Storage
• Relationships between Tables
• Domains - Data Integrity

SQL Basics and SQL*Plus

• Understanding the Difference Between SQL, SQL*Plus and PL/SQL
• Invoking and Leaving SQL*Plus
• Entering and Executing Commands
• The SELECT Command & Mandatory Clauses

Using SQL Developer

• Understanding SQL Developer Environment and Commands

The WHERE and ORDER BY Clause

• WHERE and ORDER BY Clauses
• Using the Data Dictionary

Single Row Functions

• Functions, Date and Numeric Format Models/Data Conversion
• Control Statements

Joining Data from Multiple Tables in Queries

• The JOIN Condition / The Cartesian Product
• Outer JOINs
• ANSI99 Joins

Group Functions and the GROUP BY Clause

• Group Functions
• Distinct Operator in Group Functions

Using Subqueries and CASE Clauses

• Single-Row, Multi-Row, Multi-Column Subqueries
• Subqueries ? SELECT, FROM, WHERE, HAVING, ORDER BY, Correlated Subqueries
• CASE expressions

Analytic Functions (Optional)

• Single Row and Aggregating Analytic Functions

SQL*Plus Reporting

• SQL*Plus Report Writing Commands
• COLUMN Command / Titles, System Variables
• Master-Detail Report with TITLE and COLUMN Commands
• Control Breaks, Computing Aggregate Amounts

Data Manipulation Language (DML) Commands

• INSERT, UPDATE, DELETE, MERGE Command
• Use of Subqueries
• Transaction Control / Read Consistency / Locking

Getting Data In And Out Of Oracle

• SQL*Loader Basics
• Importing Into Excel
• Direct Database Queries Using ODBC