Oracle Database 12c Admin, Install and Upgrade Accelerated Training

·           Oracle Database Architecture: Overview

·           Oracle Database Instance Configurations

·           Connecting to the Oracle Database Instance

·           Oracle Database memory Structures (overview)

·           Process Architecture

·           Process Structures

·           Process Start-up Sequence

·           Database Storage Architecture

·           Practical Exercise

·         Planning Your Installation

·         Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM

·         Operating System Groups and Users

·         Environment Variables

·         Configuring the Oracle Software Owner Environment

·         Using Oracle Universal Installer (OUI)

·         Installation Option: Silent Mode

·         Practical Exercise

·         System Requirements for Oracle Database

·         Creating Operating System Groups and Users

·         Types of Installations

·         Practical Exercise

·         Planning the Database Storage Structure

·         Types of Databases (based on workload)

·         Choosing the Appropriate Character Set

·         Understanding How Character Sets are Used

·         Setting the NLS_LANG Initialization Parameter

·         Using the Database Configuration Assistant (DBCA)

·         Practical Exercise

·         Introducing Oracle Database Management Tools

·         Using SQL*Plus

·         Using SQL Developer

·         Logging in to Oracle Enterprise Manager Database Express

·         Enterprise Manager Database Express Home Page

·         Enterprise Manager Cloud Control Framework

·         Using Enterprise Manager Cloud Control

·         Practical Exercise

·         Initialization Parameter Files

·         Starting an Oracle Database Instance

·         Shutting Down an Oracle Database Instance

·         Viewing Log Files

·         Using Trace Files

·         Using the Dynamic Performance Views

·         Data Dictionary

·         Practical Exercise

·         Oracle Net Services Overview

·         Oracle Net Listener Overview

·         Establishing Oracle Network Connections

·         Connecting to a Server

·         Tools for Configuring & Managing the Oracle Network

·         Using the Listener Control Utility

·         Using Oracle Net Configuration Assistant

·         Using Oracle Net Manager

·         Practical Exercise

·         Database User Accounts (overview)

·         Predefined Administrative Accounts

·         Creating a User

·         Authentication

·         Unlocking a User Account & Resetting the Password

·         Privileges

·         Roles

·         Profiles

·         Practical Exercise

·         Understanding Storage of Data

·         Database Block contents

·         Exploring the Storage Structure

·         Creating a New Table-space

·         Overview of Table-spaces Created by Default

·         Managing Table-spaces

·         Viewing Table-space Information

·         Using Oracle Managed Files

·         Practical Exercise

·         Space Management Overview

·         Block Space Management

·         Row Chaining and Migration

·         Free Space Management Within Segments

·         Types of Segments

·         Allocating Extents

·         Allocating Space

·         Creating Tables Without Segments

·         Practical Exercise

·         Undo Data Overview

·         Transactions and Undo Data

·         Storing Undo Information

·         Comparing Undo Data and Redo Data

·         Managing Undo

·         Configuring Undo Retention

·         Guaranteeing Undo Retention

·         Changing an Undo table-space to a Fixed Size

·         Practical Exercise

·         Overview of Locks

·         Locking Mechanism

·         Data Concurrency

·         DML Locks

·         Enqueue Mechanism

·         Lock Conflicts

·         Practical Exercise

·         Separation of Responsibilities

·         Database Security

·         Monitoring for Compliance

·         Standard Database Auditing

·         Unified Audit Data Trail

·         Separation for Duties for Audit Administration

·         Configuring the Audit Trail

·         Specifying Audit Options

·         Categories of Failures

·         Flashback Technology

·         Understanding Instance Recovery

·         Phases of Instance Recovery

·         Tuning Instance Recovery

·         Using the MTTR Advisor

·         Comparing Complete and Incomplete Recovery

·         Oracle Data Protection Solutions

·         Practical Exercise

·         Configuring for Recoverability

·         Configuring the Fast Recovery Area

·         Multiplexing the Control File

·         Online Redo Log File

·         Multiplexing the Online Redo Log File

·         Archived Redo Log Files

·         Archiver Process

·         Archived Redo Log File Naming and Destinations

·         Practical Exercise

·         Backup Solutions 

·         Oracle Secure Backup 

·         User Managed Backup 

·         Backup Terminology and Types of Backups

·         Using Recovery Manager (RMAN)

·         Configuring Backup Settings

·         Oracle-Suggested Backup

·         Backing Up the Control File to a Trace File

·         Practical Exercise

·         Data Recovery Advisor

·         Loss of a Control File

·         Loss of a Redo Log File

·         Loss of a Data file in NOARCHIVELOG Mode

·         Loss of a Noncritical Data file in ARCHIVELOG Mode

·         Loss of a System-Critical Data file in ARCHIVELOG Mode

·         Practical Exercise

·         Moving Data: General Architecture

·         Oracle Data Pump

·         SQL*Loader

·         External Tables

·         Practical Exercise

·         Database Maintenance (overview)

·         Viewing the Alert History

·         Terminology

·         Automatic Workload Repository (AWR)

·         Statistic Levels

·         Automatic Database Diagnostic Monitor (ADDM)

·         Advisory Framework

·         Enterprise Manager and Advisors

·         Practical Exercise

·         Performance Monitoring

·         Tuning Activities

·         Performance Planning

·         Instance Tuning

·         Performance Tuning Methodology

·         Performance Tuning Data

·         Monitoring Performance

·         Managing Memory

·         Practical Exercise

·         Database as a Service Architecture, Features & Tooling

·         Software Editions: Included Database Options &

       Management Packs

·         Automated Database Provisioning

·         Managing the Compute Node Associated With a Database

       Deployment

·         Managing Network Access to Database as a Service

·         Enabling Access to a Compute Node Port

·         Scaling a Database Deployment & Patching Database as a

       Service

·         Oracle Database Cloud Service Console to Manage Patches

·         Practical Exercise