title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 11g: PL/SQL Fundamentals II - Develop Program Units
Duration
3 Days
Course
DBOR-919
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle Database 11g: PL/SQL Fundamentals II - Develop Program Units course is designed to equip students to develop database server-side PL/SQL program units within an Oracle database.Objectives
Upon completion of the Oracle Database 11g: PL/SQL Fundamentals II - Develop Program Units course, students will be able to:
- Understand application partitioning within a client/server or multi-tiered web-based systems architecture
- Understand the basic form and structure of program units stored within the database
- Build and maintaining database-resident program units
- Encapsulate program units within packages and taking advantage of accompanying advanced programming techniques such as cursor variables and cursor expressions
- Handle intricate theoretical challenges, such as mutating tables
- Build and maintain DML-event and system-event database triggers, including advanced techniques using both simple triggers and compound triggers
- Discuss the storage and execution model for database programs and how one can write efficient programs to maximize performance
- Use system-supplied packages to extend the power of your SQL statements and PL/SQL applications
Audience
Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
- Application designers and developers
- Database administrators
Prerequisites
- DBOR-917 ORACLE DATABASE 11G R2: SQL FUNDAMENTALS – COMPLETE LIBRARY
- DBOR-918 ORACLE DATABASE 11G R2: PL/SQL FUNDAMENTALS I
Topics
- ABOUT database program units
- TYPES of pl/sql program units
- TYPES of stored program units
- ADVANTAGES of using stored program units
- ABOUT stored procedures & functions
- CREATING procedures & functions
- EXECUTING procedures & functions
- RECOMPILING & dropping programs
- DATA dictionary storage
- MANAGING dependencies
- ABOUT packages
- CREATING packages
- ADVANCED programming techniques
- MAINTAINING packages
- USING cursor variables
- USING cursor expressions
- DBMS_OUTPUT()
- UTL_FILE()
- ABOUT database triggers
- STATEMENT-level triggers
- ROW-level triggers
- EXAMPLES of triggers
- INSTEAD of triggers
- EPMPLOYING triggers within an application
- CALL syntax
- TRIGGER maintenance tasks
- SHOW errors trigger
- DROP trigger
- ALTER trigger
- HANDLING multiple triggers for a table
- HANDLING mutating table issues
- WHAT are system event triggers?
- DEFINING the scope
- AVALAIBLE system events
- SYSTEM attributes
Related Courses
-
Oracle Database 11g: SQL Fundamentals I
DBOR-915- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Oracle Database 11g: SQL Fundamentals II
DBOR-916- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.