Oracle Program with PL/SQL

Book Now - 2 Delivery Methods Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
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.
Objectives
The delegate will learn and acquire skills as follows:
- 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
Target Audience
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.
Additional Information
- Course technical content is subject to change without notice.
- Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
A working knowledge of Oracle SQL or SQL Developer is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite courses. Some previous programming experience will also prove advantageous as well as practical experience in writing SQL statements.
Additional Learning
The courses below may help you meet the knowledge level required to take this course.
-
Oracle SQL
The SQL training course is designed for anyone who needs to access and work with an Oracle Database
Relevant Certifications
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.