This Oracle Database: Program with PL/SQL training program starts with an introduction to PL/SQL and proceeds to list the advantages of this powerful programming language. Through hands-on instruction from expert instructors, professionals’ll develop stored procedures, functions, packages and more.

Radiant Teachlearning offers the Oracle Database: Program with PL/SQL Training Program in Classroom and Virtual instructor Led/Online mode.


Duration: 5 days


Learning Objectives

Debug  as well as create stored functions and procedures, Use conditional compilation to customize the functionality in PL/SQL app without removing any source code, Create overloaded package subprograms for more flexibility, Design PL/SQL packages to group related constructs , Design PL/SQL anonymous blocks that execute efficiently, Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output, Write dynamic SQL for more coding flexibility, Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors), Describe the features and syntax of PL/SQL, Manage and maintain dependencies between Handle runtime errors, PL/SQL subprograms, Create triggers to solve business challenges, Design PL/SQL code for predefined data types, local subprograms, additional pragmas, standardized constants and exceptions

  • Conditionally control code flow (loops, control structures).
  • Utilize PL/SQL packages to contain as well as group related constructs.
  • Generate triggers to solve business challenges.
  • Create anonymous PL/SQL blocks, and stored functions as well as procedures.
  • Generate screen output and file output using some of Oracle supplied PL/SQL packages.
  • Create anonymous PL/SQL functions, procedures and blocks.
  • Declare PL/SQL variables.
  • Create PL/SQL blocks of app code that can be shared by multiple forms, reports and data management apps.
  • Debug functions and procedures using the SQL Developer Debugger.
  • Use Dynamic SQL & acknowledge design considerations when coding using PL/SQL.
  • Acknowledge and influence the PL/SQL compiler and manage dependencies.
  • Manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.


Benefits to Professionals

Expand the functionality of the SQL language with PL/SQL language to write app code so that your organization can realize the full advantages of utilizing Oracle best practices.


Course Bundle

This course is the bundle of the Oracle Database: PL/SQL basics and Oracle Database: Develop PL/SQL Program Units training program.

Professionals use Oracle SQL Developer to develop these program units. JDeveloper and SQL*Plus are introduced as optional tools. This is appropriate for 11g and 10g professionals. There are minor changes between the 11g and 10g features.

Course Content

  • 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 App Development, Dynamic SQL
  • Design Considerations for PL/SQL Code
  • Triggers
  • Creating Compound, DDL, and Event Database Triggers
  • PL/SQL Compiler
  • Manage PL/SQL Code
  • Manage Dependencies


Q: What audience is expected for this training?


A: This training is beneficial for the following professionals: –

  • Administrator
  • Developer
  • Implementer
  • System Administrator


Q: What is the role of SQL plus?


A: SQL*Plus is an Oracle-Oracle designed utility that lets the user to interactively enter, execute and manage SQL commands and PL/SQL architecture blocks.


Q: What is meant by role?


A: A role is created to simplify the procedure setup and maintenance of the security model. It is a titled group of all the relative privileges that could be grantable to the user.


Q: What language is used by SQL?


A: SQL uses language of Procedural Standard language aka SQL script.


Q: Is there any difference between Python and SQL?


A: As a utility, SQL is a bit difficult than Python.


Q: What are the advantages of SQL plus?


A: Some of the advantages are listed below: –

  • High speed
  • Well defined standards
  • Portability
  • Interactive language


Q: Why one should prefer Radiant Techlearning ?


A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.


Q: What if I/we have doubts after attending your training program?


A: Radiant team of experts would be available on the e-mail to answer your technical queries even after the training program.


Q: Does this training program include any project?


A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.


Q: If I face technical difficulty during the session then is there any remedy for that?


A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.


Q: What is schedule of training program?


A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch