Oracle Database 12c: Security

Duration : 5 Days

What you will learn

This Oracle Database 12c: Security training teaches you how you can use Oracle Database features to meet the security, privacy and compliance requirements of your organization. You'll get the chance to interact with expert Oracle University instructors through a combination of instruction and hands-on exercises that reinforce new concepts.

Learn To:

Understand Oracle security solutions and how they can help address your security requirements.

Configure strong authentication for database users using PKI and Kerberos.

Control data access using virtual private database and Oracle Label Security.

Analyze application privileges and reduce the attack surface using Oracle Database Vault Privilege Analysis.

Reduce risk of data exposure using Oracle Advanced Security Data Redaction, Transparent Data Encryption and Oracle Data Masking and Subsetting.

Audit activity inside the database using policy and condition based unified auditing.

Configure network encryption to protect information in transit.

Audit activity inside the database using policy and condition based unified auditing.

Protect against application bypass using Oracle Database Vault Realms.

Benefits to You

The current regulatory environment of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others requires better security at the database level. By investing in this course, you'll learn how to secure access to your databases and use database features that enhance data access and confidentiality. This course provides suggested Oracle solutions for common problems.

Deep Dive into Security Features

Expert Oracle University instructors discuss the following security features of the database: authentication, data access control including user authorizations using privileges and roles, Privilege Analysis, Virtual Private Database, Oracle Label Security as well as data confidentiality. This includes Data Redaction, Oracle Data Masking and Subsetting, Transparent Sensitive Data Protection and encryption at the column, tablespace and file levels using Transparent Data Encryption. 


Throughout this course, you'll also get a chance to discuss auditing using different features, including unified auditing and fine-grained auditing. You'll deep dive into some of the Oracle Network security topics, like securing the listener and restricting connections by IP address.

Gain Hands-On Experience

Hands-on practices and available demonstrations help you learn how to use most of the features of Oracle Database 12c to secure your data center. Develop an understanding of how to use Oracle Enterprise Manager Cloud Control and other tools like SQL*Plus.


Database Administrators

Network Administrator

Security Administrators

Security Compliance Auditors

Support Engineer System Analysts

Related Training

Required Prerequisites

Good knowledge of Oracle Database

Suggested Prerequisites 

Administer listeners

Create and manage users, roles, and privileges

Perform RMAN backup and recovery

Use Oracle Data Pump export and import

Course Objectives

Analyze any security risks of their organization

Find appropriate Oracle solutions to meet the security, privacy and compliance requirements of their organization

Find solutions to secure database access through the network 

Configure appropriate authentication for the database or enterprise users in the organization

Control data access and integrity in their organization using the appropriate feature or option or product like privileges or Oracle Label Security

Ensure data confidentiality using an encryption solution like Transparent Data Encryption, or Data Redaction or Oracle Data Masking and Subsetting

Audit user actions using any of the auditing features like unified auditing 

Course Outline :

Popular Courses

Related Courses


Thank you EZY Intellect and Trainer for your support to become an Oracle Certified Professional

thumb Mr. Tint Aung Shwe
Assistant Manager (IT Department)-AYA Bank,August 29, 2017

This training helped me identify clear and do-able next steps toward my goal. Thank you EZY Intellect and Mr.Kushantha ( EC-Council Certified Trainer) for very valuable training.

thumb Mr. Kyaw Htet
CEH V10,21,22,23,29,30 Sep 2018