Oracle Database 21c Administration Training Course

Oracle Database 21c is a converged database that supports a large range of workloads and data models. It’s a data management platform that provides high performance, security, availability, and scalability for cloud environments.

Course Outline

Introduction

• Introduction to Oracle Cloud
• Overview of Oracle Database 21c

Oracle Database Architecture

• Overview of the Oracle Database architecture
• Configuring and connecting to the Oracle Database Instance
• Understanding the Oracle Database memory structures
• Process architecture and structures
• Process startup sequence
• Storage architecture

Database Instance

• Overview of the Oracle Database management tools
• Enterprise manager management framework

Setting Up the Oracle Network Environment

• Overview of the Oracle Net Services and Oracle Net Listener
• Oracle Network Connections
• Configuring the Oracle Network tools
• Listener Control Utility
• Oracle Net configuration assistant
• Oracle Net Manager
• Enterprise Manager Cloud Control

Database Storage Structures

• Overview of Database Block Content
• Storage structure
• Creating and managing Tablespaces
• Navigating and viewing Tablespace information
• Using Oracle managed files

User Security

• Managing database user accounts
• Predefined administrative accounts
• Creating a user account
• Authentication and password reset
• Understanding the concept of privileges, roles, and profiles

Data Concurrency

• Understanding the locking mechanism
• Understanding data concurrency
• DML locks
• Enqueue mechanism
• Lock conflicts

Undo Data

• Overview of Undo data
• Managing transactions and storing Undo information
• Undo data vs. Redo data
• Configuring and guaranteeing Undo retention
• Changing the size of an Undo Tablespace

Oracle Database Auditing

• Overview of database auditing
• Database security and compliance monitoring
• Standard database auditing
• Audit administration
• Configuring audit train
• Audit options

Database Maintenance

• Overview of database maintenance
• Alert history
• Automatic Database Diagnostic Monitoring (ADDM)
• Understanding the advisory framework
• Enterprise manager and advisor

Managing Performance and Resources

• Monitoring performance
• Tuning activities and performance planning
• Instance tuning
• Performance tuning methodology and data
• Managing memory
• Overview of Database Resource Manager
• Using the Database Resource Manager
• Maintenance Resource Manager plan
• Resource Manager workflow
• Resource allocation methods

Space Management

• Block space management
• Chaining and migration
• Understanding the types of segments
• Allocating extents and space
• Creating tables without segments

Backup and Recovery

• Overview of Instance Recovery
• Understanding and configuring Instance Recovery
• Instance Recovery Phases
• Using MTTR Advisor
• Understanding Media Failure

Summary and Next Steps

Contact us

email - [email protected]