CLASSROOM
TENTATIVE

SCHEDULES


Oct 8, 2018 8:00 am 17:00 pm
Oct 9, 2018 8:00 am 17:00 pm
Oct 10, 2018 8:00 am 17:00 pm
Oct 11, 2018 8:00 am 17:00 pm
Oct 12, 2018 8:00 am 17:00 pm
REGISTER NOW

ORACLE

ADVANCED ORACLE PL/SQL

DESCRIPTION
Extend the functionality of the SQL language with PL/SQL to write application codes. This will help your organization realize the full benefit of utilizing Oracle best practices.
COURSE CONTENT
  • Introduction to PL/SQL
  • Declare PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures
  • Stored Functions and 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 PL/SQL Code
  • Manage Dependencies