Oracle 12c SQL and SQL*Plus Training

Introduction

The course is designed to provide the student with a basis for developing systems using the Oracle database. The SQL language is covered from simple to complex constructs. Guidelines are provided on writing SQL for optimum performance and ease of maintenance.

Prerequisites

No previous experience is required.

Duration

4 days

Agenda

  • The Relational Model
  • The Oracle Development Environment
  • The SQL Language
  • More about SELECT
  • More About the Oracle Development Environment
  • Functions
  • Joins
  • Group and Analytical Functions
  • Set Operators
  • Subqueries
  • Data Manipulation Language
  • Database Objects
  • Constraints
  • Views and Sequences
  • Indexes
  • Security
  • Locking and Read Consistency
  • More Advanced 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