Oracle Database: Program with PL/SQL Training

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more. Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

There are no prerequisites for this course.

Application Developers
Database Administrators
System Analysts
Forms Developer
Developer
Technical Consultant
Portal Developer
PL/SQL Developer

Conditionally control code flow (loops, control structures).
Create stored procedures and functions.
Use PL/SQL packages to group and contain related constructs.
Create triggers to solve business challenges.
Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
Create custom packages for applications.
Write Dynamic SQL code for applications.

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

Oracle Database: Program with PL/SQL Training

Prerequisites

Who Should Attend

What You Will Learn

Outline