Training
Oracle
Oracle Database
Oracle Database Security: Detective Controls

7619 Reviews star_rate star_rate star_rate star_rate star_half

Oracle Database Security: Detective Controls

By Request

$5,000 USD

Course Code D90846GC10

Duration 5 days

Available Formats Virtual

Enter your Email to Download Full Course Details

In the Oracle Database Security: Detective Controls course, students learn how they can use Oracle Database administration auditing features to meet the compliance requirements of their organization. The current regulatory environment requires better security at the database level. Students learn how to audit the access to their databases and how to use the auditing and compliance features to monitor data access and confidentiality. The course provides suggested Oracle solutions for common problems.

Learn To:

Enumerate Oracle auditing solutions to monitor database security requirements.
Implement Oracle Audit Vault and Oracle Database Firewall.
Configure Oracle Audit Vault and Oracle Database Firewall.
Explain Oracle Compliance Framework.
Configure basic Compliance Framework rules.

Benefits To You

Students will benefit by learning about the following security features of the database: Oracle Audit Vault, Oracle Database Firewall and Oracle Compliance Framework.

Hands-on practices and available demonstrations help students learn how to use detective control features of Oracle Database 12c to audit their database access using Oracle Enterprise Manager Cloud Control or other simple tools like SQL*Plus.

Skills Gained

Enumerate Oracle auditing solutions to monitor database security requirements
Implement Oracle Audit Vault and Database Firewall
Configure Oracle Audit Vault and Database Firewall
Explain Oracle Compliance Framework
Configure basic Compliance Framework rules

Who Can Benefit

Administrator
Database Administrator
Security Specialist
Systems Administrator

Prerequisites

Suggested Prerequisite

Create and manage database users, roles, and privilege

Required Prerequisite

Introduction to Oracle Database Security Ed 1
Good understanding of SQL
Create PL/SQL procedures
Good knowledge of Oracle Database Administration

Course Details

Topics

Introduction
Using Unified Audit
Using Fine-Grained Audit
Introduction to Oracle Audit Vault and Database Firewall (AVDF)
Planning the Oracle Audit Vault and Database Firewall Implementation
Installing the Audit Vault Server
Configuring the Audit Vault Server
Configuring Oracle AVDF and Deploying the Audit Vault Agent
Networking and Oracle AVDF
Installing a Database Firewall
Configuring Oracle AVDF and Deploying Database Firewall
Using Host Monitoring
Configuring High Availability
Creating Custom Collection Plug-ins
Managing the Audit Vault Server
Managing the Database Firewalls
Overview of the Auditing and Reporting Features
Performing Administrative Tasks
Creating Audit Policies for Oracle Databases
Creating Database Firewall Policies
Oracle AVDF Reports
Managing Entitlements

Course Objectives and Schedule
Course Practices and Additional Information

Using Fine-Grained Audit

Comparison with Unified Auditing
Overview
FGA Implementation

Introduction to Oracle Audit Vault and Database Firewall (AVDF)

Oracle Audit Vault and Database Firewall Features
Oracle Audit Vault and Database Firewall Components
Oracle Audit Vault and Database Firewall Architecture
Supported Secured Targets
Integrating Oracle AVDF with Third-party Products
Oracle AVDF Administrator Tasks
Oracle AVDF Auditor Tasks

Planning the Oracle Audit Vault and Database Firewall Implementation

Evaluating Oracle AVDF Configuration Requirements
Configuring Oracle AVDF and Deploying the Audit Vault Agent
Configuring Oracle AVDF and Deploying the Database Firewall

Installing the Audit Vault Server

Requirements for Installation of Oracle AVDF
Network Interface Card Requirements
Installing an Audit Vault Server
Performing Audit Vault Server Post-Installation Tasks

Configuring the Audit Vault Server

