Skip to content
UdemySQLPaid courseAll LevelsCertificate

Oracle PL/SQL is My Game: EXAM 1Z0-149 (Udemy.com)

Become Oracle PL/SQL Developer / Covers ORACLE university track 100%. All the presentations & scripts are attached

Created by: Khaled Alkhudari

Last updated May 2024

icon
What you will learn

  • The full track of Oracle university Exam 1Z0-144 : Program with PL/SQL
  • Oracle Database 12c Architecture
  • Downloading and installing oracle database 12c in details
  • Overview of PLSQL
  • Declaring PLSQL Variables
  • Writing executable statements
  • Interacting with Oracle DB Server
  • Writing Control structure
  • Working with Composite Data Types
  • Using explicit cursors
  • Handling Exceptions
  • Creating Procedures
  • Creating Functions
  • Creating Packages
  • Working with Packages
  • Using oracle-supplied Packages in Application Development
  • Using dynamic SQL
  • Design consideration for PLSQL Code
  • Creating triggers
  • Creating Compound, DDL, and Event Database Triggers
  • Using the PLSQL Compiler
  • Managing PLSQL Code
  • Managing Dependencies

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.7 out of 5higher than 89% of them
  • Reviews4,281#45 of 389 by number of reviews
  • Length21.9 hourslonger than 95% of them
  • Last updatedMay 2024more recently than 53% of them

icon
Course Description

This is one of the most amazing Udemy courses in Oracle PLSQL.

The course covers the oracle university track 100% for :

Exam Number: 1Z0-149 : Program with PL/SQL

I designed in this course in a very professional structure that includes huge amount of exercises and examples.

Be sure that you will become expert in PLSQL programming after finishing this course, and you will be ready 100% to pass the Oracle Exam. 

You will find all the presentations and all the SQL scripts attached in every chapter, so no need to waste your time repeating any example I did.

Simply this course is the best….


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Khaled Alkhudari

My name is Khaled Al Khudari, I graduated in 2003 in computer science.

I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat  and many others )

I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others )

I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft  and desire to learn .

I believe in success through hard work & dedication.

My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’.



icon
More courses by Khaled Alkhudari

$19.99

$99.99

$13.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.7

4,281 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Vedant Vinay on 10/22/2024

Barring few points listed below, everything else is good: > Some typos observed in Q&A > Sometimes it feels too repetetive like say if 3 inserts are being done to table, each one of them is repeated. If you extrapolate this throughout the course, this could be unnecessary cause elongated session. In short I feel it could be more concise. But then may be I think if someone if just on audio mode, it may be helpful for them.

By Anonymized User on 6/9/2023

Good content. Good explanation. However, the course contains a major problem & that is indentation. Without indentation, it is quite difficult to read the code (leads to "is this line inside if ?", "Is this line outside the for loop ?" etc. kind of questions). Please, please fix this. In Chapter 168, i is used as a for loop variable over the employees table. Generally, i is used as an array index, whereas here it refers to an employee row, better to use e or emp. The English subtitles can be improved quite a lot.

By Anita Lees on 11/21/2020

I had some problems installing Oracle on the windows computer, and your advice was very helpful.

By Kazi on 11/21/2020

The best tutor.

By Ronald Smith on 11/7/2020

This course is trash he jumps all over the place the lesson does not flow you will loose you energy and love for doing this cause he doesnt make sense .

By Irena Miteva on 11/7/2020

Wow wow wow! :)
The best course I have ever completed on Udemy. Of course I loved ORACLE before, but after finishing this course I love it so much more!
Thank you Khaled for sharing all your knowledge and hints about this topic! I am so impressed by your energy and the way you explained every possible functionality covered here, to the fullest.
Thank you very much & keep on creating this great stuff.
Thank you!

By Irena Miteva on 11/5/2020

Wow wow wow! :) The best course I have ever completed on Udemy. Of course I loved ORACLE before, but after finishing this course I love it so much more! Thank you Khaled for sharing all your knowledge and hints about this topic! I am so impressed by your energy and the way you explained every possible functionality covered here, to the fullest. Thank you very much & keep on creating this great stuff. Thank you!

By Anjali on 10/15/2020

course is very nice.

By Niranjan Kale on 10/11/2020

Nice one ... I was waiting for such material for long now

By S Kolajo Rokiben Limited on 10/9/2020

Great content.

By Diego Ferney Mayorga Rodriguez on 10/6/2020

I aproved the exam with a very good grade thanks to this course. THANK YOU.

By John Richelieu Boima on 10/3/2020

"Very Nice!"

Showing 12 of 212 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100