Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Requirements
- Fundamental knowledge of Linux and SQL.
Audience
- Database administrators and developers.
- Cloud database architects.
- Application developers.
28 Hours
Testimonials (1)
I found his methods very informative
