Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle Security - Preventive Controls

( Duration: 5 Days )

In Oracle Security - Preventive Controls training course, you will learn to secure the access to your databases and how to use the Oracle Database Security products and technologies that enhance data access and confidentiality. The course provides suggested Oracle solutions for common problems.

This course discusses the following security features of the database: authentication, data access control including user authorizations by using privileges and roles, data confidentiality including Data Redaction, Oracle Data Masking and Subsetting, Transparent Sensitive Data Protection, encryption at the column, tablespace and file levels by using Transparent Data Encryption. This course discusses the use of the Oracle Key Vault to centrally manage keys across the enterprise.

By attending Oracle Security - Preventive Controls workshop, delegates will learn to:

  • 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

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

The Oracle Security - Preventive Controls class is ideal for:

  • Administrators
  • Database Administrators
  • Network Administrators
  • Systems Administrators

COURSE AGENDA

1

Introduction

2

Using Basic and Strong User Authentication

  • Basic Authentication
  • Strong Authentication
  • Database Link Passwords Protection
  • Security of Roles
3

Configuring Global User Authentication

  • About Enterprise User Management (EUS)
  • EUS and LDAP Integration
4

Using Proxy Authentication

  • Security Challenges of Three-Tier Computing
  • Proxy Authentication Solutions
5

Encryption Concepts and Solutions

  • Concepts
  • Solutions
  • Oracle Solutions
6

Using Built-In Encryption in Applications

  • Usage
7

Using Transparent Data Encryption (TDE)

  • Overview
  • The Master Keys and the Keystore
  • Hardware Keystore
  • Encryption
8

Database Storage Security

  • RMAN and OSB Backups
  • RMAN Encryption Modes
  • Data Pump Export and Import of Encrypted Data
9

Introduction to Oracle Key Vault

  • What is Oracle Key Vault?
  • Using Oracle Key Vault
10

Installing Oracle Key Vault

  • Installation
  • Endpoints
11

Using Oracle Key Vault

  • Reviewing or refreshing prerequisite knowledge
  • Contrasting Oracle Wallets and OKV Virtual Wallets
12

Administering Oracle Key Vault

  • Roles in detail
  • Best practice tips for Oracle Key Vault
13

Automated Sensitive Data Discovery

  • Overview
  • Application Data Modeling
  • Managing Application Data Models
14

Oracle Data Masking and Subsetting overview

  • Overview
15

Masking Sensitive Data in Non-Production Environments

  • Exploring Data Masking Format Library
  • Data Masking Transformations
16

Subsetting Data

  • Exploring Data Subsetting definitions
17

Managing Data Masking and Subsetting

  • Administering Data Masking and Subsetting
  • Heterogeneous masking and subsetting
  • Best Practices
18

Oracle Advanced Security - Data Redaction

  • Need to redact or dynamically mask data
  • Implementing Data Redaction
  • Data Redaction usage guidelines
19

Oracle Transparent Sensitive Data Protection (TSDP)

  • TSDP Implementation
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
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
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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X