What is a Database?
• What is the Relation Database?
• Oracle RDBMS Vs. Other Popular RDBMS
• Becoming Familiar with Database Administration
• The need to Administer a Database
• Getting to know about Database Administrators (DBA)
• DBA Roles and Responsibilities

Oracle Database Server Architecture
• Oracle DB Configurations & Instance
• Connecting the DB Instance
• Memory Structures
• Sharing of Buffers and Pool
• Understanding The System Global Area (SGA)
• Understanding the Program Global Area (PGA)
• In-Memory caching of the Database
• Process Structures and Architectures
• Oracle Database Logs
• Oracle Process – SMON, RECO, PMON, LGWR, CKPT, ARCn, and LREG
• Storage Architecture
• Physical and Logical Structure of the Oracle Database
• Multitenant Architecture
• TableSpaces

Getting to know the Oracle Management Tools
• Learning the SQL* Plus
• SQL Scripts
• SQL Developer
• Oracle Enterprise Manager
• Configurations and Logging of the Oracle Enterprise Manager
• Options and Menus of the Oracle Enterprise Manager
• Cloud Control Framework

Get started with the Initialization Files
• Parameters of the Initialization Files
• Changing and Viewing of the Initialization Parameters
• Starting up the Oracle Database Instance with Various Options and Parameters
• Shutdown Options and Modes
• Trace Files
• Alert Files
• Debug Log Files
• DDL Files
• Oracle Dynamic Performance Views
• Oracle Dynamic Performance Considerations
• Introduction to Oracle Data Dictionary

• Outline of the Oracle Net Services
• Outline of the Oracle Net Listener
• Connecting the Oracle Database
• Naming Methods
• User Sessions
• Handling the Oracle Net Services
• Advanced Connection Options
• Shared Server Processes
• Dedicated Server Processes
• Use of PGA and SGA
• Communication Between Databases

User Accounts
• Predefined Administrative Accounts
• Securing Privileged Accounts
• Administrative Privileges
• Users Authentication
• Administrator Authentication
• OS Authentication
• OS Groups Authentication
• Manage and Create User Accounts
• Handle the Privileges with the Grant and Admin option
• Manage and Create Roles
• User Quotas
• Password Security Features

• Table Data storage Architecture
• Table Space
• Manage the Table Space – Create, Drop, Alter, and Dropping TableSpace
• Oracle Managed Files

• Getting to know the Space Management
• Manage the Row Chaining, Block Space and Migration
• Segments
• Extents
• Exceptions and Restrictions
• Outline of Table Compression
• Different Compression Implementation with the DBMS_Compression Package
• Handle the Table usage and Resolve the Space problems

• Objectives of the Data Concurrency
• Locking Data
• Locking Mechanism
• Lock Conflicts
• Lock Resolution
• Deadlocks
• Data Concurrency

• Significance of Database Security
• Database Compliances
• Outline of Database Auditing
• Audit Architecture
• Audit Configuration
• Create and Handle the Audit Policy
• Kinds of Auditing – Fine-Grained, Value-Based
• Audit Trail

• Archiver Process
• Archive log Mode
• Oracle Backup solutions
• User – Manages and Secure Backups
• Kinds of Backups
• Backup Terminologies
• Settings and Backing Configuration
• Managing Backups
• Backup Strategies
• Keeping a Database Open for Recovery
• Managing Loss of Various Log Files Database Failures
• Categories and kinds of Database failures
• Database Recovery
• Types and Phases of Recovery
• Instance Failure
• Managing Media Failure
• Complete Recovery
• Incomplete Recovery
• Configuration for Recovery
• Data Protection Solutions by Oracle
• Redo Log Files

• Common Architecture of Moving Data
• Getting to know the Oracle Data Benefits and Pump
• Handle and Create Directory Objects
• Outline of the SQL Control Files and SQL Loader
• Different Loading Methods
• Handling and Using the External Tables with the Oracle -Datapump and Oracle – Loader

• Importance of the Performance
• Planning the Performance of the Database and Monitoring it
• Performance Tuning using the Enterprise Manager Database
• Monitoring and Managing Sessions Performance with the Session -Related Statistics
• Handling and Monitoring the Services with the Service-Related Statistics
• Handle the Memory Performance
• Oracle Automatic Memory Management
• Handle the Performance with the SQL Tuning
• Get to know the Oracle Optimizer
• Understand the Optimizer Statistics
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Performance Analyzer
• SQL Performance usage

• Concepts and Outline of the Database Resource Manage
• Creation of Resource Plan
• Utilization of CPU
• Monitoring Resource Manager
• Resource Manager Statistics
• Oracle Scheduler
• Getting to know the Oracle Scheduler for Automate Tasks
• Core Components of the Oracle Scheduler
• Event-Based Schedules
• Time-Based Schedules
• Manage and Create Complex Schedules
• Handle and Create Job Array & Job Chain
• Handle and Schedule Remote Database Jobs