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 learn the basic functionality of how to debug functions and procedures using the SQL Developer Debugger. 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. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies.

Prerequisites

High School Diploma or entrance examination (Workkey)

Oracle 11g Introduction to SQL Course or Oracle SQL Foundation

Previous Basic Programming Experience

Class Schedule for the Fall quarter 2010

Schedule

Start

Finish

Days

Time

1^st Schedule

2/18/2011

3/30/2011

Fri and Sat

6:00 to 10:00 pm

2^nd Schedule

4/10/2011

5/30/2011

Fri and Sat

6:00 to 10:00 pm

3^rd Schedule

6/10/2011

7/30/2011

Fri and Sat

6:00 to 10:00 pm

More Information
Instructor	Fareed	Phone	571-405-6465
Course Duration	Five Weeks Tuition = $3,000.00
Program Schedule	60 Lecture Hours and unlimited Lab Hours
Reg = $75.00	Click here to apply now