• LOGIN
  • No products in the basket.

Login

Get Access to Entire Course Library of 2000+ Courses at £99 Get Now

This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which 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. In addition to that, you’ll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP).

Upon successful completion of this course, you’ll stand out from your competition while you’re chasing your dream job!

What Will I 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

Who is the target audience?

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

Course Curriculum

Introduction
Introduction 00:03:00
Install Oracle XE 00:11:00
SQL Developer Installation 00:00: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

FAQs

This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.

No prior qualifications are needed to take this course.

You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!

Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.

Don’t worry if you fail the test, you can retake it as many times as you want.

You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.

We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.

After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.

Validate your certificate

top
Select your currency
AUD Australian dollar