This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
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, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.
To be a more effective Oracle Developer, we recommend basic knowledge of Oracle DBA. We can offer a 1 day customized course on Oracle DBA after the first module SQL Fundamentals.
|Boot Camp Schedule for Oracle 11g: PL/SQL Developer OCA|
|Course Contents||Exam #||Regular Track (days)||Super Fast Track (Days)|
|Oracle Database: Introduction to SQL NEW||1Z0-051||6||3|
|Oracle Database: Program with PL/SQL NEW||1Z0-147||6||3|
|Balance Days for day of arrival, exam(s) and practice||4||3|