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.
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
Composite Data Types
Implement Oracle-Supplied Packages in Application Development
Design Considerations for PL/SQL Code
Creating Compound, DDL, and Event Database Triggers