This course runs for a duration of 3 Days.
The class will run daily from 12:00pm EST to 8:00pm EST.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
This course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers
Learn To:
Benefits to You
Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. In this course, students learn and use Oracle SQL Developer as the main environment tool to develop these program units. SQL*Plus is introduced as optional tools. Demonstrations and hands-on practice reinforce the fundamental concepts.
Audience:
Course Objectives:
Introduction
Working with Oracle Database Exadata Express Cloud Service
Creating Stored Procedures
Creating Functions and Debugging Subprograms
Creating Packages
Working With Packages
Using Oracle-Supplied Packages in Application Development
Using Dynamic SQL
Creating Triggers
Creating Compound, DDL, and Event Database Triggers
Design Considerations for PL/SQL Code
Using PL/SQL compiler
Managing Dependencies