Description

This course will introduce students to the basics of PL/SQL subprograms. Students will learn how to write and invoke PL/SQL procedures, functions and packages. Using Oracle's 11g Enterprise Database Server, students will engage in hands-on lab work in both Oracle's Procedure Builder and SQL*Plus environments. Students will learn how to create and manage PL/SQL program units, database triggers, and common Oracle-supplied packages. This course will aid students in preparation for certification as an Oracle PL/SQL Developer Certified Associate and also qualifies as an Oracle's 11g DBA OCP Hands-On Approved Course. Prerequisite: None Credits: 3.0