Call us Today ! 9590800200 | training@gitsacademy.com
learn-apply-succeed

Introduction

The Oracle PL SQL Corporate Training course will introduces Participants to the PL SQL programming language. In the training class, participants learn to create PL SQL blocks of application code.

Students will benefit from Oracle PL SQL course as it enables programmers with the skill of using PL SQL programming language. In the class students will learn to create anonymous PL SQL blocks, to create procedures, functions and triggers. Students will learn to use explicit cursors in their program blocks. Demonstrations and hands-on practice reinforce the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

What The Participants will learn in this training

  • Learn how to design PL SQL anonymous block that execute effectively.
  • How to use PL SQL programming designs and conditionally manage code flow (loops, control structures, and explicit cursors).
  • How to handle exceptions in the program units.
  • Learn to create and execute simple stored procedures and functions.
  • Learn to write PL SQL code to interface between the database
  • Understand to describe the main features and syntax of PL SQL

Why to choose Gits Academy for Oracle PL/SQL Corporate Training?

Gits Academy conveyed a huge number of corporate trainings and we are considered as one of the best corporate training partner for Oracle PL/SQL training. Gits Academy Faculty is best in preparing the training needs relating to Oracle PL/SQL training. We have a pool of trainers who are very much experienced, confirmed, qualified for delivering training and are found to be the best in the business. Gits Academy delivers trainings on Oracle PL/SQL over the globe. Our trainers have extensive experience in end-to-end Oracle PL/SQL.

Who should attend this course?

Employees who are working as Technical Consultant, Portal Developer, PL/SQL Developer, Database Administrators, System Analysts, Forms Developer.

Oracle PL/SQL Course Content: Oracle database 12C (12.2.0.1)

  • Course Objectives, Course Agenda and Class Account Information
  • The Human Resources (HR) Schema
  • Appendices Used in this Course
  • PL/SQL Development Environments
  • Understanding the benefits and structure of PL/SQL
  • Understanding PL/SQL Blocks
  • Generating output messages in PL/SQL
  • Identifying valid and invalid identifiers
  • Declaring and initializing variables
  • Various data types
  • Identifying the benefits of using the %TYPE attribute
  • Using bind variables
  • Lexical Units in a PL/SQL Block
  • Using SQL Functions in PL/SQL
  • Data Type Conversion
  • Using Nested Blocks as Statements
  • Referencing an Identifier Value in a Nested Block
  • Qualifying an Identifier with a Label
  • Operators in PL/SQL
  • Using Sequences in PL/SQL Expressions
  • Using SQL Statements in PL/SQL
  • Retrieving Data in PL/SQL with the SELECT statement
  • Using Naming Conventions in DML Statements and data retrieval
  • Manipulating Data on the Server Using PL/SQL
  • SQL Cursors
  • Using SQL Cursor Attributes to Obtain Feedback on DML
  • Saving and Discarding Transactions
  • Controlling PL/SQL Flow of Execution
  • Using IF and CASE Statements for conditional processing
  • Handling Nulls
  • Building Boolean Conditions with Logical Operators
  • Using Iterative Control with Loop Statements
  • Composite Data Types of PL/SQL Records and Tables
  • Using PL/SQL Records
  • Inserting and Updating PL/SQL Records
  • Using INDEX BY Tables
  • Using Associative arrays
  • Declaring and Using VArrays
  • Cursors
  • Explicit Cursor Operations
  • Controlling Explicit Cursors
  • Using Explicit Cursors to Process Rows
  • Cursors and Records
  • Cursor FOR Loops Using Subqueries
  • Explicit Cursor Attributes
  • %NOTFOUND and %ROWCOUNT Attributes
  • Concept of Exception
  • Handling Exceptions with PL/SQL
  • Predefined Exceptions
  • Trapping Predefined and Non-predefined Oracle Server Errors
  • Functions that Return Information on Exceptions
  • Usage of PRAGMA keyword
  • Trapping User-Defined Exceptions
  • Propagating Exceptions
  • Overview of Stored Procedures and Functions
  • Differentiating between anonymous blocks and subprograms
  • CREATE OR REPLACE PROCEDURE | FUNCTION
  • Understanding the Header Area of a Stored Procedure and Function
  • Creating Simple Procedures and Functions
  • Creating a Simple Procedure with an IN Parameter
  • Executing a Procedure and a Function
GITS Academy. All rights reserved.