0
  • LOGIN

  • No products in the cart.

Login

Forgot Password?

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
TAKE THIS COURSE
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
The modules are easy to understand and there is help available if required. Besides great collection of exciting topics which make you come back for more.
It was a pleasure to do a course in SkillUp. The course is well organized and I could study at my own pace.
Super varied course content. From Healthcare and fitness to Therapeutic courses. What I particularly like are the course modules and the way they are arranged gradually. With my nutritional background, I have come to know and love completely different perspectives.
Recommendable! A unique experience, the courses have every detail covered. Enjoyed the course through and through.
The price is reasonable, and you know upfront of your costs. I would recommend Skill Up to learners who want to excel their skills or looking for self-development.
The modules are easy to understand and there is help available if required. Besides great collection of exciting topics which make you come back for more.
Previous
Next

Related Courses

Setup Menus in Admin Panel