Oracle Database 12c Program with PLSQL

This course covers the following;

• Working with Oracle Cloud Exadata Express Cloud Service

• Introduction to PL/SQL

• Declare PL/SQL Variables

• Write Anonymous PL/SQL Blocks

• SQL Statements in a PL/SQL block

• Control Structures

• Composite Data Types

• Explicit Cursors

• Exception Handling

• Stored Procedures

• Stored Functions

• Debugging Subprograms

• Deploying Packages

• Implement Oracle-Supplied Packages in Application Development

• Dynamic SQL

• Design Considerations for PL/SQL Code

• Triggers

• Creating Compound, DDL, and Event Database Triggers

• PL/SQL Compiler

• Manage Dependencies

This course requires the following prerequisites;

• Oracle Database: Introduction to SQL

• Previous programming experience

You will learn how to:

• Manage dependencies between PL/SQL subprograms

• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)

• Create stored procedures and functions

• Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code

• Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output

• Write dynamic SQL for more coding flexibility

• Create overloaded package subprograms for more flexibility

• Create triggers to solve business challenges

• Create and debug stored procedures and functions

• Describe the features and syntax of PL/SQL

• Design PL/SQL anonymous blocks that execute efficiently

• Design PL/SQL packages to group related constructs

• Handle runtime errors

This course prepares you for the following Certifications:

• Oracle Database certifications.