Search
Close this search box.

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
Enroll Now
Share

#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
Enroll Now
Share

#1

See all ranking

3 Modules

with Certifications

2+ Hours

of Recorded Content

by 10000 Learners

Hindi

Language

3 Modules

with Certifications

2 + Hours

of Recorded Content

by 10000 Learners

Hindi

Language

About

Key Features

Content

FAQs

What's in it for You?

Key Features:

Available in multiples Languages
100% Self Paced Course
Lifetime access to all content
Downloadable Resources

Topics you will learn

  • 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

Certificate Features

NSDC Certificate of Partnership with LearnVern.
Help build strong resume.
Great add-on to get Internship.
Upgrade your Job with this certificate proof.

After this Course

Pre Requsites

Curious Mind to learn new concepts
Strong internet connection

Course is for

Freshers

Professionals

Students

FAQ's

The course focuses on The Complete Oracle PL/SQL Course. It covers fundamentals through 3 interactive modules.
The course offers over 2 hours of recorded content.

Yes, there is a Paid Certification included with this course. The course material is entirely free; however, certification in this course requires payment of ₹999.

The course is currently available in Hindi.
Curious Mind to learn new concepts & Strong internet connection

The course is accessible on both web and mobile platforms.

This course is completely Free
To enroll in this course you can click on the Enroll Now button it will redirect you to course page, and on that page you can access the The Complete Oracle PL/SQL Course course completely free.

Similar Courses

Learnvern

English Grammar And Punctuation

2 Hours
4.6
10000
View Course
Learnvern

Stock Market And Stock Trading in Tamil

2 Hours
4.3
10000
View Course
Learnvern

Google Sheets Course

2 Hours
4.7
10000
View Course
Learnvern

Recruiter Training Course in English

2 Hours
4.8
10000
View Course
Learnvern

Selling on ECommerce – Amazon, Shopify in Tamil

2 Hours
10000
View Course
Learnvern

Stock Market And Stock Trading in Telugu

2 Hours
4
10000
View Course
Learnvern

Import And Export – The Complete Business Guide

2 Hours
4.8
10000
View Course

Course Vendors

Categories

Quick Links

Follow us on !

Instagram Linkedin
Made with 💝 in India
© Copyright 
2024
, OJSANT Technologies Pvt. Ltd.

Share this course within your network

WhatsApp
Facebook
Telegram
LinkedIn
Threads
X

Page Link