You will receive from us:

Text describing the steps of installation and browsing the Oracle database
Access to a tutorial video
Access to forum to ask any question
One-on-one with a DBA, if needed to make your installation successful

You will learn:

Lesson 1: Welcome

Getting Started
What is a Relational Database?
Parts of ORACLE: Table, Column, View, Index, Key, Tablespace, Schema
Table and Referential Integrity

Lesson 2: Designing a Database

Database Design
Identify the Business Information Needs
Define Database Requirements
Reduce Duplication Through Normalization
Establish Referential Integrity Rules
Physical Design

Lesson 3: Elements of SQL

DML, DDL, DCL
Creating a Database
Creating a user or schema
Connecting to the Database
CONNECT TO ONEWORLD
Using Environment Variable
Creating Tables 24
Creating Views 29
Creating Indexes 31
Primary and Foreign Keys 32
Changing the Database Design 33
Adding Primary and Foreign Keys 35
Dropping Primary and Foreign Keys 35
Dropping a Non-key Column 36
Dropping a Table 36
Changing an Index 37
Changing a View 37
Dropping a Database 38

Lesson 4: Maintaining a Database

Adding Data to a Table 39
Changing Data 44
Deleting Data 47

Lesson 5: Retrieving Data

The SELECT clause 53
The WHERE clause 56
Comparison operators 56
AND and OR operators 58
BETWEEN operator 60
IN operator 61
Ordering the data 63
GROUP BY clause 68
HAVING clause 70
Arithmetic 71

>> Click here to register <<