Oracle SQL Course Outline

Introduction to Oracle Database

Retrieve Data using the SQL SELECT Statement

Learn to Restrict and Sort Data

Usage of Single-Row Functions to Customize Output

Invoke Conversion Functions and Conditional Expressions

Aggregate Data Using the Group Functions

Display Data from Multiple Tables Using Joins

Use Sub-queries to Solve Queries

The SET Operators

Data Manipulation Statements

Use of DDL Statements to Create and Manage Tables

Other Schema Objects

Control User Access

Management of Schema Object


Manage Objects with Data Dictionary

Manipulate Large Data Sets

Data Management in Different Time Zones

Retrieve Data Using Sub-queries

Regular Expression Support