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
Oracle Database Architecture
- Oracle Database 23ai architecture
- Instance configurations
- Memory and process structures
- Logical and physical database structures
Oracle Administration Tools
- Oracle-provided tools for database administration
- Practical use of management tools
Instance Management
- Starting and stopping the database
- 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
- Segment and block-level space management
Undo and Data Management
- Undo and redo data
- Temporary undo
- Moving data with 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
- Principles of performance management
- Performance monitoring
- SQL execution and execution plans
Requirements
-
Audience
- Junior DBA
- System Administrators
- IT Technicians working in Oracle Database environments
-
Prerequisites
- Basic knowledge of relational databases
- Familiarity with SQL and system administration concepts
21 Hours
Testimonials (3)
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
