TRAINING CATEGORIES
(Click Category to List Courses)

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


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

Code Start Date Duration Venue
IT-D 137 28 October 2024 5 Days Istanbul Registration Form Link
IT-D 137 02 December 2024 5 Days Istanbul Registration Form Link
Please contact us for fees

 

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

 

ETABS and SAFE. Training 24 CCE 210 5 SAP 2000. Training 25 CCE 305 5 Quality Assurance in Pavement Construction 26 CCE 401 5 Construction Project Management 27 CCE 402 10 Construction Project Management (10 Days) 28 CCE 403 5 Construction Project Management-Intensive 29 CCE 405 5 Principles of Construction Project Management 30 CCE 406 10 Principles of Construction Project Management (10 Days) 31 CCE 410 10 Construction Project and Risk Management (10 days) 32 CCE 411 5 Project & Contract Management for Marine Construction 33 CCE 412 5 Application of GIS in Construction Management 34 CCE 415 4 Sustainable Water Management Techniques, Innovation and Solution (4 Days) 35 CCE 419 5 Construction Management of Hydraulic Projects 36 CCE 420 5 Water Project Management 37 CCE 421 10 Modern Technologies in the Supervision and Quality Control of Irrigation Projects and Dealing with Contractors (10 Days) 38 CCE 422 5 Rapid Earthquake Hazard Evaluation of Buildings 39 CCE 425 10 Practical Application of Computers in Structural Engineering (10 Days) 40 CCE 428 5 Survey & Profile Using Total Station 41 CCE 430 5 Bridge Construction and Maintenance 42 CCE 435 5 Bridge Inspection and Maintenance 43 CCE-A 410 10 إدارة المشاريع الهندسية -10 أيام
21 - TTC - Transportation and Traffic Control
22 - ADV - Architectural Design and Visualization
23 - SRM - Safety and Occupational Health
24 - CSM - Public Relations, Communication Skills & Office Management
25 - TEM - Training and Education Management
26 - CMR - Customer Relations