Simple play icon Course
Skills

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Compound, DDL, and Event Database Triggers

by Agaba Philip

This course focuses exclusively on the Oracle instance. If you’ve been through the first course in this path, Understanding Database Architecture with Oracle, you’ll find the material in this course familiar.

Preview this course

What you'll learn

Once you’ve mastered Oracle’s architecture with Understanding Database Architecture with Oracle, this course is the natural next rung on the Oracle database ladder. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Compound, DDL, and Event Database Triggers, you'll focus exclusively on the Oracle instance. First, you'll review what it means to STARTUP or SHUTDOWN an Oracle instance. Next, you’ll use the Automatic Diagnostic Repository (ADR) to access diagnostic information. Then, you’ll learn how to configure aspects of our Oracle system by setting and changing initialization parameters. Finally, you'll learn to mine the data dictionary for useful information. When you are finished with this course, you will have the necessary skills and knowledge to prepare for the Oracle Database Program with PL/SQL Exam Number: 1Z0-149.

Table of contents

Course Overview
1min
DML Triggers
26mins
DDL Triggers
3mins
Database Event Triggers
2mins
INSTEAD OF Triggers
7mins

About the author

Agaba Philip

I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I've come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I'm currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pas... more

See more courses by Agaba Philip
Ready to upskill? Get started