fbpx

Course

Oracle Database 12c R2: Program with PL/SQL Ed 2

Free
Oracle Database 12c R2 Program with PL SQL Ed 2
Overview
Topics
Prerequisites
Objectives
Certification
Overview

This training will show you how to develop stored procedures, functions, packages and database triggers. You'll learn to manage PL/SQL program units and dependencies, while using of some of the Oracle-supplied packages.

 

This Database Program with PL/SQL training ensures 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.

Topics
  • Introduction
  • Working with Oracle Cloud Exadata Express Cloud Service
  • Introduction to PL/SQL
  • Declare PL/SQL Variables
  • Write Anonymous PL/SQL Blocks
  • SQL Statements in a PL/SQL block
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures
  • Stored Functions
  • 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
  • Oracle Database: Introduction to SQL
  • Previous programming experience
Objectives

What you will learn:

  • Manage dependencies between PL/SQL subprograms
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Create stored procedures and functions
  • Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
  • Write dynamic SQL for more coding flexibility
  • Create overloaded package subprograms for more flexibility
  • Create triggers to solve business challenges
  • Create and debug stored procedures and functions
  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently
  • Design PL/SQL packages to group related constructs
  • Handle runtime errors
Certification

Programme

At Institute of Software Technologies, we have flexible training schedule that suit your availability.

You can choose from the following available options:

FLY me a trainer

We have conducted onsite trainings for corporate clients all over the world including in over 100 companies in Kenya, Uganda, Tanzania, Rwanda, Zambia, Somalia, Ethiopia, South Sudan, Zanzibar, Malawi, Mozambique, Ghana, Nigeria, Sierra Leone, just to mention a few. References can be provided on request.

Fly me a Trainer is no different from classroom training, since it consists of the same setup. The only difference is that the trainer travels instead of the participants.

Apply Now For Our Next Intake

Website Enquiry
Curriculum is empty

Relative Courses

Programing

SQL Fundamentals

SUSE Linux

Server Administration

VMware Courses

VMware – Foundation Course

Security Courses

Certified Chief Information Security Officer (CCISO)

Security Courses

EC-council Certified Security Analyst (ECSA)

VMware Courses

VMware Data Center Virtualization Course

Programing

PL/SQL

Adobe Certification

Dreamweaver

Adobe Certification

Flash Professional

Adobe Certification

Adobe Photoshop

Programing

ZEND PHP

Oracle Database 12c: Backup & Recovery Workshop

0 student
Programing

PHP

Security Courses

Computer Hacking Forensic Investigator Certification

Oracle Courses

Oracle Database 11g: Administration Workshop I

UNIX and Linux Essentials

0 student

E-Business Suite Financial Management Training and Certification

0 student

Oracle Cash Management Fundamentals

0 student

Oracle E-Business Tax Fundamentals

0 student
Security Courses

Licensed Penetration Tester (LPT)

Oracle General Ledger Management Fundamentals

0 student

Oracle Inventory Management Fundamentals

0 student
Adobe Certification

Adobe Illustrator

Oracle iProcurement Fundamentals

0 student
Oracle Courses

Oracle Database 11g: Administration Workshop II

Oracle Order Management Fundamentals

0 student
Adobe Certification

Adobe InDesign

Short Courses

Corel Draw

Oracle Courses

Oracle Database 11g: Performance Tuning

Security Courses

Certified Network Defender Certification (CND)

Short Courses

ICDL Certification

Management

ITIL 2011 Foundation

Programing

Core Java

Oracle Courses

Introduction to SQL

J2EE Architecture & JSP

Oracle Courses

Oracle Database 12c: Managing Multitenant Architecture

Programing

SQL / EJB&RM

Oracle Courses

Oracle Database 12c: Install and Upgrade Workshop

Oracle Courses

Data Modeling & Relational Database Design

Oracle Courses

Oracle 10g Forms Developer: Build Internet Apps

Oracle Courses

Oracle Reports Developer 10g: Build Reports

Microsoft

Administering Windows Server 2012

Android Application Development

Diploma Courses

Diploma in Database Administration & Application Development

Microsoft

Installing and Configuring Server

Diploma Courses

Diploma in Information Security & Ethical Hacking

Microsoft

Configuring Advanced Windows Server

Programing

Python

Management

PRINCE2

Oracle Courses

Oracle Solaris 10 OS Part 1

Microsoft

Designing and Implementing a Server Infrastructure

Red Hat

System Administration III With RHCSA & RHCE

Red Hat

System Administration II With RHCSA

Red Hat

RHCSA Rapid Track

Red Hat

System Administration I

Oracle Courses

Oracle Solaris 10 OS Part 1

Oracle Courses

Oracle Solaris 10 OS Part 2

Microsoft

Implementing an Advanced Server Infrastructure

Oracle Courses

Oracle Solaris 10 OS Essentials

SUSE Linux

Linux Enterprise

Short Courses

Appin Front Runner

Security Courses

Certified Ethical Hacker Certification (CEH)

SUSE Linux

SUSE Linux Enterprise 11 Administration