Save for later

The Complete PL/SQL Bootcamp

Latest Course Updates:

  • (Jan 2022): "Oracle-Supplied PL/SQL Packages" section is added.

  • (Nov 2021): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added.

  • (Sep 2021): Closed-Captions are added.

  • (Aug 2021): New Quiz Questions are added.

Become an Oracle Database PL/SQL Developer Certified Professional.

This comprehensive PL/SQL Programming Bootcamp is created for Real Beginner to Advanced PL/SQL Subjects with hundreds of Real-World Examples. Every subject starts from the simplest for non-programmers and goes until the most advanced parts for the students who already know PL/SQL. Every student who wants to learn or Become a Hero in PL/SQL will find everything that they are looking for. 

Students will learn and improve their:

  • PL/SQL Coding Skills

  • SQL & PL/SQL Performance

  • PL/SQL Scalability

  • Portability and Security about Database and PL/SQL Programming

And also our students will be prepared for:

  • Exam Number: 1Z0-149 Oracle Database 19c: Program with PL/SQL  Oracle Certification Exam

  • Exam Number: 1Z0-148 Oracle Database 12c: Advanced PL/SQL        | Oracle Certification Exam

  • Exam Number: 1Z0-144 Oracle Database 12c: Program with PL/SQL | Oracle Certification Exam

  • Exam Number: 1Z0-144 Oracle Database 11g: Program with PL/SQL | Oracle Certification Exam

Our PL/SQL Programming Bootcamp Covers:

  • PL/SQL Terminologies

  • PL/SQL Architecture

  • PL/SQL Variables

  • PL/SQL Control Structures

    • If-Then-Else Structure

    • Case Expressions

    • Loops

      • While Loop

      • For Loop

      • Nested Loop

      • Loop Labeling

      • Continue Statement

      • GOTO Statement

  • Using SQL inside PL/SQL

  • PL/SQL Cursors

  • Using PL/SQL Program Units (Functions & Procedures)

  • PL/SQL Packages

  • PL/SQL Exceptions & Exception Handling

  • PL/SQL Debugging

  • Dynamic SQL & PL/SQL

  • PL/SQL Composite Data Types (Collections)

    • Associative Arrays

    • Nested Tables

    • Varrays

    • Records

  • PL/SQL Triggers

  • Oracle-Supplied Packages

  • Using Large Objects in PL/SQL (LOBs)

  • Using PL/SQL Object Oriented

  • Using PL/SQL Compiler

  • PL/SQL Performance &Tuning

  • PL/SQL Caching

  • PL/SQL Security

  • PL/SQL Fine-Grained Access Control (VPD)

  • PL/SQL Hints

  • PL/SQL Object Dependencies

  • Designing Better PL/SQL

  • Using Java/C in PL/SQL

  • Managing Dependencies

Important Note: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQL

See you in the first lecture.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Udemy and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating 4.3★ based on 211 ratings
Length 25 total hours
Starts On Demand (Start anytime)
Cost $19
From Udemy
Instructors Oracle Master Training • 40,000+ Students Worldwide, Code Star Academy, Oracle Master Training • 50,000+ Students Worldwide, Oracle Master Training • 70,000+ Students Worldwide, Oracle Master Training • 75,000+ Students Worldwide, Oracle Master Training • 100,000+ Students Worldwide
Download Videos Only via the Udemy mobile app
Language English
Subjects Data Science Programming
Tags Databases Development Database Design & Development

Get a Reminder

Send to:

Similar Courses

What people are saying

very good

The language is clear, the examples are good and the instructor has a very good knowledge about the themes.

A very good course.

Very good!!

i like how you show the error and how to correct them It is a very good match already.

great course, Thanks for the material Instructor is very good at explaining the subject in detail.

Very good tutorial.

Very good experience 1-Très précis dans la description avec un bon Anglais.

and no progress made in actual PL/SQL part very intuitive Very good explanation and detail analysis, the tutor is really amazing.

