Virtual Instructor-Led Training

Onsite Training

Oracle 12c: Security Administration

AI & Data

Oracle Database

Oracle

<ul><li>Basic SQL Syntax</li><li>SQL Functions</li><li>Advanced SQL Queries</li><li>PL/SQL Program Structure</li><li>Accessing the Database</li></ul>

SQL and PL/SQL

<ul><li>Describe Oracle Database Architecture</li><li>Understand the Instance Architecture</li><li>Use the Management Framework and the Database Creation Assistant</li></ul>

Create an Oracle Database

<ul><li>Start and Stop the Agent and the Listener</li><li>Startup and Shutdown the Database</li></ul>

Controlling the Database

<ul><li>Create and Manage Database User Accounts, and Manage Roles</li><li>Grant and Revoke Privileges</li><li>Control Resource Usage by Users</li></ul>

Administering Users

<ul><li>Create and Modify Tables, Indexes, and Views</li><li>Define Constraints</li><li>View the Attributes and the Contents of a Table</li></ul>

Managing Schema Objects

<ul><li>Apply the Principal of Least Privilege</li><li>Manage Default User Accounts</li><li>Implement Standard Password Security Features</li><li>Audit database activity</li></ul>

Oracle Database Security

<ul><li>Set Warning and Critical Alert Thresholds</li><li>Collect and Use Baseline Metrics</li><li>Use Tuning/Diagnostic Advisors/ADDM/ADR</li></ul>

Proactive Maintenance: Objectives

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

Recovery Manager Configuration

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

Recovery Manager Operations

<ul><li>Password and Network Files</li><li>Read-Only Tablespaces</li><li>Temporary Tablespaces</li><li>Index Tablespaces</li><li>Redo Log Members / Control Files</li></ul>

Non-Critical Loss Recovery

<ul><li>Complete Recovery</li><li>Incomplete Recovery</li></ul>

Database Recovery

<ul><li>When in Use</li><li>Configuration and Use</li><li>Monitoring Flashback Database</li><li>Flash Recovery Area Maintenance</li><li>Flash Recovery Area Monitoring</li></ul>

Flashback Database

<ul><li>The New Recycle Bin</li><li>Querying Dropped Tables</li><li>Flashback Versions Table</li><li>Flashback Transaction Query</li></ul>

User Error Recovery

<ul><li>Management and Advisory Framework</li><li>Automatic Statistics Collection</li><li>The Automated Workload Repository</li><li>Database Advisors</li><li>Automatic Statistics Collection</li></ul>

Automatic Database Management

<ul><li>Row Level Control</li><li>Column Level Control</li></ul>

Virtual Private Database

<ul><li>Full Security Monitoring</li></ul>

Oracle Auditing

<ul><li>Lab 1: Multiple SQL Labs</li><li>Lab 2: Multiple PL/SQL Labs</li><li>Lab 3: Architecture / Advanced Memory Mgt.</li><li>Lab 4: Starting And Stopping The Database</li><li>Lab 5: Using the Database Console (EM)</li><li>Lab 6: Tables, Indexes and Constraints</li><li>Lab 7: Creating Other Database Objects</li><li>Lab 8: Users and Security</li><li>Lab 9: Performance Metrics and Monitoring</li><li>Lab 10: Archivelog Setup</li><li>Lab 11: Recovery Manager Configuration</li><li>Lab 12: Recovery Manager Backups</li><li>Lab 13: Automated Management Tools</li></ul>

Labs

IBM DataBase

courseBanner

Course Banner

courseOverview

Course Overview section

courseAnnouncement

Additional information.

courseDetails

What you will learn

targetAudience

Who should attend

courseOutline

Course Outline

courseFAQ

Coursepromobanner

Course Promobanner Section

courseRelatedTargets

Course Related Targets

courseTicker

Course Ticker

preRequisites

Prerequisites

courseLocations

Find More Locations by NetCom Learning For This Training

For Your convenience we are offering This course at more locations. Expand your training options and accelerate your learning journey with NetCom.

Learn to create & administer user accounts, backup & recover the database and monitor, troubleshoot & maintain the database.

Oracle 12c Security Administration

Microsoft

AI CERTs™

Google Cloud

Cisco

Amazon Web Services

CompTIA

EC-Council

ISC2

ITIL

Autodesk

Cloud

Security

Networking

App Development

Architecture & Design

Business Applications

Business Process

Business & Leadership

e-Learning

Trainings

Managed Learning Services

NetCom365

Learning Passport

EdAssist

Talents for Hire

NetCom Learning Academy

AI Summer Skill Fest 2025

Financial Services

Healthcare

Federal Government

State & Local Government

Technology

Complimentary AI+ Foundation™ Training

Free AI Training Consultation

AI Certs Training Bundles

CompTIA Continuing Education (CE)

CompTIA Exam Prep e-Learning Bundles

Microsoft ECIF Program

Microsoft QuickStart Program

Microsoft Partner Training

Microsoft AI Bootcamp for Educators

Microsoft Applied Skills

AWS Skill Builder

AWS Blended Learning

AWS Learning Needs Analysis (LNA)

AWS e-Learning

Cisco Continuing Education (CE)

Cisco Learning Credits

Cisco U

Free Networking Training Consultation

Google Cloud Leadership AI Training

Solutions

Resources

Company

Oracle 12c: Security Administration

Upcoming Schedules

Course Outline