Oracle Program with PL/SQL
Course
In London and Manchester
Description
-
Type
Course
-
Location
-
Class hours
35h
-
Duration
5 Days
By the end of this course, the delegate will be able to write PL/SQL programs, manage stored program units, implement package constructs and handle Large Objects programmatically. Suitable for: This course is designed for Oracle programmers and developers and provides practical experience in writing stand-alone PL/SQL programs and database triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.
Facilities
Location
Start date
Start date
Start date
About this course
Attendance on the pre-requisite Oracle SQL course and practical experience in writing SQL statements. Some prior programming experience will also prove advantageous.
Reviews
Subjects
- PL/SQL
- To provide the skills needed to develop
- Write and maintain PL/SQL scripts
- Triggers
- Stored program units and packages
Course programme
The Oracle Program with PL/SQL training course introduces the delegate to Oracle's PL/SQL programming language and provides practical experience in writing stand-alone programs, developing database triggers and implementing stored functions, procedures and packages. It also introduces some of the Oracle-supplied packages.
Skills Gained
The delegates will practise:
- Writing and running PL/SQL programs from SQL*Plus or SQL Developer
- Declaring and using variables and constants
- Assigning and manipulating values
- Using SQL statements within PL/SQL
- Implementing conditional execution and loop constructs
- Declaring and using cursors with and without parameters
- Updating data with cursors
- Trapping and handling errors and exceptions in code
- Implementing nested and labelled loops and blocks
- Raising exceptions
- Handling PL/SQL records and Index-By tables
- Using PL/SQL Index-By table built-in functions
- Implementing various types of trigger
- Creating, managing and invoking stored procedures
- Creating, managing and executing stored functions
- Developing and using packages
- Using package features and constructs effectively
- Wrapping packages
- Using Cursor Variables
- Using records and Index-By tables or associative arrays in packages
- Implementing Bulk Binding and Bulk Collecting techniques
- Managing program unit dependencies
- Implementing Native Compilation and Compile-time Warnings
- Implementing Native Dynamic SQL
- Using a variety of Oracle-supplied packages
Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts and implement or maintain database triggers, program units and packages.
Course Objectives
To provide the skills needed to develop, write and maintain PL/SQL scripts, triggers, stored program units and packages.
Examinations
The Oracle Program with PL/SQL course is suitable for delegates intending to sit the Oracle examination #1Z0-144 - Oracle Database 11g: Program with PL/SQL & the Oracle PL/SQL Developer Certified Associate examination #1Z0-147 - Program with PL/SQL Oracle examination.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Oracle Program with PL/SQL