VTEM Banners
VTEM Banners
VTEM Banners
Facebook  Twitter  LinkedIn
Call Now

1-804-562-4798 (Richmond)

1-703-310-7133 (Fairfax)       1-866-477-2261 (Toll Free)

Oracle 12c PL/SQL and Forms Developer

Course length:  40 hours

For your convenience, we offer flexible scheduling:

  • For those that want to get it done all at once we offer the option of an intensive week long program from 9am to 5pm, Monday through Friday
  • For those that are available only on Saturdays, we offer a 5 week program from 9am to 5pm

Target Student:

The target student is anyone with advanced computer user skills who is interested in obtaining a job as an Oracle Forms Developer. In addition, this course will help prepare students for the OCP: PL/SQL Forms Developer Certification.

Course Description:

This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Participants are made aware of how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. In addition, creation of anonymous PL/SQL blocks as well as stored procedures and functions are covered in this course.

Participants enhance their developer skills by learning to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Understanding the basic functionality of how to debug functions and procedures using the SQL Developer Debugger gives way to refined lines of code. Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers, and trapping exceptions. The utilization of some of the Oracle-supplied packages is also part of the course. Additionally participants learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies.

This course is the bundle of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.

Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

This is appropriate for a 11g and 12c audience. There are minor changes between 11g and 12c features.

Objectives:

Upon completion of this course, students will be able to:

  • Conditionally control code flow (loops, control structures)
  • 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 anonymous PL/SQL blocks, functions, and procedures
  • Declare PL/SQL Variables

Latest News

Follow us on Facebook and Twitter for daily updates and offers

Contact Info

1311 High Point Ave. Richmond, VA 23230 Phone: 804-562-4798

 

4041 University Dr. #101 Fairfax, VA 22030 Phone: 703-310-7133

© 2014 GIT Services. All rights reserved. Privacy Policy