###### tags: `PL/SQL`

# The next journey after the PL/SQL fundamentals course

## Course: Oracle Database: Develop PL/SQL Program Units

Topics:

- Packages: Group and manage your PL/SQL code
- Dynamic SQL: Use DDL statements in PL/SQL
- Triggers: Automatically execute PL/SQL code to respond to events.
- e.g., Update or Insert into a table. (DML trigger)
- [9 PL/SQL Triggers, Database PL/SQL Language Reference](https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-triggers.html#GUID-E76C8044-6942-4573-B7DB-3502FB96CF6F)
- Use Oracle-supplied packages
- UTL_FILE: Read and write files on the server
- UTL_MAIL: Send email from PL/SQL
- UTIL_HTTP: Make http request from PL/SQL

## Continue to learn various PL/SQL packages according to your job role(s)

- Database Administrator(DBA)
- DBMS_SCHEDULER, DBMS_STATS, DBMS_REDEFINITION, DBMS_...
- [PL/SQL Packages and Types Reference, v19](https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/APEX_APPLICATION-through-APEX_ZIP.html#GUID-4AA6AA30-CAEE-4DCD-B214-9AD51D0229B4)
- Apex Developer
- APEX_MAIL, APEX_UTIL, APEX_COLLECTION, APEX...
- [Apex API Reference, v19.2](https://docs.oracle.com/en/database/oracle/application-express/19.2/aeapi/preface.html#GUID-5AE2CC45-D209-4292-AED5-3B7D86D35634)

## Oracle Certifications

SQL/PLSQL Certifications:
- [Oracle Database SQL Certified Associate](https://education.oracle.com/oracle-database-sql-certified-associate/trackp_457)
- [Oracle Database PL/SQL Developer Certified Professional](https://education.oracle.com/oracle-database-pl-sql-developer-certified-professional/trackp_OCPPLSQL19C)

Apex Developer Certifications:
- [Oracle APEX Cloud Developer Certified Professional](https://education.oracle.com/oracle-apex-cloud-developer-certified-professional/trackp_APEX23OCP)

Database Administrator Certifications:
- [Oracle Database Administration 2019 Certified Professional](https://education.oracle.com/oracle-database-administration-2019-certified-professional/trackp_DB19COCP)
- 1z0-082: Oracle Database Administration I
- 1z0-083: Oracle Database Administration II

## Oracle Apex

[Oracle APEX: From Idea to Application at the Speed of Light by Joel R. Kallman, 2020](https://www.youtube.com/watch?v=gHgaRBqiveA)

<p style="text-align: right">

<iframe width="280" height="150" src="https://www.youtube.com/embed/gHgaRBqiveA" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

</p>