GUIDE ME

Master fundamentals of PL/SQL. Enroll yourself today to learn from a PL/SQL specialist.

4.8 out of 5 based on 78954 votes
google4.2/5
Sulekha4.8/5
Urbonpro4.6/5
Just Dial4.3/5
Fb4.5/5

Course Duration

22 Hrs.

Live Project

2 Project

Certification Pass

Guaranteed

Training Format

Live Online /Self-Paced/Classroom

Watch Live Classes

Databases

Speciality

prof trained

300+

Professionals Trained
batch image

4+

Batches every month
country image

20+

Countries & Counting
corporate

100+

Corporate Served

CURRICULUM & PROJECTS

Oracle PL/SQL Training Program

    Croma Campus is a premier institute that assists you in comprehending and learning PL/SQL training courses that are relevant to today's corporate environment.

    • Introduction to PL/SQL
    • PL/SQL Programming Concepts Review
    • Designing PL/SQL Code
    • Using Collections
    • Manipulating Large Objects
    • Using Advanced Interface Methods
    • Performance and Tuning
    • Improving Performance with Caching
    • Analyzing PL/SQL Code
    • Profiling and Tracing PL/SQL Code
    • Implementing VPD with Fine-Grained Access Control
    • Safeguarding Your Code against SQL Injection Attacks
    • PL/SQL Identifiers
    • Write Executable Statements
    • Interaction with the Oracle Server
    • Control Structures
    • Usage of Composite Data Types
    • Explicit Cursors
    • Exception Handling
    • Stored Procedures and Functions
Get full course syllabus in your inbox

    Introduction to PL/SQL

    • PL/SQL Overview
    • List the benefits of PL/SQL Subprograms
    • Overview of the Types of PL/SQL blocks
    • Create a Simple Anonymous Block
    • Generate the Output from a PL/SQL Block
    • Overview of the development environments: SQL Developer, SQL Plus
Get full course syllabus in your inbox

    PL/SQL Programming Concepts Review

    • Identify PL/SQL block structure
    • Create procedures
    • Create functions
    • List restrictions and guidelines on calling functions from SQL expressions
    • Create packages
    • Review of implicit and explicit cursors
    • List exception syntax
    • Identify the Oracle supplied packages
Get full course syllabus in your inbox

    Designing PL/SQL Code

    • Describe the predefined data types
    • Create subtypes based on existing types for an application
    • List the different guidelines for cursor design
    • Cursor variables
Get full course syllabus in your inbox

    Using Collections

    • Overview of collections
    • Use Associative arrays
    • Use Nested tables
    • Use VARRAYs
    • Compare nested tables and VARRAYs
    • Write PL/SQL programs that use collections
    • Use Collections effectively
Get full course syllabus in your inbox

    Manipulating Large Objects

    • Describe a LOB object
    • Use BFILEs
    • Use DBMS_LOB.READ and DBMS_LOB.WRITE to manipulate LOBs
    • Create a temporary LOB programmatically with the DBMS_LOB package
    • Introduction to SecureFile LOBs
    • Use SecureFile LOBs to store documents
    • Convert BasicFile LOBs to SecureFile LOB format
    • Enable reduplication and compression
Get full course syllabus in your inbox

    Using Advanced Interface Methods

    • Calling External Procedures from PL/SQL
    • Benefits of External Procedures
    • C advanced interface methods
    • Java advanced interface methods
Get full course syllabus in your inbox

    Performance and Tuning

    • Understand and influence the compiler
    • Tune PL/SQL code
    • Enable intra unit inlining
    • Identify and tune memory issues
    • Recognize network issues
Get full course syllabus in your inbox

    Improving Performance with Caching

    • Describe result caching
    • Use SQL query result cache
    • PL/SQL function cache
    • Review PL/SQL function cache considerations
Get full course syllabus in your inbox

    Analyzing PL/SQL Code

    • Finding Coding Information
    • Using DBMS_DESCRIBE
    • Using ALL_ARGUMENTS
    • Using DBMS_UTILITY.FORMAT_CALL_STACK
    • Collecting PL/Scope Data
    • The USER/ALL/DBA_IDENTIFIERS Catalog View
    • DBMS_METADATA Package
Get full course syllabus in your inbox

    Profiling and Tracing PL/SQL Code

    • Tracing PL/SQL Execution
    • Tracing PL/SQL: Steps
Get full course syllabus in your inbox

    Implementing VPD with Fine-Grained Access Control

    • Understand how fine-grained access control works overall
    • Describe the features of fine-grained access control
    • Describe an application context
    • Create an application context
    • Set an application context
    • List the DBMS_RLS procedures
    • Implement a policy
    • Query the dictionary views holding information on fine-grained access
Get full course syllabus in your inbox

    Safeguarding Your Code against SQL Injection Attacks

    • SQL Injection Overview
    • Reducing the Attack Surface
    • Avoiding Dynamic SQL
    • Using Bind Arguments
    • Filtering Input with DBMS_ASSERT
    • Designing Code Immune to SQL Injections
    • Testing Code for SQL Injection Flaws
Get full course syllabus in your inbox

    PL/SQL Identifiers

    • List the different Types of Identifiers in a PL/SQL subprogram
    • Usage of the Declarative Section to Define Identifiers
    • Use of variables to store data
    • Scalar Data Types
    • %TYPE Attribute
    • Bind Variables
    • Sequences in PL/SQL Expressions
Get full course syllabus in your inbox

    Write Executable Statements

    • Basic PL/SQL Block Syntax Guidelines
    • How to comment code
    • SQL Functions in PL/SQL
    • Data Type Conversion
    • Nested Blocks
    • Operators in PL/SQL
Get full course syllabus in your inbox

    Interaction with the Oracle Server

    • SELECT Statements in PL/SQL to Retrieve data
    • Data Manipulation in the Server Using PL/SQL
    • The SQL Cursor concept
    • Learn to use SQL Cursor Attributes to Obtain Feedback on DML
    • How to save and discard transactions
Get full course syllabus in your inbox

    Control Structures

    • Conditional processing Using IF Statements
    • Conditional processing Using CASE Statements
    • Simple Loop Statement
    • While Loop Statement
    • For Loop Statement
    • The Continue Statement
Get full course syllabus in your inbox

    Usage of Composite Data Types

    • PL/SQL Records
    • The %ROWTYPE Attribute
    • Insert and Update with PL/SQL Records
    • Associative Arrays (INDEX BY Tables)
    • INDEX BY Table Methods
    • INDEX BY Table of Records
Get full course syllabus in your inbox

    Explicit Cursors

    • Understand Explicit Cursors
    • Declare the Cursor
    • How to open the Cursor
    • Fetching data from the Cursor
    • How to close the Cursor
    • Cursor FOR loop
    • Explicit Cursor Attributes
    • FOR UPDATE Clause and WHERE CURRENT Clause
Get full course syllabus in your inbox

    Exception Handling

    • What are Exceptions
    • Handle Exceptions with PL/SQL
    • Trap Predefined Oracle Server Errors
    • Trap Non-Predefined Oracle Server Errors
    • Trap User-Defined Exceptions
    • Propagate Exceptions
    • RAISE_APPLICATION_ERROR Procedure
Get full course syllabus in your inbox

    Stored Procedures and Functions

    • What are Stored Procedures and Functions
    • Differentiate between anonymous blocks and subprograms
Get full course syllabus in your inbox

+ More Lessons

Course Design By

naswipro

Nasscom & Wipro

Course Offered By

croma-orange

Croma Campus

Real

star

Stories

success

inspiration

person

Abhishek

career upgrad

person

Upasana Singh

career upgrad

person

Shashank

career upgrad

person

Abhishek Rawat

career upgrad

hourglassCourse Duration

22 Hrs.
Know More...
Weekday1 Hr/Day
Weekend2 Hr/Day
Training ModeClassroom/Online
Flexible Batches For You
  • flexible-focus-icon

    12-Jul-2025*

  • Weekend
  • SAT - SUN
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    14-Jul-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    16-Jul-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-focus-icon

    12-Jul-2025*

  • Weekend
  • SAT - SUN
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    14-Jul-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    16-Jul-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
Course Price :
For Indian
20,000 18,000 10 % OFF, Save 2000
trainerExpires in: 00D:00H:00M:00S
Program fees are indicative only* Know more

SELF ASSESSMENT

Learn, Grow & Test your skill with Online Assessment Exam to
achieve your Certification Goals

right-selfassimage
Get exclusive
access to career resources
upon completion
Mock Session

You will get certificate after
completion of program

LMS Learning

You will get certificate after
completion of program

Career Support

You will get certificate after
completion of program

Showcase your Course Completion Certificate to Recruiters

  • checkgreenTraining Certificate is Govern By 12 Global Associations.
  • checkgreenTraining Certificate is Powered by “Wipro DICE ID”
  • checkgreenTraining Certificate is Powered by "Verifiable Skill Credentials"

in Collaboration with

dot-line
Certificate-new-file

Not Just Studying

We’re Doing Much More!

Empowering Learning Through Real Experiences and Innovation

Mock Interviews

Prepare & Practice for real-life job interviews by joining the Mock Interviews drive at Croma Campus and learn to perform with confidence with our expert team.Not sure of Interview environments? Don’t worry, our team will familiarize you and help you in giving your best shot even under heavy pressures.Our Mock Interviews are conducted by trailblazing industry-experts having years of experience and they will surely help you to improve your chances of getting hired in real.
How Croma Campus Mock Interview Works?

Not just learning –

we train you to get hired.

bag-box-form
Request A Call Back

Phone (For Voice Call):

‪+91-971 152 6942‬

WhatsApp (For Call & Chat):

+91-971 152 6942
          

Download Curriculum

Get a peek through the entire curriculum designed that ensures Placement Guidance

Course Design By

Course Offered By

Request Your Batch Now

Ready to streamline Your Process? Submit Your batch request today!

WHAT OUR ALUMNI SAYS ABOUT US

View More arrowicon

Students Placements & Reviews

speaker
Mohammad Sar
Mohammad Sar
speaker
Poonam-Sharma
Poonam-Sharma
speaker
Mohit-Tyagi
Mohit-Tyagi
speaker
Vikash Singh Rana
Vikash Singh Rana
speaker
Prayojakta
Prayojakta
speaker
Shubham Singh
Shubham Singh
View More arrowicon

FAQ's

The following major payment methods are accepted: cash, major credit cards (Mastercard, Visa, and Maestro), online banking, and other major payment methods. Other services, such as Paytm and UPI, are available.

No, most training facilities charge a fee to cover the cost of study materials. There are no additional fees for students.

Croma Campus offers both a regular and a rapid course, depending on your demands.

There are no prerequisites for this course.

Career Assistancecareer assistance
  • - Build an Impressive Resume
  • - Get Tips from Trainer to Clear Interviews
  • - Attend Mock-Up Interviews with Experts
  • - Get Interviews & Get Hired

FOR VOICE SUPPORT

FOR WHATSAPP SUPPORT

sallerytrendicon

Get Latest Salary Trends

×

For Voice Call

+91-971 152 6942

For Whatsapp Call & Chat

+91-9711526942
1

Ask For
DEMO