Oracle Database Security: Preventive Controls Ed 1

Oracle Database Security: Preventive Controls Ed 1 Certification Training Course Overview

In the Oracle Database Security: Preventive Controls course, student figure out how they can utilize Oracle Database Security items and technologies to meet the security, protection and consistence prerequisites of their association. The current administrative condition of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better security at the database level. students figure out how to secure the entrance to their databases and how to utilize the Oracle Database Security items and innovations that upgrade information access and privacy. The course gives recommended Oracle answers for normal issues.

Learn To

  • Choose Oracle Database Security products and technologies to meet security requirements.
  • Secure the database access by database or enterprise users with basic or strong authentication such as SSL, Kerberos and Radius.
  • Protect against database bypass by using Transparent Database Encryption.
  • Use Oracle Wallets and Oracle Key Vault to manage encryption keys.
  • Discover sensitive columns such as Credit Card Numbers by using Application Data Modeling.
  • Minimize sensitive data proliferation to test/dev environments by using Data Masking.
  • Minimize storage costs in test/dev environments by using Data Subsetting.
  • Reduce sensitive data exposure in applications by using Data Redaction.
  • Understand and use Oracle Database Vault.


  • Database Administrators
  • Network Administrator
  • Security Administrators
  • Support Engineer
  • System Analysts

Oracle Database Security: Preventive Controls Ed 1 (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 3100
15 - 19 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3550
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Course Objectives
  • Related courses and where this fits
  • Course Schedule and Appendices
Module 2: Using Basic and Strong User Authentication
  • Basic Authentication
  • Strong Authentication
  • Database Link Passwords Protection
  • Security of Roles
Module 3: Configuring Global User Authentication
  • About Enterprise User Management (EUS)
  • EUS and LDAP Integration
Module 4: Using Proxy Authentication
  • Security Challenges of Three-Tier Computing
  • Proxy Authentication Solutions
Module 5: Encryption Concepts and Solutions
  • Concepts
  • Solutions
  • Oracle Solutions
Module 7: Using Transparent Data Encryption (TDE)
  • Overview
  • The Master Keys and the Keystore
  • Hardware Keystore
  • Encryption
Module 8: Database Storage Security
  • RMAN and OSB Backups
  • RMAN Encryption Modes
  • Data Pump Export and Import of Encrypted Data
Module 9: Introduction to Oracle Key Vault
  • What is Oracle Key Vault?
  • Using Oracle Key Vault
Module 11: Using Oracle Key Vault
  • Reviewing or refreshing prerequisite knowledge
  • Contrasting Oracle Wallets and OKV Virtual Wallets
Module 12: Administering Oracle Key Vault
  • Roles in detail
  • Best practice tips for Oracle Key Vault
Module 13: Automated Sensitive Data Discovery
  • Overview
  • Application Data Modeling
  • Managing Application Data Models
Module 15: Masking Sensitive Data in Non-Production Environments
  • Exploring Data Masking Format Library
  • Data Masking Transformations
Module 16: Subsetting Data
  • Exploring Data Subsetting definitions
Module 17: Managing Data Masking and Subsetting
  • Administering Data Masking and Subsetting
  • Heterogeneous masking and subsetting
  • Best Practices
Module 18: Oracle Advanced Security - Data Redaction
  • Need to redact or dynamically mask data
  • Implementing Data Redaction
  • Data Redaction usage guidelines
Module 20: Oracle Database Vault Overview
  • Understand Database Vault Controls
  • What is a Realm? A Rule Set? A Command Rule? A Secure Application Role?
  • What are Factors and Identities? Component Relationships and Evaluation?
  • Database Vault Effects and Example
  • Software Overview: API, Views, and Integration with Other Oracle Products
Module 21: Configuring Database Vault
  • Configuring Database Vault
  • Database Vault Roles and Schema
  • What to Expect After You Enable Database Vault
  • Securing Data in Multitenant Environments
  • Configuring Database Vault Users in Cloud Control 12c
Module 22: Analyzing Privileges
  • Privilege Analysis Overview and Features
  • How Does it Work?
  • What are The Types of Analysis, Tools, and Prerequisites?
  • Managing Privilege Analysis Policies
  • Use Cases
Download Course Contents

Request More Information

Course Prerequisites
  • Create PL/SQL procedures
  • Create and manage tables and tablespaces
  • Create and manage users, roles, and privileges
  • Oracle Database 12c: Administration Workshop Ed 2
  • Introduction to Oracle Database Security Ed 1
  • Familarity with Oracle Enterprise Manager Cloud Control
  • Familarity with SQL*Plus, SQL*Developer
  • Use Flashback Data Archive and Create PL/SQL procedures
  • Use Oracle Data Pump export and import and Perform RMAN back

This course talks about the accompanying security highlights of the database: validation, information get to control including user approvals by utilizing benefits and parts, information classification including Data Redaction, Oracle Data Masking and Subsetting, Transparent Sensitive Data Protection, encryption at the segment, tablespace and record levels by utilizing Transparent Data Encryption. This course talks about the utilization of the Oracle Key Vault to halfway oversee keys over the undertaking. Prophet Database Vault is utilized to authorize Separation of Duties at the DBA level.

Hands-on rehearses and accessible showings enable student to figure out how to utilize the greater part of the highlights of Oracle Database 12c to secure their server farm, by utilizing Oracle Enterprise Manager Cloud Control or other basic apparatuses, for example, SQL*Plus.

Upon Completion of this Course, you will accomplish following:

  • Configure and use Transparent Data Encryption
  • Understand and use Oracle Key Vault
  • Understand Oracle Data Redaction
  • Understand and use Oracle Data Masking and Subsetting
  • Understand security risks and identify appropriate Oracle solutions
  • Configure general authentication and authorization
  • Understand and implement Global Users
  • Set up and maintain a simple wallet
  • Install and use Oracle Database Vault
  • Configure and use Transparent Sensitive Data Protection

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database Security: Preventive Controls Ed 1 Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.