Course not currently available

Oracle 11g - Programming with PL / SQL I - Workshops Training Course

Nobleprog Limited

Course

In Coventry ()

£ 4,150 VAT inc.

The best Oracle courses

See all

See all

Description

  • Type

    Course

For who
Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate
Purpose of training
The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.
The content of the training
Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
Create scripts and stored program units that operate on data
Notes
The workshops are based on the software version 11g XE

About this course

Basic skills in any programming language, object-oriented structural or
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database Management
  • Database
  • SQL
  • PL/SQL
  • Database training
  • Construction
  • Logic
  • Writing
  • Programming
  • Construction Training

Course programme

Introduction to PL / SQL
  • Runtime Environment
  • Construction and types of PL / SQL blocks
  • Declaring and using variables
  • Control statements, decisions, loops
SQL statements in PL / SQL
  • DML commands
  • DDL and dynamic SQL
  • TCL commands and transactional
  • SELECT
Procedures and Functions
  • Create and delete
  • Parameterization
  • Passing parameters by value and reference, nocopy
Handling errors and exceptions Create and use cursors
  • Records
  • static cursors
  • Parameterizing cursors
  • Cursor FOR UPDATE
Associative arrays Packages
  • The structure of the package: the specification and body
  • Section Initialization and global variables, memory management, an instance of the package
  • Encapsulation, overloading programs, pre-declaration procedures
Triggers
  • DML triggers
  • The triggers Drives (INSTEAD OF)
  • The triggers system
  • New features in Oracle 11g triggers
Examples of application packages built
  • Writing to a file through UTL_FILE
  • Sending e-mails
Management code and compiler
  • Encryption code (dynamic obfuscation, wrap)
  • conditional Compilation
  • The relationships between objects
  • Warnings

Additional information

28 hours (usually 4 days including breaks)

See related categories

Oracle 11g - Programming with PL / SQL I - Workshops Training Course

£ 4,150 VAT inc.

The best Oracle courses

See all

See all