Oracle Database: Advanced PL/SQL Programming
Oracle Database: Advanced PL/SQL Programming is a continuation of the ‘Oracle Database: PL/SQL Programing’ course and it is intended to extend your knowledge and practical skills in PL/SQL programming language. The course covers the stored procedures and functions, triggers, collections, advanced exception handling and packages.
The course is hands-on and you will be provided with full course notes, sample database, instructions how the install Oracle XE on your computer and as well all the examples.
A link to the video recoding of the lecturer’s screen will be sent to you after each session.
Outline
- Declaring procedures and functions
- Using parameters
- Calling procedures and functions
- Procedures and functions as database objects
- Creating triggers
- Row level and statement level triggers
- Database triggers
- Dynamic SQL
- Collections
- Raising application errors
- Creating Packages
Audience
This course is for application developers, database administrators and developers.
Prerequisites
Students taking this course should have taken the following classes or have equivalent knowledge of:
Duration and Training Formats
The overall duration of the course is 10 hours
Training Formats
- At your site
- Live on-line instructor-led
- Public classes
Course Language
- English