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

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.

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.

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