Training

Oracle Database 12c R2: Develop PL SQL Program Units.

About This Course

Course Code
OC12CDSQLP

Course Type
Performance

Vendor
Oracle

Duration
3 Days

RRP
£1,615.00

Course Overview
Download

Special Notices

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.

Overview

Official Oracle Curriculum

This Oracle Database: Develop PL/SQL Program Units course is designed for developers with basic PL/SQL and SQL language skills. You will learn to develop, execute and manage PL/SQL stored program units, which include: procedures, functions, packages and database triggers.

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.

Learn Dynamic SQL, Design Considerations and More:

This course will also teach you how to use Dynamic SQL through instruction, as well as hands-on exercises. Expert Oracle instructors will also help you understand design considerations when coding using PL/SQL.

Using Oracle SQL Developer:

In addition, you'll use Oracle SQL Developer as the main environment tool to develop these program units. SQL*Plus is introduced as optional tools. Demonstrations and hands-on practice reinforce the fundamental concepts you've learned throughout the course.

Objectives

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

Course Outline

Introduction

Creating Stored Procedures

Creating Functions and Debugging Subprograms

Creating Packages

Working With Packages

Using Oracle-Supplied Packages in Application Development

Using Dynamic SQL

Design Considerations for PL/SQL Code

Creating Triggers

Creating Compound, DDL, and Event Database Triggers

Using PL/SQL compiler

Managing Dependencies

Prerequisites

Required:

Required knowledge:

Recommended:

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.

About This Course

Course Code
OC12CDSQLP

Course Type
Performance

Vendor
Oracle

Duration
3 Days

RRP
£1,615.00

Course Overview
Download