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
- Foundational overview of Oracle Database server architecture
- Insights into Oracle multitenant container databases
- Exploration of Oracle database instances and database sharding concepts
Accessing Oracle Database
- Establishing connections to an Oracle database instance
- Leveraging Oracle database utilities
- Utilizing SQL*Plus for database interaction
- Working with Oracle SQL Developer
- Using the Database Configuration Assistant (DBCA)
- Examining the features of Enterprise Manager Cloud Control 13c
- Overview of Oracle Enterprise Manager components
- Achieving a single pane of glass for enterprise management
- Administering the Oracle Enterprise Manager database
Creating an Oracle Database
- Initiating database creation via DBCA
- Creating an Oracle database using SQL commands
Working with Database Instances
- Starting an Oracle database instance
- Shutting down an Oracle database instance
- Analysis of different shutdown modes
- Opening and closing Pluggable Databases (PDBs)
- Configuration of PDBs
Managing Database Instances
- Application of initialization parameters
- Utilizing the automatic diagnostic repository
- Reviewing the alert log
- Interpreting trace files
- Administration of the DDL log file
- Working with dynamic performance views
- Leveraging the data dictionary
Overview of Oracle Net Services
- Identification of Oracle Net Services components
- Configuration and management of Oracle Net Services
- Understanding the Oracle Net Listener
- Comparison of dedicated versus shared server architectures
Naming Methods
- Establishing Oracle network connections
- Comprehension of various naming methods
- Utilizing Easy Connect
- Implementation of local and directory naming
- Workload management through database services
- Creation of database services
Working with the Listener
- Utilization of the default listener
- Configuration of dynamic service registration
- Configuration of static service registration
Configuring a Shared Server Architecture
- Enabling the shared server model
- Control of shared server operations
- Management of SGA and PGA memory areas
- Considerations for shared server configuration
Configuring Oracle Connect Manager
- Understanding the role of Oracle Connection Manager
- Application of filtering rules
- Implementation of intranet and internet access controls
- Utilization of session multiplexing
- General configuration of Oracle Connection Manager
- Configuration of the cman.ora file
- Client configuration
- Database server configuration
- Use of the Oracle Connection Manager control utility
Creating PDBs
- Provisioning of new pluggable databases
- Creation of a new PDB from PDB$SEED
- Application of the FILE_NAME_CONVERT clause
- Utilization of OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative techniques for PDB creation
Managing PDBs
- Modification of PDB operating mode
- Adjustment of PDB specific settings
- Changes to initialization parameters
- Use of the Alter System Command within a PDB
- Configuration of hostname and port numbers per PDB
- Dropping PDBs
Understanding Database Storage
- Architecture of database storage
- Internal database structures
- Management of segments, extents, and blocks
- Utilization of tablespaces and data files
- Identification of segment types
- Storage of table data
- Content of database blocks
- Management of deferred segment creation
- Monitoring tablespace space usage
Managing Tablespaces
- Creation of tablespaces
- Definition of default permanent tablespaces
- Management of temporary tablespaces
- Alteration and dropping of tablespaces
- Implementation of Oracle Managed Files (OMF)
- Movement or renaming of online data files
Improving Usage Space
- Comprehension of space management features
- Management of block space
- Specification of table compression
Managing Undo Data
- Handling of transactions and undo data
- Storage of undo information
- Configuration of undo retention settings
- Enabling temporary undo
Creating and Managing User Accounts
- Review of Oracle-supplied administrator accounts
- User authentication processes
- Assignment of resource quotas
Configuring Privilege and Role Authorization
- Understanding system privileges
- Configuration of system privileges
- Management of privilege assignments
Configuring User Resource Limits
- Management of profiles and user limits
- Understanding profile parameters
Oracle Database Auditing
- Comprehension of database security principles
- Implementation of auditing strategies
- Application of Fine-Grained Auditing (FGA) policy
Loading and Transporting Data
- Methods for moving data
- Data loading techniques
- Exporting and importing data sets
- Transporting a complete database
Database Monitoring
- Performance management activities
- Database maintenance routines
- Understanding performance tuning methodologies
Database Processes
- Process architecture and internal structure
- Utilization of various writer and monitor processes
Managing Memory
- Management of memory components
- Implementation of automatic memory management
Analyzing SQL
- Utilization of the Oracle optimizer
- Optimization of access paths
- Use 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.
