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
- Summary of Oracle database server architectural framework
- Examination of the Oracle multitenant container database environment
- Analysis of Oracle database instances and sharding methodologies
Oracle Database Access Protocols
- Establishing connections to Oracle database instances
- Utilization of Oracle database administrative tools
- Operations within SQL*Plus
- Application of Oracle SQL Developer
- Execution of Database Configuration Assistant (DBCA) procedures
- Evaluation of Enterprise Manager cloud control 13c capabilities
- Summary of Oracle Enterprise Manager constituent elements
- Integration of enterprise management through a single-pane-of-glass interface
- Administration of the Oracle Enterprise Manager database
Oracle Database Provisioning
- Initialization of an Oracle database via DBCA
- Creation of an Oracle database using SQL scripting
Operations on Database Instances
- Initialization of the Oracle database instance
- Termination of an Oracle database instance
- Differentiation of shutdown modes
- Process management for opening and closing PDBs
- Configuration of PDB parameters
Administration of Database Instances
- Application of initialization parameters
- Management of the automatic diagnostic repository
- Review of the alert log
- Utilization of trace files for diagnostics
- Governance of the DDL log file
- Interaction with dynamic performance views
- Querying the data dictionary
Oracle Net Services Framework
- Identification of Oracle Net Services constituent elements
- Configuration and governance of Oracle Net Services
- Overview of the Oracle Net listener component
- Contrast between dedicated and shared server architectures
Network Naming Strategies
- Establishment of Oracle network connections
- Interpretation of available naming methods
- Implementation of Easy Connect
- Application of local and directory-based naming
- Workload distribution via database services
- Creation of database service definitions
Listener Administration
- Operation of the default listener
- Setup of dynamic service registration
- Setup of static service registration
Shared Server Architecture Configuration
- Activation of the shared server mode
- Regulation of shared server processes
- Utilization of SGA and PGA memory structures
- Considerations for shared server configuration
Oracle Connect Manager Configuration
- Interpretation of Oracle Connection Manager functions
- Application of filtering rules
- Implementation of intranet and internet access controls
- Utilization of session multiplexing capabilities
- General configuration of Oracle Connection Manager
- Management of the cman.ora configuration file
- Configuration of client-side parameters
- Configuration of database server settings
- Operation of the Oracle Connection Manager control utility
PDB Provisioning
- Provisioning of new pluggable databases
- Creation of a PDB from PDB$SEED
- Application of the FILE_NAME_CONVERT clause
- Use of OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative methodologies for PDB creation
PDB Administration
- Modification of PDB operational modes
- Adjustment of PDB settings
- Revision of initialization parameters
- Execution of the Alter System Command within a PDB
- Configuration of hostname and port number for specific PDBs
- Deletion of PDBs
Database Storage Fundamentals
- Database storage architectural design
- Identification of core database structures
- Utilization of segments, extents, and blocks
- Management of tablespaces and data files
- Classification of segment types
- Storage mechanics for table data
- Content composition of database blocks
- Governance of deferred segment creation
- Monitoring of tablespace capacity utilization
Tablespace Administration
- Initialization of new tablespaces
- Definition of default permanent tablespaces
- Management of temporary tablespaces
- Modification and removal of tablespaces
- Implementation of Oracle Managed Files (OMF)
- Relocation or renaming of online data files
Space Utilization Optimization
- Interpretation of space management features
- Governance of block-level space
- Specification of table compression standards
Undo Data Governance
- Management of transactions and associated undo data
- Storage of undo information
- Configuration of undo retention policies
- Activation of temporary undo functionality
User Account Provisioning and Governance
- Identification of Oracle-supplied administrator accounts
- User authentication procedures
- Allocation of resource quotas
Privilege and Role Authorization Configuration
- Interpretation of system privileges
- Configuration of system-level privileges
- Administration of privilege assignments
User Resource Limit Configuration
- Governance of profiles and user accounts
- Interpretation of profile parameters
Oracle Database Audit Framework
- Interpretation of database security standards
- Implementation of auditing controls
- Development of Fine-Grained Auditing (FGA) policies
Data Loading and Transport Mechanisms
- Data migration strategies
- Methods for data loading
- Execution of data export and import processes
- Transportation of entire databases
Database Monitoring Protocols
- Performance management operations
- Maintenance of database integrity
- Interpretation of performance tuning methodologies
Database Process Architecture
- Analysis of process architecture and composition
- Utilization of various writer and monitor processes
Memory Governance
- Management of memory components
- Application of automatic memory management
SQL Analysis
- Utilization of the Oracle optimizer
- Optimization of access paths
- Implementation of SQL plan directives
Conclusion and Procedural Next Steps
Requirements
- Foundational knowledge of SQL
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
