Oracle End User Training

Introduction

This course is designed for End Users who require a knowledge of SQL to query the Oracle database. It commences with a description of relational concepts and continues with coverage of the SQL statements required to access information from one or more Oracle Tables. Some basic formatting is also covered.

Prerequisites

The course requires no prior knowledge of Oracle.

Duration

2 days

Agenda

  • The Relational Model
  • Structured Query Language
  • SQL*Plus
  • Oracle SQL Developer
  • More About SELECT
  • Substitution Variables
  • Using SQL*Plus for Formatting Output
  • Functions
  • Joins
  • Subqueries
  • Group Functions
  • Analytical Functions
  • Exploring further SQL

Who are our trainers?

Oracle ACE's Penny Cookson & Scott Wesley head our team of experienced consultants and trainers.

Penny was recognised as Oracle Educator of the Year in 2004

Complete Agenda

Download the complete Course Catalog (450kb)

Interested in booking training?

to enquire about our courses


Back to Training