Training

Oracle Database 12c R2: Program with PL SQL.

About This Course

Course Code
OC12CPLSQL

Course Type
Performance

Vendor
Oracle

Duration
5 Days

RRP
£2,680.00

Course Overview
Download

Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

Please note: In order to provision you with your courseware and lab access for this course Nexus must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our Nexus Partner data sharing page. If you have any questions or concerns please contact your Nexus account manager.

Important Note: Your official Oracle digital course material now includes an additional 5 hours of content for you to consume after the course to help embed the learning. Your ELS will be accessible for 90 days from purchase.

Overview

Official Oracle Curriculum

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.

Learn To:

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
You'll use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced in this course as optional tools.

Target Audience:

Objectives

At the end of this course you will be able to:

Course Outline

Introduction

Introduction to PL/SQL

Declare PL/SQL Identifiers

Write Executable Statements

Interaction with the Oracle Server

Control Structures

Composite Data Types

Explicit Cursors

Exception Handling

Stored Procedures

Stored Functions and Debugging Subprograms

Packages

Deploying Packages

Implement Oracle-Supplied Packages in Application Development

Dynamic SQL

Design Considerations for PL/SQL Code

Triggers

Creating Compound, DDL, and Event Database Triggers

PL/SQL Compiler

Manage Dependencies

Prerequisites

Please note: In order to provision you with your courseware and lab access for this course Nexus must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our Nexus Partner data sharing page. If you have any questions or concerns please contact your Nexus account manager.

Dates & Prices

Monday 25th October 2021

£2,680.00

Monday 29th November 2021

£2,680.00