• Skillsoft Blog
  • Skillsoft Facebook
  • Skillsoft Twitter
  • Skillsoft YouTube
  • Skillsoft LinkedIn

Oracle Database 10g Program with PL/SQL Exam 1Z0-147 


Course Objective:

  This course counts towards the Hands-on course requirement for the Oracle Forms Developer Certified Professional Certification.


Pre-requisite:

· Oracle Database 10g: Introduction to SQL
Oracle Database 10g: SQL Fundamentals I


Course Contents:

· Introduction to PL/SQL
· Declaring PL/SQL Identifiers
· Writing Executable Statements
· Interacting with the Oracle Server
· Writing Control Structures
· Working with Composite Data Types
· Using Explicit Cursors
· Handling Exceptions  
· Creating Stored Procedures
· Creating Stored Functions
· Creating Packages
· Utilizing Oracle Supplied Packages in Application Development
· Creating Triggers
· Applications for Triggers
· Understanding and Influencing the PL/SQL Compiler

 

Find out more about Amfasoft's education offerings