Oracle SQL for End Users

Audience

The course has been designed for System Analysts, Managers and End Users.

Prerequisites

IT professionals who have some familiarity with the base operating system on which the database is mounted (e.g. Unix, Windows etc).

Duration

2 days. Hands on.

Course Objectives

On completion of the course delegates will be able to: Query and manipulate data. Use SQL*Plus to format query output.

Course Content

Explore Relational Principles and Oracle Concepts
Examine the basic SQL statement
Restrict and sort data
Discuss single row functions and the use of NUMBER and CHAR functions
Discuss single row DATE and CONVERSION functions
Display Data Using Multiple Tables
Aggregate data using group functions
Write subqueries
Examine SQL*Plus
Manipulate data