This course is suitable for individuals who need to understand and manage an Oracle 19c database, or those seeking a general understanding of Oracle database functionality. This includes end users, business analysts, application developers, database administrators, and IT management.

• Ensure fast, reliable, secure, and easy-to-manage performance.
• Optimize database workloads, lower IT costs, and deliver a higher quality of service by enabling consolidation onto database clouds.
• Gain a firm foundation in Oracle Database administration, with a strong understanding of Oracle Database architecture.
• Learn how to manage an Oracle database effectively and efficiently.
• Create database storage structures suitable for business applications.
• Administer users and manage database security according to business requirements.
• Learn basic backup and recovery techniques.
• Monitor the database and manage performance to ensure acceptable response times and resource management.
• Get hands-on experience with tools like Enterprise Manager Database Express (EMDE), SQL Developer, and SQL*Plus.
• Learn how to manage an Oracle Database instance, configure the Oracle Network environment, and create and manage storage structures.
• Manage and move data, create and manage users, and create and manage database deployments in Oracle Cloud Service.

Exploring the Oracle Database Architecture:

• Overview of Oracle Database Architecture
• Oracle Database Instance Configurations
• Connecting to the Oracle Database Instance
• Oracle Database Memory Structures
• Process Architecture and Process Structures
• Process Startup Sequence
• Database Storage Architecture

Managing the Database Instance:

• Introduction to Oracle Database Management Tools
• Enterprise Manager Management Framework
• Logging into Oracle Enterprise Manager Database Express
• Using the Enterprise Manager Database Express Home Page
• Using Enterprise Manager Cloud Control
• Using SQL*Plus and SQL Developer
• Initialization Parameter Files

Configuring the Oracle Network Environment:

• Overview of Oracle Net Services and Oracle Net Listener
• Establishing Oracle Network Connections
• Tools for Configuring and Managing the Oracle Network
• Using the Listener Control Utility, Oracle Net Configuration Assistant, and Oracle Net Manager
• Using Enterprise Manager Cloud Control

Managing Database Storage Structures:

• Understanding Data Storage and Database Block Contents
• Exploring Storage Structure
• Creating and Managing Tablespaces
• Using Oracle Managed Files

Administering User Security:

• Database User Accounts and Predefined Administrative Accounts
• Creating, Unlocking, and Resetting User Accounts
• Managing Privileges, Roles, and Profiles

Managing Data Concurrency:

• Overview of Locks and Locking Mechanism
• Data Concurrency, DML Locks, Enqueue Mechanism, and Lock Conflicts

Managing Undo Data:

• Overview of Undo Data, Transactions, and Undo Information
• Managing Undo, Configuring Undo Retention, and Guaranteeing Undo Retention
• Changing Undo Tablespace to a Fixed Size

Implementing Oracle Database Auditing:

• Separation of Responsibilities and Database Security
• Monitoring for Compliance and Standard Database Auditing
• Configuring the Audit Trail and Specifying Audit Options

Performing Database Maintenance:

• Database Maintenance and Viewing Alert History
• Using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)
• Using Enterprise Manager and Advisors for Database Maintenance

Managing Performance:

• Performance Monitoring, Tuning Activities, and Performance Planning
• Instance Tuning, Performance Tuning Methodology, and Monitoring Performance
• SQL Tuning, Oracle Optimizer, and SQL Plan Directives
• Using SQL Advisors, Automatic SQL Tuning Results, and Implementing Tuning Recommendations

Managing Resources Using Database Resource Manager:

• Overview and Concepts of Database Resource Manager
• Using Resource Manager, Default Maintenance Plan, and Resource Plan Directives
• Resource Allocation Methods for Resource Plans

Automating Tasks Using Oracle Scheduler:

• Simplifying Management Tasks
• Core Components and Basic Workflow
• Using Time-Based and Event-Based Schedules
• Creating Time-Based and Event-Based Jobs

Managing Space:

• Overview of Space Management
• Block Space Management, Row Chaining and Migration
• Free Space Management Within Segments
• Types of Segments and Space Allocation

Backup and Recovery Concepts:

• Categories of Failures and Flashback Technology
• Instance Recovery, Phases, and Tuning
• Media Failure and Configuring for Recoverability

Moving Data:

• Oracle Data Pump, SQL*Loader, and External Tables
• Using Oracle Support Workbench and Enterprise Manager for Data Movement

Working with Oracle Support:

• My Oracle Support Integration, Researching Issues, and Logging Service Requests
• Managing and Applying Patches

• Create and manage an Oracle Database Instance.
• Create and manage storage structures.
• Configure the Oracle Network Environment.
• Create and manage users.
• Monitor the database and manage performance.
• Learn basic backup and recovery techniques.
• Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software.