Aptech Computer Education - Oracle 9i: Programme with PL/SQL (Paper 2)

Oracle 9i: Programme with PL/SQL (Paper 2)

Procedural Language/SQL (PL/SQL) extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. This paper introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. By the end of this segment, students will be able to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. The students will also learn to create procedures, functions, packages, and database triggers

Who will the course benefit?

Students and working professionals who wish to gain expertise in PL/SQL

What skills will the student gain?


Prerequisites
Prior knowledge of SQL, and iSQL*Plus is necessary

Duration
40 hours

Certification
Certificate of participation (Additionally, students can appear for Oracle 9i PL/SQL vendor certification)

After the completion of this course, the student will be able to:

Describe the features and syntax of PL/SQL

Explain writing executable statements

Explain the control structures

Describe and use composite data types

Explain the process of writing explicit cursors

Describe subprogrammes

Describe the use of functions

Describe packages in PL/SQL

List and explain Oracle server-supplied packages

Describe triggers

> Back