I have no idea whats happening on this course as i am a basic learner Hi; Course is very good explanatory and has a good price/performance ratio.

The information given is very good.

His way of learning is very good.

Very good =) The speaker is giving good info but there is miss in clarity, as the speaker is speaking fast, so couldn't catch few points.Otherwise its good.

exlent Trainer is very good and organized.

Read more

so far

It covers almost all the topics I think this is the best course about PL SQL I've done so far!

Great job so far.

Great course Concepts properly explained with examples It's been great so far, I'm excited to learn more it was good for me because you explaining in a way i can understand with the addition of examples too provide more clarity why to use Pl/SQL Great and complete course!

Enough information for an introduction good So far it is good to understand step by step, Hope the whole session will be like this only.

Good course on SQL basics, accent is a problem though but it's ok So far so good, but waiting on the PL/SQL Performance Tuning (Last part of the course) yes Thank you!

I figured that I'll just have to wait :) Now when having gone this through am abit amazed how this resembles to what i locally do with access/ vba... Ofcourse with oracle having servers etc the scale is many times bigger and more complex than with local datamining... Anyways... will need to follow up if u guys for u'd get this course to end... :) When this happens this course will be worth 5stars :) Excellent lecture by driving with examples So far so good The instructor is really good.

So far, very good, but can't give 5 stars for unfinished course An excellent course.

Simple and understandable Great course so far.

So far this is an excellent course!

So far, it's working out.

Not understanable The Best PL SQL course so far.

it has never been so easy to learn ok so far ok Very clear tutorial and helped me to start my new job confidently that requires SQL and PL/SQL.

Read more

easy to understand

Examples and explanations are easy to understand.

Me gusta como explica, suele detallar muchas cosas aunque me hubieran gustado más ejercicios prácticos Interesting, easy to understand Wonderful teacher and his dedication to course material is just awsome :) This is my second course with Mr Omer.

説明がわかりやすいし、骨枠の説明がわかりやすい Great course good accent is hard sometimes , i will edit rating at the end of the course Clear Explanation and Content delivery simple and easy to understand :) I am having a hard time understanding the presenter due to his accent.

Omer's speech is very fluent and easy to understand.

Easy to understand and examples are very clear.

He just makes complex things very simple and easy to understand.

Easy to understand easy to learn.

Read more

by step

course content could be better step by step very detailed explanation yes,I am using this course to fill up my knowledge gaps in pl/sql.

Instructor is very knowledgeable and very methodically in covering each part of the PL/SQL language, step by step.

Step by step the instructor drives you to increasingly more difficult concepts and provides you with deep and structured knowledge.

Read more

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Oracle Database Instructor $79k

Oracle Database Administrator - OCP $85k

Database Analyst - Oracle $99k

Database Analyst - Oracle Developer $107k

Oracle Database Administrator Expert $119k

Oracle Apps Database Administrator $126k

Oracle Database Administrator / Oracle Application DBA $135k

Oracle/Peoplesoft Database Administrator $142k

Oracle Database Administrator / Developer $144k

Senior Database Analyst - Oracle $158k

Senior Oracle Database Admin $174k

Principal Oracle Database Administrator $252k

Write a review

Your opinion matters. Tell us what you think.

Please login to leave a review
Login or register with your email instead.
Rating 4.3★ based on 211 ratings
Length 25 total hours
Starts On Demand (Start anytime)
Cost $19
From Udemy
Instructors Oracle Master Training • 40,000+ Students Worldwide, Code Star Academy, Oracle Master Training • 50,000+ Students Worldwide, Oracle Master Training • 70,000+ Students Worldwide, Oracle Master Training • 75,000+ Students Worldwide, Oracle Master Training • 100,000+ Students Worldwide
Download Videos Only via the Udemy mobile app
Language English
Subjects Data Science Programming
Tags Databases Development Database Design & Development

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now

Special thanks to our sponsors