Oracle SQL Basics 

Welcome and Introduction

Introduction to Table Design

Walkthrough: Creating A Simple Table

Walkthrough: Altering an existing Table Schema

Walkthrough: Modifying a Column and Execute DDL Script

Managing Tables

Oracle Instance

Tables and Table Clusters

Module 1 Quiz

The Anatomy of an SQL Statement

Insert Statement Example

Walkthrough Using An Insert Statement

Update Statement Example

Walkthrough Using An Update Statement

The Delete Statement

SQL Standards

Types Of SQL Statements

Syntax for Schema Objects and Parts in SQL Statements

Module 2 Quiz

Introduction To Indexes

Walkthrough: Creating Indexes

Types of Indexes

Walkthrough: Using Indexes

Walkthrough: Composite Indexes

Indexes and Index-Organized Tables

How the Database Maintains Indexes

Module 3 Quiz