Oracle DBA Training Program

Oracle Database Management Tools

• Introducing Oracle Database Management Tools

• Using SQL*Plus

• Using SQL Developer

• Logging in to Oracle Enterprise Manager Database Express

• Using the Enterprise Manager Database Express Home Page

• Understanding the Enterprise Manager Cloud Control Framework

• Using Enterprise Manager Cloud Control

Parameters & Parameter Files

• Initialization Parameters

• Static and Dynamic parameters

• Parameter Files

• Text & Server Parameter Files

• System & Session Level Parameters

• Changing Parameter values

Managing Data Files & Tablespaces

• Tablespace and Data Files Concepts

• Blocks, Extents, Segments

• Understanding Space Management

• Creating & Managing Tablespaces

• Big file Tablespaces

• Tablespace Quotas

• Configuring Multi-Block Support

Managing Temporary Tablespaces

• Understanding Temporary Tablespaces

• Managing Temporary Tablespaces

• Temporary Tablespace Groups

• Managing Control Files

• Understanding Control Files

• Multiplexing Control Files

• Backing up Control Files

Redo Log Files & Archiving

• Online & Archived Redo Log Files

• Managing Online Redo Log Files

• Fast Recovery Area (FRA)

• Configuring Database Archive mode

Oracle Managed Files (OMF)

• OMF Concepts and Use

• File Naming Conventions using OMF

• Creating Tablespaces with OMF

Managing Data Storage

• Learn about Data Storage

• Database Block contents

• Exploring database structure

• Create a new Tablespace

• Managing Tablespace

• Displaying Tablespace Data

• Using OMF

Managing Diagnostic data

• Diagnostic files

• Automatic Diagnostic Repository (ADR)

• Viewing Diagnostic data

Managing Undo Data

• Transactions and Undo Data

• Managing Undo data

• Storing Undo Information

• Creating Undo Tablespaces

• Comparing Undo Data and Redo Data

• Configuring Undo Retention

• Guaranteeing Undo Retention

• Changing an Undo tablespace to a Fixed Size

Moving Data

• Moving Data: General Architecture

• Oracle Data Pump

• SQL*Loader

• External Tables

Database Instance Management

• 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

Oracle Network Environment Configuration

• Oracle Net Services Overview

• Oracle Net Listener Overview

• Establishing Oracle Network Connections

• Connecting to a Server

• Tools for Configuring and Managing the Oracle Network

• Using the Listener Control Utility

• Using Oracle Net Configuration Assistant

• Using Oracle Net Manager

User Administration

• Creating Users Accounts

• Account management

• Schema, Session, Killing Sessions

• Using profiles to implement complex passwords and resource limits

Privileges & Roles

• Understanding Privileges

• Managing Privileges

• Understanding Roles

• Managing Roles

Database Links

• Distributed Databases

• Creating Database Links

• Managing Database Links

Data Concurrency Management

• Overview of Locks

• Locking Mechanism

• Data Concurrency

• DML Locks

• Enqueue Mechanism

• Lock Conflicts

Space Management

• 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

Database Auditing Implementation in Oracle DBA 12c

• 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

Backup and Recovery Basics

• 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

Backup and Recovery Configuration

• 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

Performing Database Backups

• Backup Solutions Overview

• Oracle Secure Backup (overview)

• User Managed Backup (overview)

• 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

Performing Database Recovery

• Data Recovery Advisor

• Loss of a Control File

• Loss of a Redo Log File

• Loss of a Datafile in NOARCHIVELOG Mode

• Loss of a Noncritical Datafile in ARCHIVELOG Mode

• Loss of a System-Critical Datafile in ARCHIVELOG Mode

Performing Database Maintenance

• 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

Managing Performance

• Performance Monitoring

• Tuning Activities

• Performance Planning

ORACLE Multitenant Architecture

• Multitenant Architecture

• Pluggable Databases (PDB) & Container Database (CDB)

• Creating & Managing CDBs & PDBs

• Users, Roles, Privileges in CDB

• Parameters in CDB

• Backup, Recovery of CDBs & PDBs

Flashback Technologies

• Oracle Flashback Technologies

• Flashback Database

• Flashback Table

• Flashback Drop Table

Oracle Data Pump

• Concepts of Logical backups & Refresh

• Data Pump Exports & Imports

Transportable Tablespaces

• Concepts of Transportable Tablespaces

• Transporting Tablespaces across Databases

Database Cloning

• Cloning Concepts and Considerations

• Cloning Techniques

• Cloning Oracle Home and Database

• Manual Cloning

• Cloning using RMAN

Data Guard

• Overview of Data Guard

• Benefits of Implementing Data Guard

• Standby Database Concepts

• Implementing Physical Standby database

Database Patching

• Patching Concepts

• Interim Patches, CPU, PSU patches

• Patch Sets

• Downloading & Analysing Patches

• Applying Patches

Database Upgrade

• Understanding the upgrade process

• Upgrade methods

• Upgrading Oracle11g to Oracle 12c

Placement Guide

• Tips to clear an Interview

• Common Interview questions and answers

• Oracle DBA 12c Interview Questions and Answers

• Resume Building Guide

• Attempt for Oracle DBA Global Certification Exam

• Start applying for Job

• 0