(Click Category to List Courses)

37 - IT-D Information Technology - Databases and Related Technologies


IT-D 137 - Oracle Database 12c: Advanced Security

Code Start Date Duration Venue Fees
IT-D 137 05 December 2020 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 02 January 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 27 February 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 27 March 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 24 April 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 22 May 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 19 June 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 14 August 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 11 September 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 09 October 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 06 November 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 137 04 December 2021 5 Days Istanbul $ 3950 Registration Form Link
DOWNLOAD PDF

 

Course Description

Oracle Advanced Security helps customers address regulatory compliance requirements by protecting sensitive data on the network, on storage media and within the database from unauthorized disclosure. Transparent Data Encryption, a major component of Oracle Advanced Security, provides the industry’s most advanced database encryption solution for protecting sensitive information without requiring changes to applications

Course Objectives

  • Introducing and configuring transparent data encryption
  • Managing the keystore and the TDE master encryption key
  • Introducing Oracle data redaction
  • Using Oracle data redaction in Oracle Enterprise Manager
  • Discussing security considerations for Oracle data redaction

 

Who Should Attend?

  • Implementation consultants
  • System administrators
  • Security administrators
  • Database administrators (DBAs)

Course Details/Schedule

Day 1

  • Introduction to Transparent Data Encryption
  • Configuring Transparent Data Encryption
  • Configuring a Software Keystore
  • Configuring a Hardware Keystore
  • Encrypting Columns in Tables
  • Encrypting Tablespaces
  • Transparent Data Encryption Data Dynamic and Data Dictionary Views
  •  Managing the Keystore
  • Managing the TDE Master Encryption Key
  • Storing Secrets Used by Oracle Database
  • Storing Oracle GoldenGate Secrets in a Keystore

Day 2

  • Security Considerations for Transparent Data Encryption
  • Compression and Data Deduplication of Encrypted Data
  • Performance and Storage Overhead of Transparent Data Encryption
  • Storage Overhead of Transparent Data Encryption
  • Modifying Your Applications for Use with Transparent Data Encryption
  • How ALTER SYSTEM and orapki Map to ADMINISTER KEY MANAGEMENT
  • Using Transparent Data Encryption with PKI Encryption
  • Using Transparent Data Encryption with Other Oracle Features
  • Configuring Transparent Data Encryption to Work in a Multidatabase Environment

Day 3

  • Introduction to Oracle Data Redaction
  • Target Use Cases for Oracle Data Redaction
  • Oracle Data Redaction Features and Capabilities
  • Full Data Redaction to Redact All Data
  • Partial Data Redaction to Redact Sections of Data
  • Regular Expressions to Redact Patterns of Data
  • Random Data Redaction to Generate Random Values
  • Comparison of Full, Partial, and Random Redaction Based on Data Types
  • Oracle Built-in Data Types Redaction Capabilities
  • ANSI Data Types Redaction Capabilities
  • User Defined Data Types or Oracle Supplied Types Redaction Capabilities
  • No Redaction for Testing Purposes

Day 4

  • Planning an Oracle Data Redaction Policy
  • General Syntax of the DBMS_REDACT.ADD_POLICY Procedure
  • Using Expressions to Define Conditions for Data Redaction Policies
  • Creating a Full Redaction Policy and Altering the Full Redaction Value
  • Creating a Partial Redaction Policy
  • Creating a Regular Expression-Based Redaction Policy
  • Creating a Random Redaction Policy
  • Creating a Policy That Uses No Redaction
  • Exemption of Users from Oracle Data Redaction Policies
  • Altering an Oracle Data Redaction Policy
  • Redacting Multiple Columns
  • Disabling and Enabling an Oracle Data Redaction Policy.
  • Dropping an Oracle Data Redaction Policy
  • Oracle Data Redaction Policy Data Dictionary Views

Day 5

  • Using Oracle Data Redaction in Oracle Enterprise Manager
  • Oracle Data Redaction Workflow
  • Management of Sensitive Column Types in Enterprise Manager
  • Managing Oracle Data Redaction Formats Using Enterprise Manager
  • Viewing Oracle Data Redaction Formats
  • Deleting a Custom Oracle Data Redaction Format 
  • Managing Oracle Data Redaction Policies Using Enterprise Manager
  • Oracle Data Redaction Use with Oracle Database Features
  • Security Considerations for Oracle Data Redaction