Oracle Database 11g - PL/SQL Fundamentals

Skills covered:
Displaying courses for Great Britain [Change]

Overview

Provides an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming.

Audience

Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:Application designers and developersDatabase administratorsBusiness users and non-technical senior end users

Syllabus

Volume 1

  • Choosing a SQL & PL/SQL Interface
  • Language Features
  • Declare Clause
  • Begin Clause
  • Exception Clause
  • Explicit Cursors
  • Advanced Programming: Declared Subprograms

Volume 2

  • Introducing Database Program Units
  • Creating Stored Procedures & Functions
  • Maintaining Stored Procedures & Functions
  • Creating and Maintaining Packages
  • Advanced Cursor Techniques
  • Using System-Supplied Packages
  • Relating Database Triggers
  • Maintaining Database Triggers
  • Implementing System Even Triggers

Training provider

Teaching mode: Classroom - Instructor Led
Duration: 2 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Database
Great Britain
This skill has an average salary of
£43,135
and is mentioned in
4.85%
of job ads in this area.
SQL
Great Britain
This skill has an average salary of
£50,346
and is mentioned in
2.11%
of job ads in this area.
PL/SQL
Great Britain
This skill has an average salary of
£0
and is mentioned in
0.00%
of job ads in this area.