• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

Introduction
Introduction FREE 00:03:00
Preparing Your Environment
Install Oracle XE 00:11:00
SQL Developer Installation 00:20:00
Workstation Setup 00:12:00
Database Program Units
Introducing the Database Program Unit 00:19:00
Working with Stored Procedures and Functions
Creating Stored Procedures and Functions 00:19:00
Understanding the Parameter Specification 00:23:00
Executing Procedures and Functions 00:26:00
Calling Functions from within SQL 00:13:00
Handling Compilation Errors 00:08:00
Maintaining Stored Procedures and Functions
Recompiling and Dropping Programs 00:16:00
Data Dictionary Storage 00:25:00
Managing Dependencies 00:13:00
Tracking Dependencies 00:08:00
Using the Dependency Tracking Utility 00:09:00
Creating and Maintaining Packages
What Is a Package? 00:10:00
Creating a Package 00:19:00
Package Definition Information 00:08:00
Advanced Programming Techniques 00:06:00
Using Persistent Global Objects 00:04:00
Including Initialization Logic 00:15:00
Object Oriented Support within Packages 00:14:00
Package Maintenance 00:18:00
Advanced Cursor Techniques
Learning to Use Cursor Variables 00:24:00
Advanced Cursor Techniques Weak Cursor Definitions 00:16:00
REFCURSOR Cursor Definition 00:05:00
Using Cursor Expression 00:14:00
Using System Supplied Packages
Using the DBMS OUTPUT() Package 00:12:00
Using the UTL FILE() Package 00:30:00
Creating Database Triggers
Understanding the Database Trigger 00:23:00
Statement-Level Triggers 00:23:00
Row-Level Triggers 00:12:00
Row Level Trigger Example 1 00:11:00
Row Level Trigger Example 2 00:07:00
Row Level Trigger Example 3 00:08:00
Working with the INSTEAD OF Trigger 00:11:00
Using Triggers within an Application 00:09:00
Trigger Maintenance
Using the CALL Statement 00:09:00
Trigger Maintenance Tasks 00:12:00
Work with Multiple Triggers for a Single Table 00:11:00
Handling Mutating Table Issues 00:22:00
Using the Compound Trigger 00:06:00
Working with System Event Triggers
What Is a System Event Trigger 00:05:00
Defining Scope 00:04:00
Identifying Available System Events 00:12:00
Conclusion
Conclusion 00:02:00
Course Certification
Order your Certificate 00:00:00
Assessment

Oracle 11g PL/SQL Intermediate

4.7( 9 REVIEWS )
287 STUDENTS
$ 249.00
Oracle 11g PL/SQL Intermediate

Description

The objective of this Oracle 11g PL/SQL Intermediate course is to provide an introduction to develop database server-side PL/SQL program units within an Oracle database. This Oracle 11g course will prepare students for the Oracle certification exams.

  • Learning outcome
  • Better understanding of the Language Features.
  • Understand the structure of a Program Block and using Nested Program Block.
  • Creating The Different Types Of Trigger.
  • Applying Triggers, System Event Triggers Within An Application.
  • Maintaining The Database Triggers.
  • Creating And Maintaining Packages.
  • The Cursor & Advanced Cursor Techniques.
  • Stored Procedures & Functions and more.

Requirements

  • Learners of all backgrounds and qualifications can enroll in this course. Being Familiar with database and programming principles will help learners quest.
  • Why should I take this course?
  • 10+ hours of high-quality e-learning content.
  • Course completion certificate.
  • To excel as an Application Developer, Designer or Database Administrator.
  • Code in PL/SQL which further help to boost your career.
  • This course mostly includes practical examples with explanations which makes it more valuable.

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel