Oracle PL/SQL is My Game: EXAM 1Z0-149

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

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

What you’ll 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.

Course Content

  • Course Setup –> 14 lectures • 1hr 28min.
  • Overview of PL/SQL –> 5 lectures • 29min.
  • Declaring PLSQL Variables –> 10 lectures • 56min.
  • Writing executable statements –> 4 lectures • 24min.
  • Interacting with Oracle DB Server –> 4 lectures • 19min.
  • Writing Control structure –> 10 lectures • 56min.
  • Working with Composite Data Types –> 9 lectures • 1hr 10min.
  • Using explicit cursors –> 6 lectures • 42min.
  • Handling Exceptions –> 7 lectures • 38min.
  • Creating Procedure –> 10 lectures • 1hr 3min.

Oracle PL/SQL is My Game: EXAM 1Z0-149


  • You should know Oracle SQL ( 11g or 12c).
  • You should have strong knowledge in (SELECT statement, DML, DDL, DCL, creating views, indexes, and synonyms).
  • Windows Operating system is preferred, but this is not mandatory if you have the knowledge of downloading Oracle database on other OS.
  • Downloading oracle database and this will be covered in details on Windows OS..
  • No need for any previous experience in PL/SQL, this Course starts from zero in PL/SQL.

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….