Rating 4.63 out of 5 (2101 ratings in Udemy)

• 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