Oracle Database 19c Administration Training - Canada

Oracle Database 19c Administration Training Course Outline

Module 1: Introduction to Oracle Database

• Overview of the Oracle Database
• Overview of the Oracle Cloud
• Relational Database Concepts
• Database Administration Tasks

Module 2: Oracle Database Architecture

• Overview
• Database and Instance
• Oracle Database Memory Structures
• Process Architecture and Structures
• Server and Client Processes
• Oracle Database Storage Architecture
• Connect to the Oracle Database Instance

Module 3: Administer a Database Instance

• Administrative Tools Available to a DBA
• Use SQL*Plus in Oracle to Manage a Database Instance
• Use SQL Developer to Manage a Database Instance
• Overview of the Enterprise Manager Framework
• Access Enterprise Manager Database Express
• Enterprise Manager Cloud Control
• Initialisation Parameter Files

Module 4: Configure the Oracle Network Environment

• Overview of Network Configuration
• Oracle Net Listener Configuration
• Oracle Net Naming Methods
• Tools for Network Configuration
• Client Connections with Net Manager
• Viewing Listener Configuration
• Starting and Stopping the Listener
• Use TNSPING to Test Oracle Net Connectivity
• Connect to the Database
• Configure Net Services with EM

Module 5: Storage Structures

• Overview of Data Storage
• Database Block
• Overview of Tablespaces and Data Files
• Use Enterprise Manager to View the Storage Structure of the Database
• Create and Alter Tablespace Commands
• Temporary Tablespaces
• Create and Manage Datafiles
• Use OMF
• Drop Tablespaces and Datafiles

Module 6: Manage Users

• Predefined Database Administration Accounts
• User Accounts
• Create a User Account
• Change a User's Password
• Manage and Drop a User Account
• Monitor User Information
• Terminate User Sessions
• Create a Schema Only Account

Module 7: Manage Privileges

• Database Access
• Oracle Supplied Roles
• System and Object Level Privileges
• Grant and Revoke Commands
• Create, Alter, and Drop Roles
• Use Predefined Roles

Module 8: Database Auditing

• Overview of Database Security
• Overview of Database Auditing
• Standard Auditing
• Unified Audit Trail
• Separation of Audit Responsibilities
• Configure the Audit Trail
• Specify Audit Options

Module 9: Data Concurrency and Lock Conflicts

• Data Concurrency and Consistency
• Levels of Locking in Oracle
• Methods Used to Acquire Locks
• Possible Causes of Contention
• DML Locks
• Prevent Locking Problems
• Detect Lock Contention
• Resolve Conflicts

Module 10: Undo Management

• Undo Data Overview
• Monitor and Administer Undo
• Configure Undo Retention
• Switch Undo Tablespaces
• Specify the Retention Period
• Guarantee Undo Retention
• Oracle Flashback Query
• View Undo Space Information
• Use the Undo Advisor
• Alter an Undo Tablespace to a Fixed Size

Module 11: Backup and Recovery Configuration

• Oracle Backup Solutions Program
• Oracle Suggested Backup Strategy
• Overview of Database Backup, Recover
• Flashback Technology
• Types of Failure
• Instance Recovery
• Tune Instance Recovery
• MTTR Advisor
• Media Failure
• Configure a Database for Recoverability

Module 12: Proactive Database Maintenance

• Database Maintenance
• View the Alert Log
• Automatic Workload Repository
• Statistic Levels
• Automatic Database Diagnostic Monitoring
• Monitor an Oracle Database
• Use the Advisors
• Set Up Notification Rules

Module 13: Performance Management

• Tuning Information Sources
• Performance Monitoring
• Performance Planning
• Instance Tuning
• Performance Tuning Methodology
• Performance Tuning Data
• Managing Memory
• Manage Private Temporary Tables

Module 14: SQL Tuning

• Overview
• Cancel a SQL Statement in a Session
• Oracle Optimiser
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Advisors
• Implement Automatic Tuning Recommendations

Module 15: Moving Data

• Create Directory Objects
• Data Pump Architecture
• Data Pump Data Dictionary Views
• Use Data Pump to Export and Import Data
• Overview of SQL Loader
• Command Line Parameters
• Record Filtering
• Control File Keywords
• Data Files
• SQL Loader Data Paths
• External Tables

Module 16: Managing Resources with Resource Manager

• Database Resource Manager
• Use the Resource Manager
• Create Resource Plans
• Create Resource Plan Directives
• Allocate Resources for Resource Plans

Module 17: Automate Tasks with the Scheduler

• Introduction to the Scheduler
• Access Rights
• Scheduler Components and Workflow
• Create a Job
• Job Classes
• Use Time Based, Event-Based Schedules
• Create an Event-Based Schedule

Module 18: Manage Space

• Overview of Space Management
• Block Space Management within Segments
• Segment Types
• Allocate Extents and Space
• Row Chaining and Migration
• Create Tables without Segments

Module 19: Oracle Support

• Enterprise Manager Support Workbench
• Register for Security Updates
• Work with Oracle Support
• Log Service Requests
• Manage Patches
• Apply a Patch