Oracle 12c Security Administration

Course Description

Thank you for reading this post, don't forget to subscribe!

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.

Audience Profile

• Database administrators
• Support engineers
• Technical consultants
• Systems administrators
• Network managers
• Technical support personnel

Prerequisites

Good knowledge of Oracle Database

Learning Objectives

• Create and administer user accounts in the Oracle 11g database.
• Backup and recover the database.
• Monitor, troubleshoot, and maintain the database

Course Outline

Module 1: SQL and PL/SQL
Lessons
• Basic SQL Syntax
• SQL Functions
• Advanced SQL Queries
• PL/SQL Program Structure
• Accessing the Database
Lab: Multiple SQL Labs
Lab: Multiple PL/SQL Labs

Module 2: Create and Oracle Database
Lessons
• Describe Oracle Database Architecture
• Understand the Instance Architecture
• Use the Management Framework and the Database Creation Assistant
Lab: Architecture/Advanced Memory Mgt.

Module 3: Controlling the Database
Lessons
• Start and Stop the Agent and the Listener
• Startup and Shutdown the Database
Lab: Starting and Stopping the Database

Module 4: Administering Users
Lessons
• Create and Manage Database User Accounts, and Manage Roles
• Grant and Revoke Privileges
• Control Resource Usage by Users
Lab: Using the Database Console (EM)

Module 5: Managing Schema Objects
Lessons
• Create and Modify Tables, Indexes, and Views
• Define Constraints
• View the Attributes and the Contents of a Table
Lab: Tables, Indexes and Constraints

Module 6: Oracle Database Security
Lessons
• Apply the Principal of Least Privilege
• Manage Default User Accounts
• Implement Standard Password Security Features
• Audit database activity
Lab: Creating Other Database Objects

Module 7: Proactive Maintenance: Objectives
Lessons
• Set Warning and Critical Alert Thresholds
• Collect and Use Baseline Metrics
• Use Tuning/Diagnostic Advisors/ADDM/ADR
Lab: Users and Security

Module 8: Recovery Manager Configuration
Lessons
• Parameters Affecting RMAN
• Use of a Flashback Recovery Area
• The CONFIGURE Command
• Persistent Settings
• NOCATALOG / CATALOG Mode
• Channel Allocation
• Controlfile Autobackup
• Retention Policies
Lab: Performance Metrics and Monitoring

Module 9: Recovery Manager Operations
Lessons
• Using the BACKUP Command
• Creating Backup Sets / Image Copies
• Compressed Backups
• Incremental Backups
• Block Change Tracking
• RMAN Backup Monitoring
• REPORT and LIST Commands
Lab: Archivelog Setup

Module 10: Non-Critical Loss Recovery
Lessons
• Password and Network Files
• Read-Only Tablespaces
• Temporary Tablespaces
• Index Tablespaces
• Redo Log Members / Control Files
Lab: Recovery Manager Configuration

Module 11: Database Recovery
Lessons
• Complete Recovery
• Incomplete Recovery
Lab: Recovery Manager Backups

Module 12: Flashback Database
Lessons
• When in Use
• Configuration and Use
• Monitoring Flashback Database
• Flash Recovery Area Maintenance
• Flash Recovery Area Monitoring

Module 13: User Error Recovery
Lessons
• The New Recycle Bin
• Querying Dropped Tables
• Flashback Versions Table
• Flashback Transaction Query

Module 14: Automatic Database Management
Lessons
• Management and Advisory Framework
• Automatic Statistics Collection
• The Automated Workload Repository
• Database Advisors
• Automatic Statistics Collection
Lab: Automated Management Tools

Module 15: Virtual Private Database
Lessons
• Row Level Control
• Column Level Control

Module 16: Oracle Auditing
Lessons
• Full Security Monitoring