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
Partitioning
Sarbanes-Oxley & HIPAA Compliance
Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Partitioning
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers
Applications Series
E-Business Suite
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
|
|
10g Audit
Vault
|
|
Oracle Audit
Vault is one part of meeting the challenges facing any
organization looking to ease the transition to governance
and compliance.
SarbOx may not be your
issue ... but internal controls, Payment Card Industry
regulations, and other factors, even current court
decisions dictate that we must be prepared to meet a
similar burden of proof with respect to our systems.
Audit Vault is brilliant
and our two day class will take you through a complete
installation, configuration, and deployment. All hands-on.
|
|
The PSOUG's .... The syllabus, below,
shows the topics covered as well as the fact that this
class is hands-on. The slide show ends long before lunch.
$900/student.
|
|
Day 1
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you register. |
| 9:00-10:30am |
Discussion 1 |
Audit
Vault Concepts and Architecture
A discussion of Audit Vault concepts and architecture and
auditing, compliance, and governance. We will
cover the non-technical topics your management
wants you to know ... FTC, SEC, international, and other
government and industry enforced rules and
regulations. |
| 10:30-11:15am |
Lab 1 |
Operating System Installation and Configuration
Working with Oracle Unbreakable Linux 4 each student will perform a hands-on
installation of the operating system on their own server. |
| 11:15-11:30am |
Lab 2 |
Operating
System Audit Vault Configuration
The Linux operating system normally requires configuration for the Oracle database. This lab includes
those standard
kernel configurations plus those configurations specific to the
installation of Audit Vault. |
| 11:30-12:00am |
Lab
3 |
Audit
Vault Server Installation
This lab is a hands-on installation of the
Audit Vault Server |
|
1:00-2:00pm
|
Lab
4 |
Enterprise
Manager DB Console, Audit Vault Console and
Repository Review
The Audit Vault Server installation installs
multiple management tools that are part of the
Enterprise Manager family. This instructor led lab
familiarizes students with the use of DB Console
and the Audit Vault Console screens for the
Auditor, Admin, Owner, and Account Manager. We
will also use SQL*Plus to explore the users and
roles created to support the vault. |
| 2:00-2:30pm |
Lab
5 |
Target
Database Installation
For this class students will use their own 10gR2
database as the target for auditing. This lab
installs the database and unlocks the accounts
that will be audited during this class. |
| 2:30-3:00pm |
Lab
6 |
Audit
Vault Agent Installation
This lab covers the creation of user accounts on
the Audit Vault server and the target database as
well as the installation of the Audit Vault agent. |
| 3:00-4:30pm |
Lab
7 |
Audit
Vault Configuration
Installing the Audit Vault Server and Agent are
the easy part. In this lab, acting as the Vault
Administrator, we configure collectors and perform
additional configuration steps so for the
collection of operating system, database, and redo
log files. |
|
|
Day 2 |
| 9:00-9:30am |
Review |
Review
This half-hour is reserved for a review of the day
1 labs and for any questions that arose from the
installation and configuration steps. |
| 9:30-12:00pm |
Discussion |
Governance
and Compliance
More and more DBAs and being asked to become part
of the business process. To take actions that
comply with government regulations, to act in a
manner that protects the business from legal
liability. You might call this session "Law
school for DBAs." |
| 1:00-3:00pm |
Lab
8 |
Reporting
The Enterprise Manager Audit Vault Console
contains a variety of built in reports designed to
support auditing requirements. This lab will
explore the prebuilt reports and how to create
additional user defined reports. |
| 3:00-4:30pm |
Lab
9 |
Hacking
and Cracking
Time to play ethical hacker and make changes to
the operating system and the database to determine
what is tracked, how, and where. This lab is ad
hoc with students encouraged to try every trick
they know. The instructor will be there to help
point the way and answer questions as they arise. |
|
|
Instructors |
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 Data Guard
course.
|
|
Victoria Whitlock has
more than 23 years experience in the Information Technology
industry. She specializes in Database Architecture,
Administration, Data Warehousing, Training, and Mentoring.
Formerly one of Oracle Corporation's top Education trainers,
Victoria excels in teaching and working with diverse groups
to master complex procedure-based processes by applying
leading edge technologies. Victoria managed a variety of
successful international data warehousing projects and
speaks regularly at industry forums such as Oracle OpenWorld:
Most recently in 2007. She is currently Enpria's Compliance
Practice Manager, responsible for both the conceptual
integrity of Enpria's IP and quality of deliverables.
Victoria has built a strong sub-specialty in the world of
government mandated compliance. Her understanding of the
technical systems which must ultimately be crafted, either
by design or modification, to deliver compliant performance
and her understanding of automated business processes grant
her a very rare perspective.
Victoria is a frequent contributor to both PCAOB and SEC
data calls. Her work is posted on their websites and is
recognized for its thoughtful, thorough, and unbiased point
of view.
Victoria also is currently serving on the AEA National
Governance committee.
|
|
