TRENDS is authorized to promote and deliver Oracle courses in partnership with TechEdge Solutions. EZY Corporation logo and Oracle logo are registered trademarks of EZY Corporation and Oracle respectively. All rights reserved.

Oracle Database Security: Preventive Controls

Schedule

Start End Duration Location Details

Course Details

Oracle Database Security: Preventive Controls

Course code: OBSPC1

Duration: 5 Days

Prerequisite:

Suggested Prerequisite

  • 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

Required Prerequisite

  • 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

Course Description:

In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.

The current regulatory environment of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better security at the database level. Students learn how to secure the access to their 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.

Course Objectives:

•    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

Intended Audience:

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

Course Outlines:

  • Introduction
  • Using Basic and Strong User Authentication
  • Configuring Global User Authentication
  • Using Proxy Authentication
  • Encryption Concepts and Solutions
  • Using Built-In Encryption in Applications
  • Using Transparent Data Encryption (TDE)
  • Database Storage Security
  • Introduction to Oracle Key Vault
  • Installing Oracle Key Vault
  • Using Oracle Key Vault
  • Administering Oracle Key Vault
  • Automated Sensitive Data Discovery
  • Oracle Data Masking and Subsetting overview
  • Masking Sensitive Data in Non-Production Environments
  • Subsetting Data
  • Managing Data Masking and Subsetting
  • Oracle Advanced Security - Data Redaction
  • Oracle Transparent Sensitive Data Protection (TSDP)
  • Oracle Database Vault Overview
  • Configuring Database Vault
  • Analyzing Privileges