Introduction 1: Basic Introduction

Elements/Fields/Items

Columns

Records/Rows

Tables

Datatypes

Primary Key

Foreign Key

Logical Data Model

Oracle Tools

DBA vs. Developer  

Introduction 2: SQL Introduction

Note on the important definitions to remember  

Hands-On 01: Selecting Data

Writing SELECT statements

Performing Arithmetic Equations

Handling NULL Values

Changing Column Headings with Column Aliases

Putting Columns Together with Concatenation

The ORDER BY Clause

The WHERE Clause

The EXISTS Clause

The IN Clause

DECODE function  

Hands-On 02: Advanced Data Selection

Select Statements That Join Data from More than One Table

Creating Outer Joins

Joining a Table to Itself

Identifying Available Group Functions

Using Group Functions

Using the GROUP BY Clause

Excluding GROUP BY Data with HAVING

Nested Sub queries

Entering Variables at Run Time

Using Runtime Variables  

Hands-On 03: Creating the Database objects

Creating a Table with Integrity Constraints

Using Table Naming Conventions

Datatypes and Column Definitions

Indexes Created by Constraints

Creating One table with Data From Another

Available Dictionary Views

Querying the Data Dictionary

Inserting New Rows into a Table

Making Changes to Existing Row Data

Deleting Data from Oracle Database  

Hands-On 04: Creating more Database Objects

Adding and Modifying Columns,

Dropping Tables, Truncating Tables,

Renaming Objects, Viewing Dictionary.

Data Dictionary Views,

Creating Simple Views,

Dropping Views.

Manual and Automatic Indexes,

Uses for Indexes, Creating Indexes,

Removing Indexes.

creating user, Granting System Privileges,

Granting and Revoking Object Privileges,

Changing Passwords, Alter user, Using Synonyms  

Hands-On 05: PL/SQL Command line editing

"L" command - Lists SQL or PL/SQL from the SQL buffer

"I" command - Inserts SQL or PL/SQL lines

"Del" command - Deletes SQL or PL/SQL lines

"C" command - Changes SQL or PL/SQL lines

SAVE command

GET command  

Hands-On 06: PL/SQL Notepad editing

Open Notepad editor

Save the Oracle Buffer

Edit the file

Work with the file