Oracle Database PL/SQL Developer Workshop

The Oracle Database 19c: PL/SQL Workshop course provides a comprehensive understanding of Oracle's PL/SQL language for efficient database management. Participants learn to write codes, manage dependencies, handle exceptions, and create triggers, procedures, functions, and packages. The training covers Oracle-supplied packages and best practices, ensuring proficiency in SQL, PL/SQL, and database optimization.

On successful Completion of this course you will be able to:

• Create, execute, and maintain Procedures and functions
• Create, execute, and maintain Package constructs
• Create, execute, and maintain Database triggers
• Manage PL/SQL subprograms and triggers
• Use a subset of Oracle-supplied packages to generate screen and file output
• Identify various techniques that impact your PL/SQL code design considerations
• Use the PL/SQL compiler and manage dependencies