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.
Duration 21 hours
Course Outline
Oracle Database Architecture
- Oracle Database 23ai architecture
- Instance configurations
- Memory structures and processes
- Logical and physical database structures
Oracle Administration Tools
- Tools provided by Oracle for database administration
- Practical use of management tools
Instance Management
- Database startup and shutdown procedures
- Using dynamic performance views and the data dictionary
- Automatic Diagnostic Repository (ADR) and log files
- Initialization parameter files
Oracle Net Services
- Oracle Net administration components
- Database connection methods
Security: Users, Roles, and Privileges
- User management
- Roles and privileges
- Basic security controls
Tablespace and Storage
- Creating and managing tablespaces
- Datafiles and space allocation
- Managing segments and block-level space
Undo and Data Management
- Undo and redo data
- Temporary undo
- Moving data using External Tables, Data Pump, and SQL*Loader
Pluggable Database (PDB)
- Creating PDBs from the seed
- Managing PDB modes and attributes
Auditing and Maintenance
- Database auditing
- Fine-Grained Auditing
- Automatic maintenance
Introduction to Performance
- Performance management principles
- Monitoring performance
- SQL execution and execution plans
Requirements
Audience
- Junior DBAs
- System administrators
- IT technicians working with Oracle Database environments
Prerequisites
- Basic knowledge of relational databases
- Familiarity with SQL and system administration concepts
Testimonials (1)
A good balance in covering the most useful key points with very practical and relevant examples.
