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

We have options for classroom-based as well as instructor led live online training. The online training is live and the instructors screen will be visible and voice will be audible. Your screen will also be visible and you can ask queries during the live session.

The training on "PL/SQL" course is a hands-on training. All the code and exercises will be done in the live sessions. Our batch sizes are generally small so that personalized attention can be given to each and every learner.

We will provide course-specific study material as the course progresses. You will have lifetime access to all the code and basic settings needed for this "PL/SQL" through our GitHub account and the study material that we share with you. You can use that for quick reference

Feel free to drop a mail to us at [email protected] and we will get back to you at the earliest for your queries on "PL/SQL" course.

We have tie-ups with a number of hiring partners and and placement assistance companies to whom we connect our learners. Each "PL/SQL" course ends with career consulting and guidance on interview preparation.

Minimum 2-3 projects of industry standards on "PL/SQL" will be provided.

Yes, we provide course completion certificate to all students. Each "PL/SQL" training ends with training and project completion certificate.

You can pay by card (debit/credit), cash, cheque and net-banking. You can also pay in easy installments. You can reach out to us for more information.

We take pride in providing post-training career consulting for "PL/SQL".

Recommended Courses

Big Data Processing with PySpark
  More Info  
Amazon Redshift
  More Info  
Big Data Processing with PySpark
  More Info