Oracle 12c database security training and certification in washington DC
George Mason University, Volgenau School of Engineering

TAIT 0431: Oracle 12c Database Security


George Mason University partners with Oracle in the Oracle University program. Official Oracle curriculum is utilized in our Oracle 11g Database Administration program. Our instructors are Oracle Certified Professionals with real-world database administration experience. Students receive a 25% discount coupon on certification examinations as an added benefit of George Mason's membership with Oracle University. Effective 2010, books shipped by Oracle Corporation are in electronic format.

Overview

This hands-on course teaches you to use Oracle Database features to meet the security, privacy and compliance requirements of your 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. 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. You will 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.
Audience and Prerequisites

This course is designed for

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

Course Outline Detail

Understanding Security Requirements

  • Fundamental Data Security Requirements
  • Security Risks
  • Exploits
  • Techniques to Enforce Security

Choosing Security Solutions

  • Network Access Control
  • Database Access Control
  • Data Access Control
  • Data Confidentiality
  • Data Integrity
  • Audit
  • Compliance

Implementing Basic Database Security

  • Database Security Checklist
  • Reducing Administrative Effort
  • Principle of Least Privilege
  • Objects Protection

Securing Data on the Network

  • Network Access Control
  • Listener Security
  • Listener Usage Control

Using Basic and Strong User Authentication

  • Basic Authentication
  • Strong Authentication
  • Database Link Passwords Protection

Configuring Global User Authentication

  • About Enterprise User Management (EUS)
  • EUS and Oracle Internet Directory Integration

Using Proxy Authentication

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

Using Privileges and Roles

  • Separation of Duties
  • Roles Management
  • Managing Security for Definer's Rights and Invoker's Rights
  • Managing RMAN Virtual Private Catalogs

Using Privilege Analysis

  • Privilege Analysis Flow
  • Privilege Analysis Implementation

Using Application Contexts

  • Description of Application Context
  • Application Context Implementation

Implementing Virtual Private Database

  • Fine-Grained Access Control and VPD
  • FGAC Policies Management
  • VPD Policies Management

Implementing Oracle Label Security

  • Access Control Overview
  • Oracle Label Security Registration
  • Oracle Label Security Policies Management

Redacting Data

  • Redacting Data
  • Masking Policies Implementation

Using Oracle Data Masking and Subsetting

  • Overview
  • Data Masking Definition Implementation
  • Data Masking Process
  • Data Subsetting Process

Using Transparent Sensitive Data Protection

  • TDPS Implementation

Encryption Concepts and Solutions

  • Concepts
  • Solutions
  • Oracle Solutions

Encrypting with DBMS_CRYPTO Package

  • Usage

Using Transparent Data Encryption

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

Database Storage Security

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

Using Unified Audit

  • Auditing Overview
  • Unified Audit Management
  • Specific Audit Situations

Using Fine-Grained Audit

  • Comparison with Unified Auditing
  • Overview
  • FGA Implementation
Registration

Click here to download the registration form (fax or mail)

Schedule

Please call for our upcoming class schedule

Tuition
$2,100
CEUs
4 CEUs
40 Hours
Onsite Opportunity

Enhance your organization's competitive edge!

George Mason University's TechAdvance Program can tailor programs to meet your organization's needs. Companies or agencies interested in bringing this program on site should contact TechAdvance at 703-993-1551.

Contact Info.
Online contact form
Address:

  George Mason University
TechAdvance
Volgenau School of Engineering
  3351 Fairfax Drive, Suite 448
  Arlington, VA 22201

Telephone: 703-993-1551
Email: advance@gmu.edu
Volgenau School of Engineering George Mason University