Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

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

via Pluralsight

Overview

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.

Syllabus

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

Taught by

Philip Agaba

Reviews

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.