Network Technology

PL/SQL programming is an intense hands-on course that is designed to give the participant maximum exposure to Oracle PL/SQL. The participant learns by doing, and this class has dozens of in-class exercises and the participant will be guided from very simple SQL commands to increasingly complex PL/SQL coding techniques.

The topics start with the basics of SQL and progress into increasingly complex queries, including table joins, subqueries and creating Oracle views. The PL/SQL section begins with simple concepts and the participant gradually masters PL/SQL through increasingly challenging classroom exercises.

This course is designed for practicing Oracle professionals who have basic experience with SQL and the use of a relational database. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.
Learning Objectives

By the end of this course the participant will be able to write advanced PL/SQL code blocks, and will be able to use advanced features such as ref cursors and bulk fetches. The participant will also become familiar with the internals of Oracle PL/SQL and will be able to compile PL/SQL for super-fast performance.
Basics of PL/SQL he topics start with the basics of SQL and progress into increasingly complex queries, including table joins, subqueries and creating Oracle views. The PL/SQL section begins with simple concepts and the participant gradually masters PL/SQL through increasingly challenging classroom exercises.

This course is designed for practicing Oracle professionals who have basic experience with SQL and the use of a relational database. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.