This 3-day Oracle PL/SQL Programming Introduction training course provides a solid, hands-on introduction to the Oracle PL/SQL programming language that is used for creating stored procedures, user functions and database triggers in an Oracle database. This course is for students who are new to the Oracle PL/SQL programming language.

While this course utilises the Oracle 11g release for practical purposes, it is highly suitable for users of earlier or more recent releases of the Oracle RDBMS.

The Oracle 11g release has greatly enhanced the features and functionality of PL/SQL. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units.

Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.

Course Outline