Specifying the Server Date and Time
Setting or Changing the Audit Vault Server Network Settings
Configuring or Changing the Audit Vault Server Service
Configuring the Audit Vault Server Syslog Destinations
Defining Datafile Archiving Locations
Creating Archiving Policies
Configuring the Email Notification Service
Configuring Administrative Accounts for the Audit Vault Server

Configuring Oracle AVDF and Deploying the Audit Vault Agent

Understanding Network Requirements for AV Server and AV Agent
Registering Hosts in the Audit Vault Server
Deploying and Activating the Audit Vault Agent on Host Computers
Registering the Audit Vault Agent as a Windows Service
Creating User Accounts for Oracle AVDF
Registering Secured Targets
Configuring Audit Trails for Secured Targets
Configuring Stored Procedure Auditing

Networking and Oracle AVDF

Overview of the OSI 7-level Network Model
Overview of IPv4 Addressing and Routing
Overview of MAC Addressing
Overview of Virtual LANs (VLANs)
Overview of Spanning Tree Protocol (STP)
Oracle AVDF Deployment Models (inline, out of band, and proxy)
Best Practices for Database Policy Enforcement (DPE) and Database Activity Monitoring (DAM) Modes

Installing a Database Firewall

Requirements for Installation of a Database Firewall
Network Interface Card (NIC) Requirements
Installing a Database Firewall
Performing Database Firewall Post-Installation Tasks

Configuring Oracle AVDF and Deploying Database Firewall

Configuring Basic Settings for Database Firewall
Configuring a Database Firewall on Your Network
Associating a Database Firewall with the Audit Vault Server
Registering Secured Targets
Configuring Enforcement Points
Configuring and Using Database Interrogation
Configuring and Using Database Response Monitoring

Configuring High Availability

Overview of Oracle AVDF High Availability Architecture (resilient pairs)
Configuring a Resilient Pair of Audit Vault Servers
Configuring a Resilient Pair of Database Firewalls

Creating Custom Collection Plug-ins

Overview of Audit Collection Plug-ins
General Procedure for Writing Audit Collection Plug-ins
Setting Up Your Development Environment (downloading the SDK)
Creating Audit Collection Plug-ins
Packaging Audit Collection Plug-ins

Managing the Audit Vault Server

Starting an Archive Job
Restoring Audit Data
Monitoring Jobs

Managing the Database Firewalls

Viewing and Capturing Network Traffic in a Database Firewall
Viewing the Status and Diagnostics Report for a Database Firewall
Removing a Database Firewall from the Audit Vault Server

Overview of the Auditing and Reporting Features

Overview of Database Firewall Policies
Overview of Oracle Database Audit Policies
Overview of Reports and Report Schedules
Overview of Oracle Database Entitlement Auditing
Overview of Oracle Database Stored Procedure Auditing
Overview of Alerts and Email Notifications

Performing Administrative Tasks

Viewing a List of Audit Trails and Audit Trail Status
Viewing a List of Enforcement Points and Enforcement Point Status
Specifying a Data Retention Policy
Creating Secured Target Groups
Assigning a Secured Target to a Compliance Group
Managing User Accounts and Access
Creating Templates and Distribution Lists for Email Notifications
Monitoring Jobs

Creating Audit Policies for Oracle Databases

Overview of Audit Policies and Audit Data Collection
Overview of Oracle Database Auditing
Recommended Audit Settings
Creating Audit Polices for Oracle Database (overview)
Retrieving and Modifying Audit Settings from an Oracle Database
Creating Additional Audit Policy Settings for an Oracle Database

Creating Database Firewall Policies

Overview of Database Firewall Policies
Creating a Firewall Policy
Defining Firewall Policy Rules and Settings
Using Profiles to Customize a Firewall Policy
Publishing Firewall Policies
Deploying Firewall Policies to Secured Targets

Oracle AVDF Reports

Using the Built-in Reports
Managing Reports
Customizing Built-in Reports
Creating Custom Reports

Managing Entitlements

