Oracle 11g PL/SQL Training

Introduction

This course is for developers who will be designing or building applications using the Oracle server. It is relevant for developers who are using the Oracle Developer toolset, and for those using alternative front-end products accessing the Oracle database. The course covers basic PL/SQL syntax and the use of server level procedures, functions and triggers.

Prerequisites

A knowledge of SQL is required.

Duration

3 days

Agenda

  • PL/SQL Overview
  • The Oracle Development Environment
  • Basic PL/SQL Syntax
  • SQL Statements in PL/SQL
  • Procedural Statements - Assignment and Conditional Processing
  • Procedural Statements - LOOPS
  • Exceptions
  • Nested Blocks and Cursors
  • Tables, Arrays and Records
  • Architecture Overview
  • Procedures / Functions
  • Execution and Error Handling
  • Security and Dependency
  • Packages
  • Supplied Packages
  • Triggers
  • Large Objects

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