CLASSROOM
TENTATIVE

SCHEDULES


Nov 20, 2017 9:00 am 18:00 pm
Nov 21, 2017 9:00 am 18:00 pm
Nov 22, 2017 9:00 am 18:00 pm
Nov 23, 2017 9:00 am 18:00 pm
Nov 24, 2017 9:00 am 18: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