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
- Exploration of Oracle database server architecture
- Insights into Oracle multitenant container databases
- Concepts of Oracle database instances and database sharding
Connecting to Oracle Database
- Establishing connections to an Oracle database instance
- Utilizing Oracle database tools
- Working with SQL*Plus
- Applying Oracle SQL developer
- Leveraging the Database Configuration Assistant (DBCA)
- Familiarizing with Enterprise Manager cloud control 13c capabilities
- Review of Oracle Enterprise Manager components
- Achieving a unified view for enterprise management
- Administration of the Oracle Enterprise Manager database
Establishing an Oracle Database
- Provisioning an Oracle database via DBCA
- Initializing an Oracle database through SQL commands
Operational Control of Database Instances
- Initiating an Oracle database instance
- Terminating an Oracle database instance
- Evaluating different shutdown modes
- Managing the opening and closing of PDBs
- Configuration of PDBs
Administration of Database Instances
- Application of initialization parameters
- Utilizing the automatic diagnostic repository
- Reviewing the alert log
- Interpreting trace files
- Administration of the DDL log file
- Utilizing dynamic performance views
- Interacting with the data dictionary
Fundamentals of Oracle Net Services
- Identification of Oracle Net Services components
- Setup and management of Oracle Net Services
- Review of the Oracle Net listener
- Comparison of dedicated versus shared server architectures
Naming Mechanisms
- Establishing Oracle network connectivity
- Comprehension of various naming methods
- Application of Easy Connect
- Implementation of local and directory naming
- Workload management via database services
- Creation of database services
Listener Management
- Utilizing the default listener
- Setup of dynamic service registration
- Setup of static service registration
Shared Server Architecture Configuration
- Activation of shared server mode
- Regulation of shared server operations
- Utilization of SGA and PGA resources
- Considerations for shared server configuration
Oracle Connect Manager Setup
- Understanding Oracle Connection Manager
- Application of filtering rules
- Implementation of access controls for intranet and internet
- Utilization of session multiplexing
- Configuration of Oracle Connection Manager
- Setup of the cman.ora file
- Client configuration
- Database server configuration
- Use of the Oracle Connection Manager control utility
Provisioning PDBs
- Provisioning new pluggable databases
- Creating a new PDB from 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 Administration
- Modification of PDB modes
- Adjustment of PDB settings
- Alteration of initialization parameters
- Use of the Alter System Command within a PDB
- Configuration of hostname and port numbers per PDB
- Removal of PDBs
Database Storage Concepts
- Database storage architecture
- Database structural elements
- 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 utilization
Tablespace Management
- Creation of tablespaces
- Definition of default permanent tablespaces
- Management of temporary tablespaces
- Alteration and removal of tablespaces
- Implementation of Oracle Managed Files (OMF)
- Relocation or renaming of online data files
Space Utilization Optimization
- Understanding of space management features
- Management of block space
- Specification of table compression
Undo Data Management
- Management of transactions and undo data
- Storage of undo information
- Configuration of undo retention
- Enablement of temporary undo
User Account Provisioning and Management
- Review of Oracle-supplied administrator accounts
- User authentication processes
- Assignment of quotas
Privilege and Role Authorization Configuration
- Understanding of system privileges
- Configuration of system privileges
- Management of privileges
User Resource Limit Configuration
- Management of profiles and users
- Understanding of profile parameters
Oracle Database Auditing
- Understanding of database security principles
- Implementation of auditing
- FGA policy application
Data Loading and Transfer
- Data migration processes
- Methods of data loading
- Data export and import procedures
- Database transport mechanisms
Database Monitoring
- Performance management activities
- Database maintenance procedures
- Understanding of performance tuning methodologies
Database Process Management
- Process architecture and structural components
- 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
- Application of SQL plan directives
Requirements
- Fundamental understanding of SQL
Intended Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.