• 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 )
63 STUDENTS
Duration: 10.12 Hours
PRIVATE
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

Select your currency
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only$68.11 / year

    ADD OFFER TO CART

    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon