Menu
The Complete Oracle PL/SQL Course
by
This The Complete Oracle PL/SQL Course course on LearnVern is completely free. It will provide a comprehensive understanding of the topic and its practical applications.
Free Course
#1
See all ranking
The Complete Oracle PL/SQL Course
by
Learnvern
This The Complete Oracle PL/SQL Course course on LearnVern is completely free. It will provide a comprehensive understanding of the topic and its practical applications.
Free Course
#1
See all ranking
2 Modules
with Certifications
2+ Hours
of Recorded Content
by 10000 Learners
Hindi
Language
2 Modules
with Certifications
2 + Hours
of Recorded Content
by 10000Learners
Read all Reviews
Hindi
Language
Key Features:
This course is completely Free
100% online and Self-paced learning
Available in Multiple languages
Access on Mobile and TV
Full lifetime access to all content
Downloadable Resources
-
Introduction to PL/SQL
Introduction to PL/SQL
-
Basic PL/SQL Block
- Basic Understanding of Procedural Language / Structured Query Language (PL/SQL)
- Introduction to PL/SQL Anonymous Block
- Variable Declaration in PL/SQL
- Practical: Variable Declaration in PL/SQL
- Variable Assignment in PL/SQL
- Practical: Variable Assignment in PL/SQL
- Working with Variables in PL/SQL
- Practical: Working with Variables in PL/SQL
- Comment Styles in PL/SQL
- Assignment: Basics of PL/SQL
- Quiz : Basic PL/SQL Block
-
Conditional Selection Statements
- IF-THEN-ELSE Statements in PL/SQL
- Practical: IF-THEN-ELSE Statements in PL/SQL
- CASE Statement in PL/SQL
- Practical: CASE Statement in PL/SQL
- GOTO Statement in PL/SQL
- Practical: GOTO Statement in PL/SQL
- Assignment: Conditional Selection Statements
- Quiz : Conditional Selection Statements
-
Iteration
- Basic Loop Statement in PL/SQL
- Practical: Basic Loop Statement in PL/SQL
- Numeric FOR Loop in PL/SQL
- Practical: Numeric FOR Loop in PL/SQL
- WHILE Loop in PL/SQL
- Practical: WHILE Loop in PL/SQL
- CONTINUE Statement in PL/SQL
- Practical: CONTINUE Statement in PL/SQL
- Assignment: Iteration
- Quiz : Iteration
-
PL/SQL Exception Handling
- Exception Handling in PL/SQL
- Practical: Exception Handling in PL/SQL
- RAISE Statement for Exception Handling in PL/SQL
- Practical: RAISE Statement for Exception Handling in PL/SQL
- RAISE_APPLICATION_ERROR in PL/SQL
- Practical: RAISE_APPLICATION_ERROR in PL/SQL
- OTHERS Exception Handling in PL/SQL
- Practical: OTHERS Exception Handling in PL/SQL
- Assignment: PL/SQL Exception Handling
- Quiz : PL/SQL Exception Handling
-
Record Types
- Introduction to Record Type
- Table Based Records in PL/SQL
- Practical: Table Based Records in PL/SQL
- User Defined Records in PL/SQL
- Practical: User Defined Records in PL/SQL
- Assignment: Record Types
- Quiz : Record Types
-
Cursors
- Cursors in PL/SQL
- Practical: Cursors in PL/SQL
- Parameterized Cursors in PL/SQL
- Practical: Parameterized Cursors in PL/SQL
- Cursor FOR Loop in PL/SQL
- Practical: Cursor FOR Loop in PL/SQL
- Assignment: Cursor
- Quiz : Cursors
-
Procedures
- Procedures in PL/SQL
- Practical: Procedures in PL/SQL Part-1
- Practical: Procedures in PL/SQL Part-2
- Assignment: Procedures
- Quiz : Procedures
-
Functions
- Functions in PL/SQL
- Practical: Functions in PL/SQL Part-1
- Practical: Functions in PL/SQL Part-2
- Assignment: Functions
- Quiz : Functions
-
Package
- Packages in PL/SQL
- Practical: Packages in PL/SQL Part-1
- Practical: Packages in PL/SQL Part-2
- Assignment: Package
- Quiz : Package
-
Trigger
- Triggers in PL/SQL
- Row-Level Triggers in PL/SQL
- Practical: Row-Level Triggers in PL/SQL
- Statement-Level Triggers in PL/SQL
- Practical: Statement-Level Triggers in PL/SQL
- Compound Triggers in PL/SQL
- Practical: Compound Triggers in PL/SQL
- Assignment: Trigger
- Quiz : Trigger
-
PL/SQL Collection
- Associative Arrays in PL/SQL
- Practical: Associative Arrays in PL/SQL
- Nested Tables in PL/SQL
- Practical: Nested Tables in PL/SQL
- VARRAY in PL/SQL
- Practical: VARRAY in PL/SQL
- Collection Methods in PL/SQL
- Practical: Collection Methods in PL/SQL
- BULK COLLECT and FORALL in PL/SQL
- Practical: BULK COLLECT and FORALL in PL/SQL
- Assignment: PL/SQL Collection
- Quiz : PL/SQL Collection
-
Miscellaneous
- EXECUTE IMMEDIATE Statement in PL/SQL
- Practical: EXECUTE IMMEDIATE Statement in PL/SQL
- Assignment: Miscellaneous
- Quiz : Miscellaneous
-
Course Summary
Course Summary
-
Interview Questions
Interview Questions
-
Career Guideline
Career Guideline
Course Offerings
Certificate you will get
NSDC Certificate of Partnership with LearnVern.
Help build strong resume.
Great add-on to get Internship.
Upgrade your Job with this certificate proof.
Pre Requsites
Basic proficiency in reading and writing.
Familiarity with using technology for research and assignments.
A curious mind and willingness to participate actively.
Course is for
Freshers
Professionals
Students
FAQ's
Similar Courses
Made with 💝 in India