Course Overview
This Oracle Database 11g R2 PL/SQL Complete course is designed to provide students with an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure, and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle database.
Requirements
- DBOR-917 ORACLE DATABASE 11G R2: SQL FUNDAMENTALS – COMPLETE LIBRARY
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
- Business users and non-technical senior end users
Curriculum
- 1 Section
- 15 Lessons
- 5 Days
Expand all sectionsCollapse all sections
- Topics15
- 1.1CHOOSING A SQL & PL/SQL INTERFACE USING sql developer USING sql*plus USING application express USING JDEVELOPER studio
- 1.2LANGUAGE FEATURES UNDERSTANDING pl/sql STRUCTURE of a pl/sql program BLOCK*using pl/sql from sql*plus
- 1.3DECLARE CLAUSE ABOUT the declare clause DECLARE simple types DECLARE complex types TYPE…table TYPE…record
- 1.4BEGIN CLAUSE ABOUT the begin clause PERFORMING data manipulation LOGIC control & branching LOOP IF-THEN-ELSE CASE
- 1.5EXCEPTION CLAUSE ABOUT the exception clause ISOLATING the specific exception PRAGMA exception_unit SQL%ROWCOUNT & select…into
- 1.6EXPLICIT CURSORS ABOUT explicit cursors ADVANCED cursor techniques
- 1.7ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS INTRODUCING 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.8CREATING STORED PROGRAMS & FUNCTIONS ABOUT stored procedures & functions CREATING procedures & functions EXECUTING procedures & functions
- 1.9MAINTAINING STORED PROCEDURES & FUNCTIONS RECOMPILING & dropping programs DATA dictionary storage MANAGING dependencies
- 1.10CREATING 7 MAINTAINING PACKAGES ABOUT packages CREATING packages ADVANCED programming techniques MAINTAINING packages
- 1.11ADVANCED CURSOR TECHNIQUES USING cursor variables USING cursor expressions
- 1.12USING SYSTEM-SUPPLIED PACAKGES DBMS_OUTPUT() UTL_FILE()
- 1.13CREATING DATABASE TRIGGERS ABOUT database triggers STATEMENT-level triggers ROW-level triggers EXAMPLES of triggers EMPLOYING triggers within an application
- 1.14MAINTAINING 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.15IMPLEMENTING SYSTEM EVENT TRIGGERS WHAT are system event triggers? DEFINING the scope AVALAIBLE system events SYSTEM event attributes
Instructor
