1. In the Beginning.Database Management System Overview
What is a Database?
Types of DBMSs
2. Introduction to Entity Relationship Modeling
What is a Data Model?
Why Use an Entity Relationship Model?
Input and Components of an Entity Relationship Model
Reading the Entity Relationship Model
Guidelines for a Model Review
3. Fundamentals of Relational Database Management Systems
What is an RDBMS?
History of SQL
Physical Data Storage
Relationships between Tables
Domains - Data Integrity Constraint
4. SQL Basics and SQL*Plus
Difference Between SQL, SQL*Plus, and PL/SQL
Invoking and Leaving SQL*Plus
Entering and Executing Commands
The SQL Buffer, SQL*Plus Default Output
LOGIN.SQL
The SELECT Command and Mandatory Clauses
5. Using SQL Developer
SQL Developer Environment and Commands
6. The WHERE and ORDER BY Clause
WHERE, ORDER BY Clause
Using the Data Dictionary
Hierarchical Queries
7. Single Row Functions
Single Row vs. Group Functions
Date and Numeric Format Models
Data Conversion
Control Statements
Regular Expressions
8. Joining Data from Multiple Tables