-
Course
- Data
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.
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 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
About the author
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.
More Courses by Agaba