- Course
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.
Intermediate
- Course
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Compound, DDL, and Event Database Triggers
Intermediate
Table of contents
-
Course and Module Introduction | 2m 4s
-
DML Triggers | 2m 55s
-
Learning the Syntax | 1m
-
Your First Trigger | 2m 28s
-
If Inserting, If Updating | 1m 29s
-
If Deleting | 58s
-
Targeting Specific Columns | 2m 25s
-
Applying the When Clause | 2m 30s
-
Changing Input | 1m 2s
-
Setting the Commission | 1m 49s
-
Blocking an Operation | 1m 1s
-
Order of Execution | 2m 29s
-
Mutating Table Errors | 1m 41s
-
Compound Triggers | 2m 26s
-
Module Summary | 21s
I'm a Linux aficionado. I deploy it to clients looking to build new solutions or migrate existing services. I teach it to students about to enter the job market, and I recommend it to anyone looking to get their start in IT.