PL/SQL Training

PL/SQL Course:

After completing this course, you should be able to do the following: • Describe the purpose of PL/SQL • Describe the use of PL/SQL for the developer as well as the DBA • Explain the benefits of PL/SQL • Create, execute, and maintain procedures, functions, packages, and database triggers • Manage PL/SQL subprograms and triggers • Describe Oracle supplied packages

Industry Level Projects

PL/SQL Course Curriculum

PL/SQL Environment
Benefits of Subprograms
PL/SQL Block Structure
Types of Variables
Variable Initialization
Scalar Data Types
The %TYPE Attribute
Composite Data Types
Referencing Non-PL/SQL Variables
PL/SQL Block
Commenting Code
Data Type Conversion
Identifier Scope
SQL Statements in PL/SQL
Retrieving Data in PL/SQL
Inserting Data
Deleting Data
Naming Conventions
SQL Cursor Attributes
IF Statements
Compound IF Statements
Handling Nulls
Boolean Conditions
Basic Loops
FOR Loops
Composite Data Types
The %ROWTYPE Attribute
INDEX BY Table of Records
Explicit Cursor Functions
Declaring the Cursor
Fetching Data from the Cursor
Explicit Cursor Attributes
Cursor FOR Loops
Handling Exceptions with PL/SQL
Trapping Exceptions
Predefined Exceptions
Nonpredefined Error
Trapping User-Defined Exceptions
PL/SQL Program Constructs
Block Structure for Anonymous PL/SQL Blocks
PL/SQL Subprograms
Developing Subprograms
What Is a Procedure?
Developing Procedures
Overview of Stored Functions
Creating a Stored Function
Advantages of User-Defined Functions in SQL Expressions
Restrictions on Calling from SQL
Comparing Procedures and Functions
Overview & Components of Packages
Developing a Package
Creating the Package Body
Declaring a Bodiless Package
Guidelines for Developing Packages
Types of Triggers
Database Trigger
DML Trigger Components
Creating DML Statement Triggers>
Using Conditional Predicates
Trigger Execution Model and Constraint Checking

Frequently Asked Questions

This "PL/SQL" course is an instructor-led training (ILT). The trainer travels to your office location and delivers the training within your office premises. If you need training space for the training we can provide a fully-equipped lab with all the required facilities. The online instructor-led training is also available if required. Online training is live and the instructor's screen will be visible and voice will be audible. Participants screen will also be visible and participants can ask queries during the live session.

Participants will be provided "PL/SQL"-specific study material. Participants will have lifetime access to all the code and resources needed for this "PL/SQL". Our public GitHub repository and the study material will also be shared with the participants.

All the courses from zekeLabs are hands-on courses. The code/document used in the class will be provided to the participants. Cloud-lab and Virtual Machines are provided to every participant during the "PL/SQL" training.

The "PL/SQL" training varies several factors. Including the prior knowledge of the team on the subject, the objective of the team learning from the program, customization in the course is needed among others. Contact us to know more about "PL/SQL" course duration.

The "PL/SQL" training is organised at the client's premises. We have delivered and continue to deliver "PL/SQL" training in India, USA, Singapore, Hong Kong, and Indonesia. We also have state-of-art training facilities based on client requirement.

Our Subject matter experts (SMEs) have more than ten years of industry experience. This ensures that the learning program is a 360-degree holistic knowledge and learning experience. The course program has been designed in close collaboration with the experts working in esteemed organizations such as Google, Microsoft, Amazon, and similar others.

Yes, absolutely. For every training, we conduct a technical call with our Subject Matter Expert (SME) and the technical lead of the team that undergoes training. The course is tailored based on the current expertise of the participants, objectives of the team undergoing the training program and short term and long term objectives of the organisation.

Drop a mail to us at [email protected] or call us at +91 8041690175 and we will get back to you at the earliest for your queries on "PL/SQL" course.

Recommended Courses

Amazon Redshift
  More Info  
Spark using Scala
  More Info  
Apache Spark Debugging & Performance Tuning
  More Info