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
Who this course is for:
- Students who wants to be expert in PL/SQL programming
- Students who wants to be certified in PL/SQL
- Fresh and junior programmers who need to find better jobs by gaining oracle certification
- Students who already know Oracle SQL and they need to move to next level which is PL/SQL
Deal Score0
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.