Introduction 1: Note on the important definitions to remember

Oracle Server

Oracle Database

Physical Database Structure

Logical Database Structure

Instance

System Global Area

Background Processes Server

Oracle Users

Listener

Server Processes

TNSNAMES.ORA 

SQLNET.ORA  

Introduction 1: Basic Introduction (Sample)

Elements/Fields/Items

Columns

Records/Rows

Tables

Datatypes

Primary Key

Foreign Key

Logical Data Model

Oracle Tools

DBA vs. Developer  

Introduction 2: SQL Introduction) (Sample)

Note on the important definitions to remember  

Hands-On 01: Selecting Data (Sample)

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  

Installation: Developer and Personal Edition on the same machine (Standalone)

Install Oracle

Install Developer

Create a Net8 service name

Copy TNSNAMES.ORA file

Rename SQLNET.ORA

Start Listener

Start Database 

Installation: Connectivity

Start Listener

Create a Service Name

Test a Service Name

Copy SQLNET.ORA

Copy TNSNAMES.ORA

Add the LOCAL string to the registry

Login to the "SQLPLUS" tool 

Installation: Remove Oracle From your machine

Shutdown the database

Un-install all the Oracle products

Delete all the Oracle entries in the registry

Edit AUTOEXEC.BAT

Delete the Oracle Directory

Delete other system directories

Reboot your computer

iSelfSchooling: Build your schema to work on your Hands-On

In order to follow and practice examples of this tutorial, you need to create a user named iself with all its necessary tables.

There is a script named "create_tables.sql" at your CD located in the "iscdxx\iss" sub-directory.

This Hands-On shows you how you can run the script to create a user named "iself" with password "schooling" and all its tables.