Oracle Database 12c R2: Program with PL/SQL Ed 2

This course requires the following;

• Oracle Database: Introduction to SQL
• Previous programming experience

What you will learn:

• 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 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
• Packages
• 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 prepares you for the following Certifications:

• Oracle PL/SQL Developer Certified Associate Certification