1.1.    Course Objectives
1.2.    Course Agenda
1.3.    Describe the Human Resources (HR) Schema
1.4.    PL/SQL development environments available in this course
1.5.    Introduction to SQL Developer

2.1.    Overview of PL/SQL
2.2.    Identify the benefits of PL/SQL Subprograms
2.3.    Overview of the types of PL/SQL blocks
2.4.    Create a Simple Anonymous Block
2.5.    How to generate output from a PL/SQL Block?

3.1.    List the different Types of Identifiers in a PL/SQL subprogram
3.2.    Usage of the Declarative Section to Define Identifiers
3.3.    Use variables to store data
3.4.    Identify Scalar Data Types
3.5.    The %TYPE Attribute
3.6.    What are Bind Variables?
3.7.    Sequences in PL/SQL Expressions

4.1.    Describe Basic PL/SQL Block Syntax Guidelines
4.2.    Learn to Comment the Code
4.3.    Deployment of SQL Functions in PL/SQL
4.4.    How to convert Data Types?
4.5.    Describe Nested Blocks
4.6.    Identify the Operators in PL/SQL

5.1.    Invoke SELECT Statements in PL/SQL
5.2.    Retrieve Data in PL/SQL
5.3.    SQL Cursor concept
5.4.    Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
5.5.    Data Manipulation in the Server using PL/SQL
5.6.    Understand the SQL Cursor concept
5.7.    Use SQL Cursor Attributes to Obtain Feedback on DML
5.8.    Save and Discard Transactions

6.1.    Conditional processing using IF Statements
6.2.    Conditional processing using CASE Statements
6.3.    Describe simple Loop Statement
6.4.    Describe While Loop Statement
6.5.    Describe For Loop Statement
6.6.    Use the Continue Statement

7.1.    Use PL/SQL Records
7.2.    The %ROWTYPE Attribute
7.3.    Insert and Update with PL/SQL Records
7.4.    INDEX BY Tables
7.5.    Examine INDEX BY Table Methods
7.6.    Use INDEX BY Table of Records

8.1.    What are Explicit Cursors?
8.2.    Declare the Cursor
8.3.    Open the Cursor
8.4.    Fetch data from the Cursor
8.5.    Close the Cursor
8.6.    Cursor FOR loop
8.7.    The %NOTFOUND and %ROWCOUNT Attributes
8.8.    Describe the FOR UPDATE Clause and WHERE CURRENT Clause

9.1.    Understand Exceptions
9.2.    Handle Exceptions with PL/SQL
9.3.    Trap Predefined Oracle Server Errors
9.4.    Trap Non-Predefined Oracle Server Errors
9.5.    Trap User-Defined Exceptions
9.6.    Propagate Exceptions
9.7.    RAISE_APPLICATION_ERROR Procedure

10.1.    Create a Modularized and Layered Subprogram Design
10.2.    Modularize Development With PL/SQL Blocks
10.3.    Understand the PL/SQL Execution Environment
10.4.    List the benefits of using PL/SQL Subprograms
10.5.    List the differences between Anonymous Blocks and Subprograms
10.6.    Create, Call, and Remove Stored Procedures
10.7.    Implement Procedures Parameters and Parameters Modes
10.8.    View Procedure Information

11.1.    Create, Call, and Remove a Stored Function
11.2.    Identify the advantages of using Stored Functions
11.3.    Identify the steps to create a stored function
11.4.    Invoke User-Defined Functions in SQL Statements
11.5.    Restrictions when calling Functions
11.6.    Control side effects when calling Functions
11.7.    View Functions Information
11.8.    How to debug Functions and Procedures?

12.1.    Listing the advantages of Packages
12.2.    Describe Packages
12.3.    What are the components of a Package?
12.4.    Develop a Package
12.5.    How to enable visibility of a Package’s Components?
12.6.    Create the Package Specification and Body
12.7.    Invoke the Package Constructs
12.8.    View the PL/SQL Source Code using the Data Dictionary

13.1.    Overloading Subprograms in PL/SQL
13.2.    Use the STANDARD Package
13.3.    Use Forward Declarations to solve Illegal Procedure Reference
13.4.    Implement Package Functions in SQL and Restrictions
13.5.    Persistent State of Packages
13.6.    Persistent State of a Package Cursor
13.7.    Control side effects of PL/SQL Subprograms
13.8.    Invoke PL/SQL Tables of Records in Packages

14.1.    Describe Triggers
14.2.    Identify the Trigger Event Types and Body
14.3.    Business Application Scenarios for Implementing Triggers
14.4.    Create DML Triggers using the CREATE TRIGGER Statement and SQL Developer
14.5.    Identify the Trigger Event Types, Body, and Firing (Timing)
14.6.    Differences between Statement Level Triggers and Row Level Triggers
14.7.    Create Instead of and Disabled Triggers
14.8.    How to Manage, Test and Remove Triggers?

15.1.    Overview of Schema Object Dependencies
15.2.    Query Direct Object Dependencies using the USER_DEPENDENCIES View
15.3.    Query an Object’s Status
15.4.    Invalidation of Dependent Objects
15.5.    Display the Direct and Indirect Dependencies
15.6.    Understand Remote Dependencies
15.7.    Recompile a PL/SQL Program Unit

Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.

The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.

The trainer is a certified consultant and has significant amount of experience in working with the technology.

Yes, we accept payments in two installments.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.