Home
Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions
DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance
Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers
Fusion Middleware Series
Oracle Application Server
Oracle Identity Management
Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi
Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
|
|
Writing 11g
Triggers
|
 |
When people in the database
hear the word trigger ... they think of table triggers.
Event driven code that executes when an invent happens:
Either an INSERT, UPDATE, or DELETE. That isn't even half
of the story.
Triggers are not just for tables. We get into INSTEAD OF
triggers, DDL and SYSTEM EVENT triggers. And the Oracle
System Event environment variables that make them
incredibly powerful for auditing, security, and tracing.
This 3 hour hands-on workshop is only
$100/person.
|
Here's the rest of the story
- Triggers that fire when a
named columns are modified
- Triggers that fire when
someone logs into the instance
- Triggers that fire when
someone tries to truncate or drop a table
- Triggers that fire when
on granting and revoking of privileges
- The new 11g Follows
Clause
- New 11g Compound
triggers
|
New in 11g
Compound Triggers
Follows Clause
|
|
Syllabus
|
| 5:45-6:00pm |
Introductions |
Join us for coffee
before class begins.
To attend a workshop you must register at least
one day in advance. |
| 6:00-7:30pm |
Lab
1 |
Table
Triggers
Lab 1 is instructor led and teaches the syntax for
creating STATEMENT and ROW LEVEL BEFORE and AFTER
triggers. This hands-on session focuses on best
practices and syntax for building table triggers.
In this hands-on session we build every type of
table trigger and learn to work with the ON, OF,
and REFERENCING clauses, and cascading and
mutating triggers. The important new 11g
trigger extensions compound triggers and the
follows clause are covered in depth. |
| 7:30-8:30pm |
Lab
2 |
DDL
Event Triggers
Since version 9i Oracle has provided developers
and DBAs with a full complement of triggers that
fire when DDL statements are executed. These might
include CREATE, ALTER, TRUNCATE, DROP; or they might
fire on GRANT and REVOKE; or other DDL.
These triggers can be used for purposes of
auditing and compliance, for purposes of security,
and to prevent damage to production environments.
This hands-on session covers all of these uses. |
| 8:30-9:00pm |
Instructor
Demo |
System
Event Triggers
These are among the most useful of triggers for
auditing, compliance, security, monitoring, and
tracing. This instructor led session will
demonstrate how these triggers can be used. |
|
|
Instructors |
Jack Cline is the chairman of the Puget Sound Oracle Users Group and has done Oracle contract work in the Puget Sound area for the past 11 years including engagements at Boeing, Bank of America, King County, the City of Seattle, Puget Sound Energy, and the Seattle-King Country Department of Health. He is a frequent guest lecturer at the University of Washington's Oracle Certification Program.
Dan Morgan is an Oracle Ace Director, a 10g and 11g Beta
tester for Oracle, and the instructor of the Oracle program at
the University of Washington since its inception in 1999. He
began his IT career in 1969 with an IBM 370/145, punch cards,
and Fortran IV, and though he will vigorously deny it, wrote
COBOL for a decade before moving into Oracle about when version
6 hit the market.
In addition to Dan's work at the university he is the Education
Chair of the Puget Sound Oracle Users Group, a member of UKOUG,
and a member of the British-American Chamber of Commerce in
Seattle. He is also a frequent lecturer at training events and
at conferences and has presented at Oracle OpenWorld on RAC
(2005), at Seattle OracleDay (2004-2007), at numerous government
and corporate training events including Apple Computer, Argonne
National Laboratory, Boeing Commercial Airplane Group, Dow Jones
& Company, Lawrence Livermore National Laboratory, NASA,
T-Mobile, US Navy at Pearl Harbor, and Weyerhaeuser to name but
a few and presented on Streams and Change Data Capture at UKOUG
in 2006.
Dan Morgan is the Morgan behind the "Morgan's Library"
website that contains the many demos he has created for
his University of Washington classes as well as for his frequent
lectures. He is the former publisher of MacTech Journal, has
presented Oracle technical lectures in the US, Canada, Great
Britain, and Japan. Morgan is also the author of this course.
Caleb Small is the primary instructor for the Oracle
Workforce Development program at Camosun College in Victoria BC,
and a private consultant with years of experience implementing
and teaching Oracle throughout North America. He has over 30
years experience in the IT industry in numerous business areas
including both public and private sectors.
Caleb is also active as a director of the Victoria and Puget
Sound Oracle User Groups, and has delivered numerous lectures,
presentations, live demos and articles to other groups. He
has authored and led many of the PSOUG workshops including RAC,
ASM, RMAN and Data Guard.
Caleb was one of the first people to build an 11g RAC cluster
and has been a primary consultant on RAC to publicly held
corporations including Areva T&D and Montana Dakota
Utilities (MDU).
|
|