Overview of Entitlement Data (what is it)
Retrieving Entitlement Data from an Oracle Database (creating a snapshot)
Creating Labels for Snapshots
Assigning Labels to Snapshots
Using Entitlement Reports

Oracle AVDF Reports

Using the Built-in Reports
Managing Reports
Customizing Built-in Reports
Creating Custom Reports

Managing Entitlements

Overview of Entitlement Data (what is it?)
Retrieving Entitlement Data from an Oracle Database (creating a snapshot)
Creating Labels for Snapshots
Assigning Labels to Snapshots
Using Entitlement Reports

Read Less

1 options available

Jan 8, 2024 - Jan 12, 2024 (5 days)

Language	Time
Live Virtual
English	9:00am – 5:00pm EST
Select delivery method/location (1 options)
Live Virtual \| 9:00am – 5:00pm EST Live Virtual \| 9:00am – 5:00pm EST

Enroll: Enroll

SAVE on this course - Promo Code: UPSKILL500

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

How do I find an ExitCertified training location?

We have training locations across the United States and Canada. View a full list of classroom training locations.

Which delivery formats are available?

At ExitCertified we offer training that is Instructor-Led, Online, Virtual and Self-Paced.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

ExitCertified instructors have an average of 27 years of practical IT experience. They have also served as consultants for an average of 15 years. To stay up to date, instructors will at least spend 25 percent of their time learning new emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact customerexp@exitcertified.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How to request a W9 for ExitCertified LLC?

View our filing status and how to request a W9.

The class was very vast paced however the teacher was very good at checking in on us while giving us time to complete the labs.

ExitCertified Student

ExitCertified

The format of the class was concise. I learned new skills to use at my workplace.

Mustapha F

ExitCertified

Very interactive and in-depth course that really got me ready for the industry

ExitCertified Student

ExitCertified

the class/lecture was amazing and very easy to understand and was in detail.

Muhammad M

ExitCertified

I was very pleased with the course setup by ExitCertified and the instructor.

ExitCertified Student

ExitCertified

Oracle Database Security: Detective Controls

Overview

Schedule

FAQ

Reviews

Skills Gained

Who Can Benefit

Prerequisites

Suggested Prerequisite

Required Prerequisite

Course Details

Topics

Using Fine-Grained Audit

Introduction to Oracle Audit Vault and Database Firewall (AVDF)

Planning the Oracle Audit Vault and Database Firewall Implementation

Installing the Audit Vault Server

Configuring the Audit Vault Server

Configuring Oracle AVDF and Deploying the Audit Vault Agent

Networking and Oracle AVDF

Installing a Database Firewall

Configuring Oracle AVDF and Deploying Database Firewall

Configuring High Availability

Creating Custom Collection Plug-ins

Managing the Audit Vault Server

Managing the Database Firewalls

Overview of the Auditing and Reporting Features

Performing Administrative Tasks

Creating Audit Policies for Oracle Databases

Creating Database Firewall Policies

Oracle AVDF Reports

Managing Entitlements

Oracle AVDF Reports

Managing Entitlements

Upcoming Course Dates

Drag & Drop a File Here

When does class start/end?

Does the course schedule include a Lunchbreak?

How can someone reach me during class?

What languages are used to deliver training?

What does GTR stand for?

How do I find an ExitCertified training location?

Which delivery formats are available?

Does ExitCertified deliver group training?

What does vendor-authorized training mean?

Is the training too basic, or will you go deep into technology?

How up-to-date are your courses and support materials?

Are your instructors seasoned trainers who have deep knowledge of the training topic?

Do you provide hands-on training and exercises in an actual lab environment?

Will you customize the training for our company’s specific needs and goals?

How do I get started with certification?

Will I get access to content after I complete a course?

How to request a W9 for ExitCertified LLC?

Alert!

Modal Title

Error!

Default Title

Subscriber Dialog

Summer Savings

Prompt

Confirm

Login