Oracle 12c: Security Administration

Live Online & Classroom Enterprise Training

Location: Bangalore, India | Dubai, UAE

Industry Experienced Instructor  |  Remote Labs  |  Lab Access Post Training

Need help finding the right training?

Course Details

In this course, you will learn about security and maintenance concerns in an Oracle database with an introductory focus on Oracle SQL and PL/SQL for newer IT employees.

Course Prerequisites

  • Basic knowledge of SQL

Course Agenda

1. SQL and PL/SQL

  • Basic SQL Syntax
  • SQL Functions
  • Advanced SQL Queries
  • PL/SQL Program Structure
  • Accessing the Database

2. Create an Oracle Database

  • Describe Oracle Database Architecture
  • Understand the Instance Architecture
  • Use the Management Framework and the Database Creation Assistant

3. Controlling the Database

  • Start and Stop the Agent and the Listener
  • Startup and Shutdown the Database

4. Administering Users

  • Create and Manage Database User Accounts, and Manage Roles
  • Grant and Revoke Privileges
  • Control Resource Usage by Users

5. Managing Schema Objects

  • Create and Modify Tables, Indexes, and Views
  • Define Constraints
  • View the Attributes and the Contents of a Table

6. Oracle Database Security

  • Apply the Principal of Least Privilege
  • Manage Default User Accounts
  • Implement Standard Password Security Features
  • Audit database activity

7. Proactive Maintenance: Objectives

  • Set Warning and Critical Alert Thresholds
  • Collect and Use Baseline Metrics
  • Use Tuning/Diagnostic Advisors/ADDM/ADR

8. Recovery Manager Configuration

  • Parameters Affecting RMAN
  • Use of a Flashback Recovery Area
  • The CONFIGURE Command
  • Persistent Settings
  • NOCATALOG / CATALOG Mode
  • Channel Allocation
  • Controlfile Autobackup
  • Retention Policies

9. Recovery Manager Operations

  • Using the BACKUP Command
  • Creating Backup Sets / Image Copies
  • Compressed Backups
  • Incremental Backups
  • Block Change Tracking
  • RMAN Backup Monitoring
  • REPORT and LIST Commands

10. Non-Critical Loss Recovery

  • Password and Network Files
  • Read-Only Tablespaces
  • Temporary Tablespaces
  • Index Tablespaces
  • Redo Log Members / Control Files

11. Database Recovery

  • Complete Recovery
  • Incomplete Recovery

12. Flashback Database

  • When in Use
  • Configuration and Use
  • Monitoring Flashback Database
  • Flash Recovery Area Maintenance
  • Flash Recovery Area Monitoring

13. User Error Recovery

  • The New Recycle Bin
  • Querying Dropped Tables
  • Flashback Versions Table
  • Flashback Transaction Query

14. Automatic Database Management

  • Management and Advisory Framework
  • Automatic Statistics Collection
  • The Automated Workload Repository
  • Database Advisors
  • Automatic Statistics Collection

15. Virtual Private Database

  • Row Level Control
  • Column Level Control

16. Oracle Auditing

  • Full Security Monitoring