Oracle Database: PL/SQL Fundamentals Ed 2 Training

Live Online & Classroom Enterprise Certification Training

The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is PL/SQL Fundamentals Ed 2 Certification Training about?

The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

Students will benefit from this course as it enables programmers with the skill of using this 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 are the objectives of PL/SQL Fundamentals Ed 2 Certification Training ?

Design PL/SQL anonymous block that execute efficiently
Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
Handle exceptions in the program units
Create and execute simple stored procedures and functions
Write PL/SQL code to interface with the database
Describe the features and syntax of PL/SQL

Who is PL/SQL Fundamentals Ed 2 Certification Training for?

Database Administrators
System Analysts
Forms Developer
Technical Consultant
Portal Developer
PL/SQL Developer

What are the prerequisites for PL/SQL Fundamentals Ed 2 Certification Training?

Suggested Prerequisite

Familiarity with data processing concepts and technique
Familiarity with programming languages

Required Prerequisite

Oracle Database 12c: Introduction for Experienced SQL Users

Available Training Modes

Live Online Training

16 Hours

Classroom Training

2 Days

Course Outline Expand All

Expand All

Introduction

Course Objectives, Course Agenda and Class Account Information

PL/SQL Development Environments

Appendices Used in this Course

The Human Resources (HR) Schema

Introduction to PL/SQL

Understanding PL/SQL Blocks

Generating output messages in PL/SQL

Understanding the benefits and structure of PL/SQL

Declaring PL/SQL Variables

Declaring and initializing variables

Identifying the benefits of using the %TYPE attribute

Using bind variables

Various data types

Identifying valid and invalid identifiers

Writing Anonymous PL/SQL blocks

Operators in PL/SQL

Referencing an Identifier Value in a Nested Block

Using Nested Blocks as Statements

Using Sequences in PL/SQL Expressions

Using SQL Functions in PL/SQL

Data Type Conversion

Qualifying an Identifier with a Label

Lexical Units in a PL/SQL Block

Using SQL Statements within a PL/SQL Block

Using SQL Statements in PL/SQL

Manipulating Data on the Server Using PL/SQL

Using SQL Cursor Attributes to Obtain Feedback on DML

Saving and Discarding Transactions

Using Naming Conventions in DML Statements and data retrieval

Retrieving Data in PL/SQL with the SELECT statement

SQL Cursors

Writing Control Structures

Building Boolean Conditions with Logical Operators

Controlling PL/SQL Flow of Execution

Using Iterative Control with Loop Statements

Using IF and CASE Statements for conditional processing

Handling Nulls

Working with Composite Data Types

Using Associative arrays

Inserting and Updating PL/SQL Records

Composite Data Types of PL/SQL Records and Tables

Declaring and Using VArrays

Using PL/SQL Records

Using INDEX BY Tables

Using Explicit Cursors

Cursor FOR Loops Using Subqueries

Explicit Cursor Attributes

Using Explicit Cursors to Process Rows

Explicit Cursor Operations

Cursors and Records

Cursors

Controlling Explicit Cursors

%NOTFOUND and %ROWCOUNT Attributes

Handling Exceptions

Functions that Return Information on Exceptions

Trapping User-Defined Exceptions

Predefined Exceptions

Usage of PRAGMA keyword

Trapping Predefined and Non-predefined Oracle Server Errors

Handling Exceptions with PL/SQL

Concept of Exception

Propagating Exceptions

Creating Stored Procedures and Functions

Creating a Simple Procedure with an IN Parameter

Understanding the Header Area of a Stored Procedure and Function

Executing a Procedure and a Function

Overview of Stored Procedures and Functions

CREATE OR REPLACE PROCEDURE | FUNCTION

Creating Simple Procedures and Functions

Differentiating between anonymous blocks and subprograms

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

PL/SQL Fundamentals Ed 2 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree