Course 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.
What you’ll learn
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
Requirements
- DBOR-917 ORACLE DATABASE 11G R2: SQL FUNDAMENTALS – COMPLETE LIBRARY
- DBOR-918 ORACLE DATABASE 11G R2: PL/SQL FUNDAMENTALS I
Target audiences
- 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
Curriculum
- 1 Section
- 9 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics9
- 1.1INTRODUCING DATABASE PROGRAM UNITS ABOUT database program units TYPES of pl/sql program units TYPES of stored program units ADVANTAGES of using stored program units
- 1.2CREATING STORED PROCEDURES & FUNCTIONS ABOUT stored procedures & functions CREATING procedures & functions EXECUTING procedures & functions
- 1.3MAINTAINING STORED PROCEDURES & FUNCTIONS RECOMPILING & dropping programs DATA dictionary storage MANAGING dependencies
- 1.4CREATING & MAINTAINING PACKAGES ABOUT packages CREATING packages ADVANCED programming techniques MAINTAINING packages
- 1.5ADVANCED CURSOR TECHNIQUES USING cursor variables USING cursor expressions
- 1.6USING SYSTEM-SUPPLIED PACKAGES DBMS_OUTPUT() UTL_FILE()
- 1.7RETAINING DATABASE TRIGGERS ABOUT database triggers STATEMENT-level triggers ROW-level triggers EXAMPLES of triggers INSTEAD of triggers EPMPLOYING triggers within an application
- 1.8MAINTAINING DATABASE TRIGGERS CALL syntax TRIGGER maintenance tasks SHOW errors trigger DROP trigger ALTER trigger HANDLING multiple triggers for a table HANDLING mutating table issues
- 1.9IMPLEMENTING SYSTEM EVENT TRIGGERS WHAT are system event triggers? DEFINING the scope AVALAIBLE system events SYSTEM attributes
Instructor
