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 35 hours
Course Outline
Introduction
- Fundamentals of Oracle database server architecture
- Insights into Oracle multitenant container databases
- Oracle database instances and the concept of database sharding
Accessing Oracle Database
- Establishing connections to an Oracle database instance
- Utilizing various Oracle database tools
- Working with SQL*Plus
- Leveraging Oracle SQL developer
- Employing the Database Configuration Assistant (DBCA)
- Exploring the features of Enterprise Manager cloud control 13c
- An overview of Oracle Enterprise Manager components
- The concept of a single pane of glass for enterprise management
- Administration of the Oracle Enterprise Manager database
Creating an Oracle Database
- Building an Oracle database via DBCA
- Constructing an Oracle database using SQL commands
Managing Database Instances
- Initiating the Oracle database instance
- Terminating an Oracle database instance
- Differentiating between various shutdown modes
- Opening and closing Pluggable Databases (PDBs)
- Setting up PDB configurations
Administering Database Instances
- Application of initialization parameters
- Interaction with the automatic diagnostic repository
- Reviewing the alert log
- Utilization of trace files
- Maintenance of the DDL log file
- Utilizing dynamic performance views
- Navigating the data dictionary
Oracle Net Services Overview
- Identification of Oracle Net services components
- Setup and management of Oracle Net services
- Introduction to the Oracle Net listener
- Contrast between dedicated and shared server architectures
Naming Conventions
- Establishing Oracle network connections
- Comprehension of different naming methods
- Implementation of easy connect
- Local versus directory naming strategies
- Workload management through database services
- Creation of database services
Listener Administration
- Operation of the default listener
- Setup of dynamic service registration
- Configuration of static service registration
Shared Server Architecture Configuration
- Activation of shared server mode
- Regulation of shared server activities
- Application of SGA and PGA
- Considerations for shared server configuration
Oracle Connect Manager Configuration
- Understanding the Oracle Connection Manager
- Application of filtering rules
- Implementation of intranet and internet access controls
- Utilization of session multiplexing
- General setup of the Oracle Connection Manager
- Configuration of the cman.ora file
- Client-side configuration
- Database server configuration
- Use of the Oracle Connection Manager control utility
PDB Creation
- Provisioning of new pluggable databases
- Creating a new PDB from the PDB$SEED
- Application of the FILE_NAME_CONVERT clause
- Use of OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative methods for PDB creation
PDB Management
- Modifying PDB operating modes
- Adjustment of PDB settings
- Alteration of initialization parameters
- Use of the Alter System Command within a PDB
- Configuration of hostname and port number for each PDB
- Deletion of PDBs
Database Storage Concepts
- Architecture of database storage
- Core database structures
- Utilization of segments, extents, and blocks
- Management of tablespaces and data files
- Classification of segment types
- Storage of table data
- Content of database blocks
- Management of deferred segment creation
- Monitoring of tablespace space utilization
Tablespace Administration
- Creation of new tablespaces
- Definition of default permanent tablespaces
- Management of temporary tablespaces
- Modification and deletion of tablespaces
- Deployment of Oracle Managed Files (OMF)
- Relocation or renaming of online data files
Space Usage Optimization
- Understanding of space management capabilities
- Control of block space
- Specification of table compression
Undo Data Management
- Handling of transactions and undo data
- Retention of undo information
- Setting of undo retention periods
- Activation of temporary undo
User Account Creation and Management
- Administrator accounts provided by Oracle
- User authentication processes
- Assignment of resource quotas
Privilege and Role Configuration
- Understanding of system privileges
- Configuration of system-level privileges
- Ongoing management of privileges
User Resource Limit Configuration
- Administration of profiles and user accounts
- Comprehension of profile parameters
Oracle Database Auditing
- Insights into database security measures
- Implementation of auditing mechanisms
- Development of FGA policies
Data Loading and Transport
- Methods for moving data
- Techniques for data loading
- Export and import of data
- Transporting the entire database
Database Monitoring
- Performance management tasks
- Maintenance of database systems
- Strategies for performance tuning
Database Processes
- Structure of process architecture
- Utilization of various writer and monitor processes
Memory Management
- Administration of memory components
- Implementation of automatic memory management
SQL Analysis
- Utilization of the Oracle optimizer
- Optimization of access paths
- Use of SQL plan directives
Requirements
- Familiarity with basic SQL concepts
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (4)
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
Everything in the world of ORACLE
Geiner Gomez Gomez - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
The cheat sheets
Aaron Fernandez Rodriguez - OSFEM
Course - Oracle Database 19c: Administration
Machine Translated
Generating reports with the graphical interface.
Harold Romero Romero - OSFEM
Course - Oracle Database 19c: Administration
Machine Translated
