Cworacle 11g Plsql Fundamentals Ii

  1. Home
  2. Oracle-certification
  3. Cworacle 11g Plsql Fundamentals Ii

Tags: Oracle Certification , Pl/SQL

An introduction to the PL/SQL database programming language

Last updated 2022-01-10 | 4.5

- Prepare your environment
- Introducing Database Program Units
- Creating and Maintaining Stored Procedures & Functions

What you'll learn

Prepare your environment
Introducing Database Program Units
Creating and Maintaining Stored Procedures & Functions
Creating and Maintaining Packages
Advanced Cursor Techniques
Using System-Supplied Packages
Creating and Maintaining Database Triggers
Implementing System Event Triggers

* Requirements

* Familiarity with database and programming principles

Description

The objective of this Oracle 11g training course is to provide an introduction to develop database server-side PL/SQL program units within an Oracle database. The areas covered include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Who this course is for:

  • Application designers and developers
  • Database administrators
  • Business users and non-technical senior end users

Course content

12 sections • 46 lectures

Introduction 1 lectures

Introduction Preview 02:40

The instructor has provided additional resources and example files for you to use. If you would like to access these, please download the attached .zip file, which contains the files shown in this course.

Preparing Your Environment 3 lectures

Install Oracle XE Preview 10:59

SQL Developer Installation Preview 19:47

Workstation Setup Preview 12:14

Database Program Units 1 lectures

Introducing the Database Program Unit Preview 19:05

Working with Stored Procedures and Functions 5 lectures

Creating Stored Procedures and Functions Preview 18:44

Understanding the Parameter Specification Preview 23:04

Executing Procedures and Functions Preview 26:18

Calling Functions from within SQL Preview 13:12

Handling Compilation Errors Preview 08:26

Maintaining Stored Procedures and Functions 5 lectures

Recompiling and Dropping Programs Preview 16:06

Data Dictionary Storage Preview 24:54

Managing Dependencies Preview 12:59

Tracking Dependencies Preview 08:32

Using the Dependency Tracking Utility Preview 09:32

Creating and Maintaining Packages 8 lectures

What Is a Package? Preview 10:02

Creating a Package Preview 19:10

Package Definition Information Preview 07:59

Advanced Programming Techniques Preview 06:13

Using Persistent Global Objects Preview 03:44

Including Initialization Logic Preview 15:24

Object Oriented Support within Packages Preview 13:51

Package Maintenance Preview 17:54

Advanced Cursor Techniques 4 lectures

Learning to Use Cursor Variables Preview 23:38

Weak Cursor Definitions Preview 16:17

REFCURSOR Cursor Definition Preview 05:13

Using Cursor Expression Preview 13:43

Using System Supplied Packages 2 lectures

Using the DBMS OUTPUT() Package Preview 11:38

Using the UTL FILE() Package Preview 29:36

Creating Database Triggers 8 lectures

Understanding the Database Trigger Preview 23:18

Statement-Level Triggers Preview 22:42

Row-Level Triggers Preview 12:11

Row Level Trigger Example 1 Preview 11:15

Row Level Trigger Example 2 Preview 07:31

Row Level Trigger Example 3 Preview 07:42

Working with the INSTEAD OF Trigger Preview 11:00

Using Triggers within an Application Preview 08:54

Trigger Maintenance 5 lectures

Using the CALL Statement Preview 09:08

Trigger Maintenance Tasks Preview 12:22

Work with Multiple Triggers for a Single Table Preview 10:54

Handling Mutating Table Issues Preview 22:16

Using the Compound Trigger Preview 05:41

Working with System Event Triggers 3 lectures

What Is a System Event Trigger Preview 05:25

Defining Scope Preview 03:43

Identifying Available System Events Preview 12:19

Conclusion 1 lectures

Conclusion Preview 01:31